IFS 110 Computer Assignment 8

IFS 110 Computer Assignment 8

REVIEW ASSIGNMENTS
AC page 388

Use Hours8.mdb database from student data disk

If you want to practice first using the steps and database from the chapter click on the following link to download the movie file. Movie8.mdb
Note: This does not count for the homework as part of the assignment, it is only to be used for additional practice.

Hints and Corrections:

  1. In step 1  on page AC 388, copy the Hours8.mdb database located on my web page to a floppy disk by clicking on the following link. Home Work 8 Data File Access 2000 users click on the following link instead. Home Work 8 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 2  on page AC 388, print the error message box (2497) using the following steps, press Alt-Print Screen keys to copy the screen display to the clipboard. Open Word, click Edit menu, then Paste to get screen capture image into Word document. Type your first and last name, class and section number, and date at the top of the page using Word's header feature. Steps: Click the View menu, click Header and Footer drop-down menu, type your first and last name, press the Tab key on the keyboard, type class number (IFS 110) and section number or time class meets, press the Tab key on the keyboard, enter current date by pressing the Alt + Shift + D key combination on the keyboard. Click the Close button the the Header and Footer floating toolbar. Click Print Preview button, then click Print Button to print the page. Do not save the Word document when prompted to do so. This is page 1 of the assignment.
  3. In step 8  on page AC 388, add a 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 If Err.Number statement.
  4. In step 9  on page AC 388, after compiling the code, print the code for frmReportsSwitchboard before testing the form by clicking File, then Print, and clicking the OK button. After printing the code, circle the code statements and the comment that you added.
  5. In step 11  on page AC 388, print the error message box as page 3 of the assignment using step 2 above as a guide. 
  6. Turn in these 3 pages together with your disk containing the revised Hours8.mdb file in the assignment folder with your name.

Number of pages required: 3

Return to IFS 110 Computer Assignments Menu !