employee database

After watching the video on How to Build an Employee Database with Microsoft Access, create a table in Access that includes information from Apply 4.1.

Computer Tech Support : How to Build an Employee Database With Microsoft Access

• Generate a table. Name the table Employees.
• Populate the information from Apply 4.1 in the corresponding order as directions state below. 
• For numbers that are in dollar value ensure to add the dollar sign before you enter the first number, otherwise, it will not register the dollar sign in all other numbers in the column (see error example in table below under hourly wages).
• Once you have populated all of the information in the table, next click on the home tab then locate the “sum of all” total and click on it. This function will add an extra line at the bottom of your last entry.
• The following must be shown and done:
• For the Employee ID column click on that new cell and report count.
• Input first name and last name.  
• For the hours worked column, report the average hours worked.
• For the hourly wage column, report the average wage.
• For the gross pay column, report the sum of all.
• For the taxes column, report the average.
• For the net pay, report the average.
• Make sure all of your columns are aligned to the right.
• Save your document.
• Once you have saved it, right-click your table under all-access objectives then choose export then choose PDF or XPS.
• This will generate a PDF document for you. Follow the file naming convention below and submit.

Your Access document pdf should look something like this (note the information in the table is wrong intentionally):