Access 2003: Advanced

Course Outline

Duration: 1 Day

Prerequisites: Access 2003: Intermediate or equivalent experience

Overview: Students will learn how to use a variety of complex query techniques, create more efficient forms and reports, and create and use macros to automate their forms. In addition, students will gain experience with Internet-related features, including hyperlinks and the Web toolbar.

Course Content:

Unit 1: Querying with SQL

Topic A: SQL & 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 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: MOS exam objectives map

Topic A: Comprehensive exam objectives