IFS 110 Computer Assignment 5

Hints and Corrections:

1. In step 1  on page AC 230, copy the Hours5.mdb database located on my web page to a floppy disk by clicking on the following link. Home Work 5 Data File Access 2000 users click on the following link instead. Home Work 5 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 230, this step in the book is unclear; the stuff under the 3rd heading in the book  labeled Description is not to be typed in the Description column of the database structure you can leave this column blank. You need to enter the stuff under the 3rd heading in the book  labeled Description as the data for the record of the tblCorporate table. After typing in the structure of the tblCorporate table print it 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 outputs.
3. After performing step 3  on page AC 230, add a label from the toolbox to the Report Header Section of the report that includes your name, class days and time, and the date separated by commas. Put the label above the unbound textbox that was just created. Center the label on the form and center the text within the label.
4. In step 5  on page AC 230, before closing the dmrptMaster report print it in design view using the steps in step 2 above. This is page 2 of the outputs.
5. In step 11  on page AC 230, before closing the qryEmployeesBySupervisor query print it in design view using the steps in step 2 above. This is page 3 of the outputs.
6. In step 17  on page AC 231, position tblSupervisors.DeptNo directly above the Dept No label in the tblSupervisors.DeptNo Header section, click the left sizing handle and pull it all the way to the left of the report making the control about 2 inches wide; position tblSupervisors.LastName directly above the Last Name label in the tblSupervisors.DeptNo Header section.
7. In step 20  on page AC 231, first place the unbound text box in the tblSupervisors.DeptNo footer section, click in the Page Header section to deselect the unbound text box, then press the F1 function key to explore, type calculate average in the ask a question box then click the Search command button, click calculate a value, click In a form or Report, in step 4 that displays in the Help description use the Build button method steps described, double-click functions folder, double-click Built-In functions folder, double-click Avg function in right-hand column, double-click «expr» to highlight it, double-click Queries folder, click qryEmployeesBySupervisor, double-click Hourly Rate to put it in the expression above. Click the OK button to close the expression builder dialog box. Format the text box as Currency in its property sheet. 
8. In step 21  on page AC 231, Print the report after previewing it, right-click on the screen report and click Print on the shortcut menu. This is page 4 of your outputs.
9. Turn in these 4 pages together with your disk containing the revised Hours5.mdb file in the assignment folder with your name.

Number of pages required: 4

Return to IFS 110 Computer Assignments Menu !