Access 2000: Introduction to
Application Development
Course Summary

Lesson 1: Designing Applications

Approximate Time: 30

Exercise File(s) Needed: 3Twin Pines.mdb and 3Contacts.mdb

Summary of Objectives: Students examine the application development process, preview an existing application, and decide where to automate your application

Lesson 2: Using Advanced Tools and Controls

Approximate Time: 30

Exercise File(s) Needed: 3Trailer Park1.mdb, 3Trailer Park2.mdb, 3Contacts1.mdb, and 3Contacts2.mdb

Summary of Objectives: Students use the Performance Analyzer, use a combo box to find records, and calculate values from subform controls

Lesson 3: Creating Dialog Boxes

Approximate Time: 30

Exercise File(s) Needed: 3Trailer Park3.mdb, 3Contacts3.mdb, and 3Contacts4.mdb

Summary of Objectives: Students set dialog box form properties, add dialog box controls, and enhance dialog boxes

Lesson 4: Using Macros

Approximate Time: 35

Exercise File(s) Needed: 3Trailer Park4.mdb, 3Contacts5.mdb, and 3Contacts6.mdb

Summary of Objectives: Students create macros, attach macros to events on forms, use the Macro Builder, create conditional macros, and create macro groups

Lesson 5: Controlling Data Entry

Approximate Time: 40

Exercise File(s) Needed: 3Trailer Park5.mdb, 3Contacts7.mdb, and 3Contacts8.mdb

Summary of Objectives: Students restrict user access to fields, set form properties, set the open mode, close forms automatically, specify default values for fields, and conditionally set the visible property

Productivity Builder 1

Approximate Time: 30

Exercise File(s) Needed: 3Sharks1.mdb and 3Sharks2.mdb

Lesson 6: Using Dialog Boxes to Get Report Criteria

Approximate Time: 25

Exercise File(s) Needed: 3Trailer Park6.mdb, 3Contacts9.mdb, and 3Contacts10.mdb

Summary of Objectives: Students create a dialog box for a report, modify underlying queries, modify reports, and test and refine dialog boxes

Lesson 7: Creating Custom Switchboards

Approximate Time: 20

Exercise File(s) Needed: 3Trailer Park7.mdb, 3Contacts11.mdb, and 3Contacts12.mdb

Summary of Objectives: Students create switchboard forms, create macros for switchboard controls, and assign macros to switchboard controls

Lesson 8: Enhancing Applications

Approximate Time: 25

Exercise File(s) Needed: 3Trailer Park8.mdb, 3Contacts13.mdb, and 3Contacts14.mdb

Summary of Objectives: Students create keyboard shortcut macros, create control tips and status bar messages, set startup properties, and adjust objects and view enhancements

Lesson 9: Using Database Utilities

Approximate Time: 25

Exercise File(s) Needed: 3Trailer Park9.mdb, 3Contacts15.mdb, 3Contacts16.mdb, and 3Contacts16_be.mdb

Summary of Objectives: Students use the Database Splitter, use the Linked Table Manager, compact and repair a database, convert a database to a previous version, and backup and restore a database

Lesson 10: Protecting and Replicating Databases

Approximate Time: 40

Exercise File(s) Needed: 3Trailer Park10.mdb, 3Contacts17.mdb, and 3Contacts18.mdb

Summary of Objectives: Students set record locking, open databases in Exclusive mode, use database passwords, encrypt and decrypt databases, and replicate and synchronize databases

Productivity Builder 2

Approximate Time: 30
Exercise File(s) Needed: 3Sharks3.mdb and 3Sharks4.mdb
Total Exercise File Size for Course: 12 MB
Approximate Length of the Course: 6 hours

Responsibility of the Student

Each student must study all information learned in the course after normal classroom hours so that he/she may gain a firmer grasp of the information covered. This allows students to detect any weak areas that they may have and enables them to seek out the assistance of the instructor. 

Back to Course Outlines