EX19_AC_CH10_GRADER_HOE_AS- Payroll 1.1

Step

Instructions

Points Possible

1

Start Access. Open the downloaded Access file named Exp19_Access_Ch10_HOEAssessment_Payroll.accdb.Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files.

0

2

You will create an event-driven data macro that will populate a new field automatically each time a record is added to the table. Open the Employee table in Datasheet view, observe the data, and then switch to Design view. Add a new field, TenYearDate, with the data type Date/Time below the HireDate field. Save the table.

10

3

Create a data macro attached to the Before Change event. Use the SetField Action to populate the TenYearDate field in the table. The TenYearDate will always be 3,653 days after the HireDate. Save the macro. Close the macro. Save the table.

12

4

You will change type value in the first record, and then move to the second record to trigger the macro. The TenYearDate will be the date on which an employee receives a trip and a bonus from the company. Switch to Datasheet view of the Employee table. Retype the HireDate in the first record (EmpID 1) and press DOWN ARROW. The macro will be triggered and automatically fill in the TenYearDate with the employee's anniversary date.

6

5

Repeat the test on the second and third records (EmpID 2 and 3). Close the table.

6

6

Open the Main Menu form in Design view. Add a button below the Forms label that will open the Enter Employees form in the database. Set it at the 2" mark on the vertical ruler and the 1" mark on the horizontal ruler. Set the height of the button to 0.5" and the width to 1". The button should have the caption Enter Employees with the button named as cmdEnterEmployees.

12

7

Add a button below the Reports label that will print preview the Salaries by Gender report. Set it at the 2" mark on the vertical ruler and the 4" mark on the horizontal ruler. Set the height of the button to 0.5" and the width to 1". The first button should have the caption Salaries Report with the button named as cmdSalaries.

12

8

Save the form, switch to Form view, and then test the buttons. Close all objects except the Main Menu form.

0

9

Switch to Design view, add a Close Database button that exits Access to the top-right corner of the form, at the 0" mark on the vertical ruler and the 5" mark on the horizontal ruler, with a height of 0.5" and a width of 1". Name the button cmdQuit.

12

10

Modify the embedded macro in the On Click property of the cmdQuit button. Add a MessageBox action to the macro to display the message Check all updates before quitting! and set the Type to Information. Move the action up to before the QuitAccess action. Change the option under QuitAccess from Prompt to Exit. Save and close the macro.

12

11

Save the form, switch to Form view, and then set the Main Menu form to display when the database opens. Test the Close Database button. Reopen the database.

8

12

You want to modify the records displayed in the Salaries by Gender report. You will use an SQL statement to modify the record source so that only employees who live in Colorado display in the report. Open the Salaries by Gender report in Design view. Open the Property Sheet and click in the Record Source property box. Modify the existing SQL statement in the Record Source property of the report. The statement should select the same fields for employees where the State is CO. Save the report. Test the report in Print Preview and close the report.

10

13

Close all database objects. Close the database and then exit Access. Submit the database as directed.

0

Total Points

100