Access 2010/13/16 Advanced

Prerequisite: Has attended the Access Design and Implementation course or has equivalent knowledge.

Duration: One day

Course Topics	Course Topics
Action Queries * Action Queries * Delete, Append, * Make table and * Update action queries Other Special Queries * Self Join Queries * Duplicate & Unmatched Queries Scalability * Splitting networked databases * Splitting multi user databases * Using the database splitter Data Access Pages * Create and data access pages * Data access page design view * Accessing the database through data pages	Macros * Creating a Macro * Events * Debugging a Macro * Creating Macro Groups * Running Macros in Macro Groups * Converting macros to Modules (Visual Basic) * Simple modules Creating Automated Databases * Using macros to build a main menu * Macros that run automatically Security * Password protection, * Advanced Access and object permissions to DB objects