| ACCESS 2007 ADVANCE - COURSE OUTLINE |
|
| 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 |
- 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: Protecting databases
- Topic C: Setting options and properties
|
|
| Unit 7: Internet integration |
- Topic A: Hyperlink fields
- Topic B: Working with Outlook 2007
|
|
|