Microsoft Access 2007 - Level 3
Location: Latham
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 2007 -
Level 2 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
|
| Course Fee: $169 |
Members: $159 |
|
|
|
|
|
Upcoming Class Schedules |
|
# 3208 |
Fri Oct 29 |
8:30am-4:30pm |
|
