| | Applications II |
| | Lesson Number | Assignments | Length | Comments |
| | 1 | | Read p. 3-11; Do All Exercises. Save | 1 day | Key ideas in this lesson include how to |
| | terms on p. 8-10 on a "key terms" table in | open and close a database; what objects |
| | a file (Excel or Word) on your disk called | can be included in a database; and how |
| | "key terms." | to find information in a database. |
| | 2 | | Read p. 14-26; Do All Exercises. Then do | 1 day | Before accessing the main web page |
| | assignment for lesson 1 posted at the | (lesson1.html), you will encounter smaller |
| | Applications Web Site | "pop-up" windows; close those |
| | 3 | | Read p. 30-43; Do All Exercises. Print: | 2 days | Have your "Sundance Pet Supply" |
| | Applications 3.1, 3.2 (p. 46); Then do | database, with its Customers table, ready |
| | assignment for lesson 3 posted at the | on your disk. |
| | Applications Web Site |
| | 4 | | Read p. 48-61; Do All Exercises. Print | 2 days | Quiz on Lessons 1-4 ( AppIIQ1.doc ) |
| | "Customers" table on p. 52; Applications |
| | 4.1 and 4.2 (p. 63-64) |
| | 5 | | Read p. 66-89; DO All Exercises. Print | 2 days | Use Print Preview icon on Main Toolbar to |
| | 5.10 (p. 86); 5.11 (p. 87); Applications 5.1 | select the page in the autoform that |
| | and 5.2 (p. 90) | contains record 17 only. |
| | 6 | | Read p. 91-101; Do All Exercises. Print | 1 day | At this point, you may get "disk full" |
| | Applications 6.1 and 6.2 (p. 103) | errors; consult with me as to what may |
| | be erased from your disk. |
| | 7 | | Read p. 108-129; Do All Exercises. Key | 2 days | Worksheet on tables, forms, and reports |
| | terms on p. 107-116 into your Word | given after lesson 7 |
| | Glossary. Print 7.11 (after step 11 on p. |
| | 128); Applications 7.1 and 7.2 (p. |
| | 131-132) |
| | 8 | | Read p. 133-142; Do All Exercises. Print | 2 days | Lesson focuses on creating mailing labels |
| | 8.2 (p. 139); Review 8.1 & 8.2 (p. 143) | and the use of the label wizard. |
| | 9 | | Read p. 145-154; Do All Exercises. Print: | 1 day | This exercise focuses on creating |
| | 9.4 (p. 152) after step 7. Save | relationships among tables. When you link |
| | Applications 9.1 & 9.2 on your disk. | tables by creating relationships, you |
| | have fgreater control and flexibility over |
| | your database. |
| | 10 | | Read p. 158-169; Do All Exercises. Print: | 1 day | In this lesson, you will learn how to |
| | 10.1 (p. 159); 10.2 (p. 162) after step 3; | create relationships in order to have |
| | Applications 10.1 and 10.2 (p. 171) | multiple tables joined together. |
| | 11 | | Read p. 172-179; Do All Exercises. Print: | 1 day | Queries are among the most important |
| | 11.3 (p. 178); Applications 11.1 and 11.2 | objects created in Access, along with |
| | (p. 181) | Tables, Forms and Reports. |
| | 12 | | Read p. 182 - 191; Do All Exercises. Print: | 1 day | Whereas in Lesson 11 you learned to |
| | 12.1 (p. 184); 12.2 (p. 185); 12.3 (p. | create a query based on one criterion, |
| | 187); 12.5 (p. 191); Applications 12.1 and | here you will learn how to create a query |
| | 12.2 (p. 193) | that finds records based on two criteria. |
| | 13 | | Read p. 195 - 201; Do All Exercises. Print: | 1 day | This lesson covers : How to remove or |
| | 13.2 (p.197 after step 7); 13.3 (p. 199 | change fields in the query grid; how to |
| | after step 8); 13.4 (p. 201 after step 19); | create queries that let you enter criteria |
| | Application 13.1 (p. 203) | into a dialog box; and how to update or |
| | delete records within a table using |
| | queries. |
| | Friday, February 25, 2000 | Page 1 of 4 |