MicroKnowledge Access 2003 Advanced

Access 2003 Advanced

Explore SQL, use advanced query features, automate tasks and data entry with macros, share data with other Office programs. Optimize, replicate and synchronize databases.

Recommended Preparation: Access 2003 Intermediate or equivalent knowledge.

Lesson 1: Querying with SQL

SQL and Access
Writing SQL statements
Attaching SQL queries to controls

Lesson 2: Advanced queries

Creating crosstab queries
Creating parameter queries
Using action queries

Lesson 3: Macros

Creating, running, and modifying macros
Attaching macros to the events of database objects

Lesson 4: Advanced macros

Creating macros to provide user interaction
Creating macros that require user input
Creating the AutoKeys and
AutoExec macros
Creating macros for data transfer

Lesson 5: Importing, exporting, and linking objects

Importing objects
Exporting objects
Linking Access objects

Lesson 6: Database management

Optimizing resources
Replicating and synchronizing databases

Discussion: Security fundamentals

Protecting databases
Encrypting and decrypting databases