Advanced Access 2003

Note: Although South Hills offers three levels of Access training, each class builds on concepts learned in the previous class. These classes are designed to be taken in series with each preceding level a prerequisite for the next. You need to be completely comfortable with concepts offered in the first Access class before you will benefit from the second or third.

Unit 1: Querying with SQL
Topic A: SQL and Access
Topic B: Writing SQL statements
Topic C: Attaching SQL queries to controls

Unit 2: Advanced queries
Topic A: Creating crosstab queries
Topic B: Creating parameter queries
Topic C: Using action queries

Unit 3: Macros
Topic A: Creating, running, and modifying macros
Topic B: Attaching macros to the events of database objects

Unit 4: Advanced macros
Topic A: Creating macros to provide user interaction
Topic B: Creating macros that require user input
Topic C: Creating the AutoKeys and AutoExec macros
Topic D: Creating macros for data transfer

Unit 5: Importing, exporting, and linking objects
Topic A: Importing objects
Topic B: Exporting objects
Topic C: Interacting with the XML documents
Topic D: Linking Access objects
Topic E: Working with Windows SharePoint Services

Unit 6: Database management
Topic A: Optimizing resources
Topic B: Replicating and synchronizing databases

Unit 7: Security fundamentals
Topic A: Protecting databases
Topic B: Encrypting and decrypting databases
Topic C: User-level security

Appendix A: Microsoft Office Specialist exam objectives map
Topic A: Comprehensive exam objectives