Morris Event Management Project Description: Sue Morris has a small event-planning business. She recently decided to transfer her company's data to a database. Although she has started on the database, she is too busy to finish it, so she has hired you to complete the implementation. Steps to Perform: Step Instructions Points Possible Start Access.
Open the downloaded Access file named a01cho2_grader_h1.
Save the file with the name a01ch02_grader_h1_LastFirst, using your last and first name. If necessary, enable the content.
Open tblClients in Design view. Define an input mask for Phone. Use a mask that will show phone numbers as (555) 555-5555 with a placeholder of _ and save with the symbols in the mask.
Change the length of State to 2. Change the field size of ZipCode to 5.
Save and close the table. Import the text decorations data stored in a01ch02_grader_h1_PlannerDec.txt into a new table.
The data is delimited and separated with commas. Choose your own primary key of Field1. Save the table as tblDecorations. Do not save the import steps.
Open tbl Decorations in Design view. Make the following changes to the fields: Current Field Name Field1 Field2 New Field Name Decoration IR Decoration Data Type Number Short Text Field Size Long Integer 20
Open tblDecorations in Design view. Make the following changes to the fields:
Current Field Name New Field Name Data Type Field Size
Field1 DecorationID Number Long Integer
Field2 Decoration Short Text 20
Field3 Color Short Text 10
Field4 Category Short Text 20
Add the description A unique identifier for the decoration to the DecorationId field. Save and close the table. Create a new table in Design view. This will be a junction table to allow the many-to-many relationship between tblDecorations and tblExents. Add the following fields using the corresponding data types (in this order):
Field Name Data Type Field Size
EventID Number Long Integer
Decoration ID Number Long Integer
Number Reserved Number Long Integer
Add the description The number of decorations reserved to the NumberReserved field. Create a composite primary key using EventID and DecorationID. Save the new table as tblEventDecoration. Close the table.
Open the Relationships window. Create a one-to-many relationship between ClientID in tblClients and ClientID in tblEvents. Enforce referential integrity. Do not cascade update or cascade delete.
Add tblEventDecoration to the window. Create a one-to-many relationship between EventID in tblEvents and EventID in tblEventDecoration. Enforce referential integrity. Do not cascade update or cascade delete.
