IFS 110 Computer Assignment 1

IFS 110 Computer Assignment 1

REVIEW ASSIGNMENTS
AC pages 40-41

Use Hours1.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. Movie1.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 40, copy the Hours1.mdb database located on my web page to a floppy disk by clicking on the following link. Home Work 1 Data File Access 2000 users click on the following link instead. Home Work 1 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 3  on page AC 40, after typing in the validation rule and text message, 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. Circle the changes made to validation rule and text message. This is page 1 of your outputs.
  3. In step 5  on page AC 40, change the hire date in the first record to 08/15/1990, use the steps in step 2 above to copy and paste the error message displayed into Word, then print the page with the header information as page 2 of the assignment.
  4. In step 7  on page AC 41, in letter f, instead of using the dimensions listed, make the text box the exact same size as the label (Employee Data Entry) directly above it. Align the left side of text box to that label.
  5. In step 7  on page AC 41, in letter g, print the form with your header information using the steps in step 2 above. This is page 3 of the assignment.
  6. In step 8  on page AC 41, in letter c, maximize the form before going on to step 9.
  7. In step 9  on page AC 41, use portrait instead of landscape orientation to print the screen for (Leonard Caruso) with your header information using the steps outlined in step 2 above. This is page 4 of the assignment.
  8. In step 12  on page AC 41, save dapHoursEmployees.html to your floppy drive instead of the folder mentioned. Open the page and print the first record (Leonard Caruso) with your header information by using the steps in step 2 above. This is page 5 of the assignment.
  9. Turn in these 5 pages together with your disk containing the revised Hours1.mdb file in the assignment folder with your name.

Number of pages required: 5

Return to IFS 110 Computer Assignments Menu !