Advanced Microsoft Access 2007

Duration: 12 hours

Description: Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; work with XML documents; optimize databases; password-protect and encrypt databases; set Access options and properties; create hyperlink fields; and use Outlook 2007 to update data.

Objective: The student will learn to use numerous features in an Access database.

Course Content:

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 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