Open MS Access, create a database named orderManagement and perform the following tasks:

1. Create a table named Customers having the following structure.

Field Name	Date type
CustomerID	Auto Number
customerFName	Text
customerLName	Text
customerGender	Lookup Wizard (Only Two values Male, Female)
customerAddress	Text
customerCountry	Text
customerPhone	Text

Notes

• Set the field CustomerID as the primary key.
• Set the Field Size field property of the fields customerFName and customerLName to 50.

2. Create a table named Employee having the following structure.

Field Name	Date type
employeeID	Auto Number
employeeLName	Text
employeeFName	Text
employeeAddress	Text
employeeHireDate	Date/Time
employeePHone	Text

Notes

• Set the field employeeID as the primary key.
• Set the Field Size field property of the fields employeeLName and employeeFName and employeeAddress to 50.

3. Create a table named Order having the following structure.

Field Name	Date type
orderID	Auto Number
customerID	Number
employeeID	Number
orderDate	Date/Time
orderAmount	Currency

Notes

• Set the field orderID as the primary key.

4. Create a relationship between the customerID field in the Order table and the customerID field in the Customers table. Put a checkmark in the box labeled Enforce Referential Integrity.
5. Create a relationship between the employeeID field in the Order table and the employeeID field in the Employee table. Put a checkmark in the box labeled Enforce Referential Integrity.
6. Fill at least 4 records in each table.

7. Create the following queries:

• Query 1: List all the details of the orders that are submitted by any customer whose first name is Ali. Sort the query in ascending order according to the orderAmount field. Save this query as orderAli.

• Query 2: List all of the details of orders that are served by the employee number 6. Save the query as orderEmp6.
• Query 3: List all the details of the employees whose address is Salalah. Save this query as empSalalah.
• Query 4: List all the details of the customers who are female and whose country is Oman. Save this query as custFemaleOman.
• Query 5: List the details of all the orders whose amount is greater than 500. Sort the query in ascending order according the orderID field. Save the query as orderAbove500.

8. Create forms for each of the above forms and queries.
9. Create a report on the basis of the query named custFemaleOman. Save the report as rpt_custFemaleOman.
10. Use the Report Wizard to create a report having the following requirements:
    • Select the customerLName field from the Customers table.
    • Select the orderID, orderDate and orderAmount fields from the Order table.
    • Add a grouping level using customerLName.
    • Sort the report by the orderID field in ascending order.
    • Choose Stepped layout and Portrait orientation.
    • Type Order List as the reports title.
    • Save the report as rpt_orderByLname
11. Create a menu form from which the user can access to above forms and reports.