IFS 110 Computer Assignment 9

Hints and Corrections:

1. In step 1  on page AC 436, copy the Homes9.mdb database located on my web page to a floppy disk by clicking on the following link. Home Work 9 Data File Access 2000 users click on the following link instead. Home Work 9 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. Use the following steps to print your pages. 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. 
3. In step 2  on page AC 436, use pages AC 402 - AC 404 up to step 6 as guideline to create the 2 column list box in this step. Make the following substitutions when using the steps from pages AC 402 - AC 403.
   1. In step 4 on page 402, choose tblSubdivisions instead of tblTimeCards
   2. In step 5 on page 402, choose SubdivisionID and SubDivisionName instead of TimeCardID and TimeCardDate
   3. In step 6 on page 403, do not clear the Hide key column check box or else the SubdivisionID will show in the List Box
   4. In step 7 on page 403, choose SubDivisionName instead of TimeCardID, note this box might not display on some machines, so don't print it out in the steps listed below.
   5. In step 8 on page 403, type lstFind instead of  Select Time Card
4. Use the List Box Wizard printing out each step used in the Wizard except for the dialog box for step 7 on page 403. This is the first 5 pages of your assignment.  Use step 2 listed above as a guideline to print your steps.
5. When using the Query Builder  make the following substitutions when using the steps from pages AC 403 - AC 404.
   1. In step 2 on page 403, choose tblLots instead of tblEmployees
   2. In step 3 on page 403, choose Address  instead of LastName and put it in the 3rd not 1st column of the QBE grid. Make sure SubdivisionID is not shown in the fields in the QBE grid at the bottom, deselect the Show/Hide check box. Sort the SubDivisionName and Address fields in Ascending order.
   3. Before doing step 4 on page 404, Print out your Query Builder screen that looks like Figure 9-14. This is page 6 of your assignment. Right-click on the Query Builder screen and select SQL view on the short-cut menu, click in an open area of SQL screen to deselect the statements, print out the SQL statements listed on screen. This is page 7 of your assignment. Use step 2 listed above as a guideline to print your pages.
   4. In step 5 on page 404, Blank out the Column Widths property of the List Box. Set the Bound Column property of the List Box to 2.
   5. In step 6 on page 404, make the list box about 3 inches wide and 1 3/4 inches high on the form. Move the label above the list box and change its caption to "Select a Lot:". 
6. In step 3  on page AC 436, if you need to add the Microsoft DAO Object Library see steps at bottom of page AC 405 and page AC 406. Set the Name property of the command button as "cmdFind" and the Caption property as "Find Record" so that the letter F is underlined as the keyboard access key (Alt-F). (see steps 7 & 8 at bottom of page 404 as guideline) 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 all of your code statements. After typing in the code turn to page AC 408 in the book and perform steps 3 and 4 to enable the Find button after choosing a lot. Add a comment explaining this code statement. Circle this comment and code after printing it out in step 10 listed below.
7. In step 4  on page AC 436, Set the Name property of the command button as "cmdCancel" and the Caption property as "Cancel" so that the letter C is underlined as the keyboard access key (Alt-C). Make each command button the same size. 
8. In step 5  on page AC 436, add a comment statement above the code in this step explaining what the code does (basically the comment is contained in the description of step 5). 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 all of your code statements. Print the code for frmLots before testing the form by clicking File, then Print, and clicking the OK button. Circle the comment statement with your name. This is page 8 of your assignment.
9. In step 6  on page AC 436, use steps 1-4 on page AC 410 as a guideline.
10. After completing step 6 on page AC 436, print the code for frmFindLots before testing the form by clicking File, then Print, and clicking the OK button. Circle the comment statement with your name. This is page 9 of your assignment. 
11. When testing the program open frmLots in form view, double-click the Address field, form (frmFindLots) should open, print the screen at this point using the Print Screen key, see step 2 above as a guideline. This is page 10 of the assignment. Double-click on an address, the new address should now be displayed in form frmLots.
12. Turn in these 10 pages together with your disk containing the revised Homes9.mdb file in the assignment folder with your name.

Number of pages required: 10

Return to IFS 110 Computer Assignments Menu !