IFS 110 Computer Assignment 7

Hints and Corrections:

1. In step 1  on page AC 340, copy the Hours7.mdb database located on my web page to a floppy disk by clicking on the following link. Home Work 7 Data File Access 2000 users click on the following link instead. Home Work 7 Data File Click the Open button on the first dialog box that appears to start the download, click the Unzip button on the second dialog box, click the OK button on the third dialog box to verify the successful unzip, click the Close button on the second dialog box after unzipping the file to your floppy disk.
2. In step 4  on page AC 340, the comment should read ('Set strName equal to report chosen in the option group) instead of ('Set strReport equal to report chosen in the option group) Also add an additional comment statement to the code in this step with your name, class days and time, and the date separated by commas. Put the comment above the Set strName comment statement.
3. In step 7  on page AC 341, the two coded lines that end with (&), should be changed to (& _ ) if you are going to use the spacing in the book. The underline character is the line continuation character, used to put one logical line of code on two physical lines. Also add an additional comment statement to the code in this step with your name, class days and time, and the date separated by commas. Put the comment above the Build the WhereCondition comment statement.
4. After completing step 8  on page AC 341, Print the code for cmdPreview _Click  and grpEmployees_AfterUpdate subroutines by clicking File, then Print, and clicking the OK button. Circle the comment statements with your name. This is page 1 of the outputs.
5. Before doing step 9  on page AC 341,  add a label from the toolbox to the Report Header Section of the Employee List and Employees By Department reports in Design View that includes your name, class days and time, and the date separated by commas. Put the label above each report's Main Title. Center the labels on the form and center the text within each label.
6. In step 9  on page AC 341, when testing different combinations, click the Terminated check box then click the Employee List option button, print the resulting report as the 2nd page of the outputs. Select Engineering from the Department list box, then click the Employees By Department option button, print the resulting report as the 3rd page of the outputs. To Print the two Reports with the reports showing on the screen, Right-click the report and click Print on the shortcut menu.
7. Turn in these 3 pages together with your disk containing the revised Hours7.mdb file in the assignment folder with your name.

Number of pages required: 3

Return to IFS 110 Computer Assignments Menu !