Question

Module 2 Course Work

1. Read Pages 12-30.
2. Use the week 1 video's and this week's reading to complete Lab 1.

Lab 1

This week’s assignment must be done using Microsoft Access.

Please use this assignment as a rubric.

Cross-off each step as you complete it.

1. Create a new Access Database. Name the database using your name.
2. 
   Create a table called Address.
3. 
   Within the Address table create the following fields:
4. 
   FirstName
5. LastName
6. 
   StreetAddress
7. 
   City
8. 
   State
9. 
   Zipcode
10. 
    Telephone
11. Please note:
    (Database table and field names should never contain spaces)
12. 
    Default data should be text.
13. 
    Primary Key is the first and last name.
14. 
    (Please research how to create 2 primary keys in a table.)
15. Create another table named Event.
16. 
    In the Event table create one field named EventName.
17. 
    The data entered in the EventName field should be text data.
    Primary Key is EventName.

18. Create another table named Price
19. 
    In the Price table create one field named Package.
20. 
    Primary key is Package.
21. 
    Create another field named Amount.
22. 
    Create a third field named Discount.
23. 
    Insert 5 records in the address table – make up the data.
24. 
    Insert the name of five holidays in the Event table.
25. 
    Do not insert any records into the Price table.

26. Save your database with your firstnamelastname (no spaces).
27. 
    Upload this database by the deadline. See below

Answer 1

Open Micro-soft Access database application:

Creating Address Table:

Next, to create a new table follow the below screenshots:

Similarly, right-click on the table and click on the DesignView : Given a table name as "Event"

Similarly, some steps to be followed to create a table called "Price" and set two fields of Price table namely

"Package" of text type and "Amount" of Number type. The final Price table is shown below.

Insert 5 sample records in the address table:

Double click on the Addres table to insert 5 sample records

Insert the name of five holidays in the Event table:

Double click on the Event table to insert 5 random holidays into Event table

Note : No records are inserted into the Price table.