Question
Employee Performance Project Description: You have been asked to modify an Employees database that tracks employee data, company locations, and performance and bonus information. You
Employee Performance
Project Description:
You have been asked to modify an Employees database that tracks employee data, company locations, and performance and bonus information. You will import a spreadsheet from Excel and a text file into the database. You will add a hyperlink field that will store a URL for each city where the company has a location. You will also add an Attachment field that will store employee photos. You will then use imported data to enhance a query in the database, create a report, and then export it to a PDF document.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step | Instructions | Points Possible |
1 | Start Access. Open the downloaded Access database named exploring_a08_Grader_a1.accdb. Save the database as exploring_a08_Grader_a1_LastFirst. | 0 |
2 | Create a new table in the database by importing the downloaded workbook named a08c2Location.xlsx. Use the first row of the worksheet as column headings, set LocationID as the primary key, and import the table as Location. Accept all other default options. Do not save the import steps. | 8 |
3 | Create a table in the database by importing the downloaded text file named a08c2Titles.txt. Use the first row of the file as field names, TitleID as the primary key, and name the table Titles. Accept all other default options. Do not save the import steps. | 8 |
4 | In the Employees table, add an Attachment field named Photo as the last field. | 8 |
5 | Add the downloaded image file KFleming.jpg for EmployeeID 3 to the Employees table. | 4 |
6 | Add the downloaded image file PBrumbaugh.jpg for EmployeeID 17 to the table. Close the table. | 4 |
7 | In the Location table, add a Hyperlink field named CityInfo as the last field. | 8 |
8 | Add the URL http://en.wikipedia.org/wiki/Atlanta as the CityInfo value for Atlanta in the Location table. | 4 |
9 | Add the URL http://en.wikipedia.org/wiki/Pittsburgh as the CityInfo value for Pittsburgh. Close the table. | 4 |
10 | Open the Performance query in Design view (right-click the query in the Navigation Pane and then select Design View). Add the newly imported Titles table to the query window. Drag and drop the Title field over the Performance field in the query design grid so that it is in the third field position. The query will calculate the raises for the employees based on data in the Titles table. | 8 |
11 | Add the Photo field from the Employees table to the last position in the query. Run the query to view the new salaries, bonuses, and employees on probation for poor performance reviews. | 8 |
12 | Set the criteria in the query so that only employees on probation will display and then run the query. Note that these employees will receive no bonus. Modify the criteria to display employees who are not on probation. Run, save, and then close the query. | 8 |
13 | Create a simple report based on the Performance query. In Layout view, delete the Probation and PercentIncrease fields. Adjust the column widths so that they all fit within the page, but the data is still visible. | 8 |
14 | In Design view, move the page numbering control to the left so that its right edge is just inside the 7.5-inch mark on the horizontal ruler. Drag the right edge of the report to the left so that it is just inside the 8-inch mark on the ruler. View the report in Print Preview; the report should consist of five pages. | 4 |
15 | Modify the report title as Performance Reviews and delete the logo to the left of the title. | 4 |
16 | Save the report as Employees in Good Standing and close the report. Export the report as a PDF document using the same name and publish the report. Open the report in your reader program and close the report. Do not save the export steps. | 4 |
17 | Open the Performance query in Design view. Add the newly imported Location table to the query window. Drag and drop the Location field over the LastName field in the query design grid so that it is in the first field position. Sort the records by Location in ascending order. Run, save, and then close the query. Compact and repair the database. | 8 |
18 | Save the database. Close the database, and then exit Access. Submit the database as directed. | 0 |
| Total Points | 100 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started