create a database named “orderManagement” and perform the following tasks:1. Create a table named “Customers” having the following structure.Field NameDate typeCustomerIDAuto...

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: o Select the customerLName field from the Customers table. o Select the orderID, orderDate and orderAmount fields from the Order table. o Add a grouping level using customerLName. o Sort the report by the orderID field in ascending order. o Choose Stepped layout and Portrait orientation. o Type Order List as the report’s title. o Save the report as rpt_orderByLname 11. Create a menu form from which the user can access to above forms and reports.