Corporate Training By Zack Academy - Access 2013 - Advanced

Why Should You Take This Access 2013 - Advanced Course?

This ILT Series course builds on the skills and concepts taught in Access 2013 - Basic and Access 2013 - Intermediate. This course will help students prepare for the Microsoft Office Specialist exam for Access 2013 (exam 77-424). For comprehensive certification training, students should complete the Basic, Intermediate, and Advanced courses for Access 2013.

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

• Create and manage a database
• Build tables
• Create queries 
• Create forms
• Create reports

The Following Topics Will Be Covered:

1.  Querying with SQL: 

• Topic A: SQL and Access
• Topic B: Writing SQL statements
• Topic C: Attaching SQL queries to controls

2.  Advanced Queries:

• Topic A: Creating crosstab queries
• Topic B: Creating parameter queries
• Topic C: Using action queries

3.  Macros:

• Topic A: Creating, running, and modifying macros
• Topic B: Attaching macros to the events of database objects

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

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

6.  Database Management:

• Topic A: Optimizing resources
• Topic B: Protecting databases
• Topic C: 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 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