Create the table and remane the table

Assignment Help Basic Computer Science

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

Reference no: EM132514597

Questions Cloud

Computation of the sample standard deviation : In the computation of the sample standard deviation, how many degrees of freedom are there in a data set that has 15 data values?

What will be the total dollar increase or decrease in income : A year ago, Jucky Cola,If Jucky buys from The Stamp, what will be the total dollar increase or decrease in income for the next four years?

Sunflower yield to chemically and organically grown : Develop the Coefficient of Correlation for the Sunflower yield to Chemically and Organically grown.

Find how much should the company be willing to pay : Find how much should the company be willing to pay for one additional minute of grinding machine time if the company has made the best use

Create the table and remane the table : Create the Columnar Form that views information based on Employers table. Save it as Employer - Create the following Report based on Query2

How the endorsement influenced your decision to buy product : "In Sneaker Wars, It's Also Curry (Under Armour) vs. James (Nike)", on the use of celebrity endorsements in the competition between Nike and Under Armour.

Average amount of time spent watching television : Perform a hypothesis test to determine whether the average amount of time spent watching television per week has decreased from the previous mean of 21.8 hours.

Health insurance portability and accountability act : Legal issues in health care include violation of patient privacy laws and regulations, such as the Health Insurance Portability and Accountability Act (HIPAA);

What is the probability that the sample mean : A population has a mean of 400 and a standard deviation of 90. Suppose a sample of size 125 is selected and is used to estimate.

User Account

All Pages