Complete each specific task listed below:

1 Open Microsoft Access, and create a new database called CCC (standing for Clean Clothes Company).

2 Create a table called Customers. The attributes of the Customer table are the following:

Customer_Id (Primary Key)

Lastname

Firstname

SAddress

City

State

ZipCode

Phone

Email

3 Create a table called Garments. The attributes of the Garments table are the following:

Garment_Id (Primary Key)

Garment_Type

4 Create a table called Transactions. The attributes of the Transactions table are as follows:

Transaction_Id (Primary Key)

Customer_Id (Foreign Key)

Clothing_Id (Foreign Key)

DropOffDate

PickUpDate

5 Create a relationship diagram linking all three tables together.

6 Create forms for each of the three tables.

7 For each table, add new data via the following forms:

For the Customer table, add data for at least 10 Customers. You can be creative and make up the names, phone numbers and e-mail addresses for all customers. For address data use the names of actual cities, states and zip codes.

For the Garment table, add 4 different types of clothing that you are familiar with e.g. coat, jacket.

For the Transactions table, add 10 different transactions associated with the Customer table. For Transactions make-up 5 that happened in 2018 and 5 that happened in 2019.

8 Write a query to show the names and phone numbers of all customers.

9 Write a query to show names of all the customers who used the Rush service (Note: Rush refers to jobs that have the same drop off and pick up dates).

10 Write a query to show names of all the customers who used the dry cleaning services prior to January 15, 2019.

11 Create two different reports for this database.