Access 2010 Advanced Skills

Students taking this course are database administrators or prospective database administrators who have experience working with Access 2010 and need to learn advanced skills. 

In this course, students learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multi-user access and more.

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 AutoKeys and AutoExec macros
• Topic D: Creating macros for data transfer

Unit 5: Importing, exporting, and linking objects

• Topic A: Importing objects
• Topic B: Exporting objects
• Topic C: Working with XML documents
• Topic D: Linking Access objects
• Topic E: Using hyperlink fields

Unit 6: Database management

• Topic A: Optimizing resources
• Topic B: Protecting databases
• Topic C: Setting options and properties