Question

Arrange the entries in Microsoft Excel. When entering your information, ensure that you are formatting the cells so that the information will transfer well into Access for the appropriate data type. Enter the provided employee records with a range of staff and hourly employees. Once the data has been entered, create a chart on a new sheet that graphically represents a comparison of the hourly employees and salaried employees.

Answer 1

Week 6:

Upload your Completed Excel Worksheet and Access Database with Imported Data and Tables

By the end of this week you will submit your completed Excel worksheet with employee data and created chart. You will also need to submit your Access Database with imported Excel data and two tables containing employee personal information

and workplace information. Now that the information has been entered and formatted in Excel, import the data into Microsoft Access as ADP has requested. Arrange the data into two tables: Personal Information and Workplace Information. Important Note: The employees names (first and last) need to appear in both tables.

Week 7:

Upload your Completed Access Database & One-page Narrative

By the end of this week you will submit your completed Access database with tables, queries, forms, and report. You will also need to submit a one-page narrative that answers the three questions provided below.

Your next steps for Week 7 are to

: • Join the two (2) tables based on the Last Name field with referential integrity enforced.•

Perform a simple query based on the two (2) tables using any criteria you feel appropriate.•

Create a parameter query based on the two (2) tables using any criteria you feel applicable.•

Produce a form based on the records in the Personal Information table. Select a form design you believe represents the data in the most professional manner