Training: Access – Advanced

Module 1: Implementing Advanced Form Design

• Lesson 1: Add Controls to Forms
• Lesson 2: Enhance Navigation and Organization of Forms
• Lesson 3: Apply Conditional Formatting

Module 2: Sharing Data Across Applications

• Lesson 1: Import Data into Access
• Lesson 2: Export Access Data
• Lesson 3: Link Tables to External Data Sources
• Lesson 4:Create a Mail Merge

Module 3: Using Macros to Improve User Interface Design

• Lesson 1: Create a Macro
• Lesson 2: Restrict Records Using a Condition
• Lesson 3: Validate Data Using a Macro
• Lesson 4: Automate Data Entry Using a Macro

Module 4: Using VBA

• Lesson 1: Getting Started with VBA
• Lesson 2: Enhance Access Using VBA

Module 5: Using Advanced Database Management

• Lesson 1: Manage a Database
• Lesson 2: Determine Object Dependency
• Lesson 3: Document a Database

Module 6: Distributing and Securing a Database

• Lesson 1: Splitting a Database for Multiple User Access
• Lesson 2: Implement Security
• Lesson 3: Convert an Access Database to an ACCDE File
• Lesson 4: Package a Database with a Digital Signature

Module 7: Managing Switchboards

• Lesson 1: Create a Database Switchboard
• Lesson 2: Modify a Database Switchboard
• Lesson 3: Set Startup Options