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
Creating SQL-specific queries

Lesson 2: Advanced queries

Creating crosstab queries
Creating parameter queries
Using action queries

Lesson 3: Macros

Creating, running, and modifying macros
Attaching macros to events

Lesson 4: Advanced macros

Using data validation macros
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 data from Access
Importing data from Excel
Exporting data to Access
Exporting data to Excel
Linking Access objects

Lesson 6: Database management

Using a database in a network environment
Optimizing resources
Replicating and synchronizing databases

Lesson 7: (Discussion) Security Fundamentals

Protecting databases
Encrypting and decrypting databases
User level security