Reference no: EM132514597

Microsoft Access

Open the database (Access_Exercise.accdb) and use the table named "Employers" to do the following:

A) Create the above table and remane the table by your name, and then insert your information.

B) Create the following queries:
• Query that views all the information for employers their Countryis "UAE". Save it as Query1.
• Query that views the fields (Employer ID, First Name, Last Name and City) for all employers their Employer ID is greater than1600. Save it as Query2.
• Query that views the fields (Employer ID, First Name, Last Name and Company Name) for all employers their Company is "ADNOC" and theirEmployer ID is less than 3000. Save it as Query3.
• Query that view all the information for employee whose name start with "M" or their city is "abu dhabi".save it as query4
• Query that view all the information for the employee whose birthday in may, 2003. Save it as query5.

C) Create the following Columnar Form that views information based on Employers table. Save it as Employer.

D) Create the following Justified Form that views information based on Query1. Save it by UAE.

E) Create the following Report based on Query2, classified the report by company name, and also show the maximum employee ID . Save it as Query3 report