Corporate Training By Zack Academy - Access 2007/2010 - Advanced

Why Should You Take This Access 2007/2010 - Advanced Course?

This ILT Series course builds on the skills and concepts taught in Access 2007/2010: Intermediate. Students will learn how to query with SQL; create crosstab, parameter, and action queries; create macros; import, export, and link database objects; interact with XML documents; create hyperlink fields; optimize, split, and back up databases; password-protect and encrypt databases; and set Access options and properties. This course is task-based and focuses on real-world scenarios and challenges students’ face in their day to day environments. This course will help students prepare for the Access 2007 exam (77-605).

Taking this course will give you the skills necessary to effectively and efficiently:

• structure databases,
• create and format database elements,
• enter and modify data,
• create and modify queries,
• present and share data, and
• manage and maintain the overall database.

The Following Topics Will Be Covered:

1.  Querying with SQL:

• SQL and Access
• Writing SQL statements
• Attaching SQL queries to controls

2.  Advanced Queries:

• Creating crosstab queries
• Creating parameter queries
• Using action queries

3.  Macros

• Creating, running, and modifying macros
• Attaching macros to the events of database objects

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

5.  Importing, Exporting, and Linking:

• Importing objects
• Exporting objects
• Interacting with XML documents
• Linking Access objects
• Hyperlink fields

6.  Database Management:

• Optimizing resources
• Protecting databases
• Setting options and properties

Syllabus

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: Hyperlink fields

Unit 6: Database Management:

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