Access Advanced

 

Lesson 1: Implementing Advanced Form Design

·       Add Controls to Forms

·       Set Form Controls

·       Create Subforms

·       Organise Information with Tab Pages

·       Enhance Navigation with Forms

·       Format a Form

·       Apply Conditional Formatting

Lesson 2: Using Data Validation

·       Form and Field Validation

·       Data Validation Using Controls

Lesson 3: Using Macros to Improve User Interface Design

·       Create a Macro

·       Restrict Records Using a Condition

·       Validate Data Using a Macro

·       Automate Data Entry Using a Macro

·       Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

·       Link Tables to External Data Sources

·       Manage a Database

·       Determine Object Dependency

·       Document a Database

·       Analyse the Performance of a Database

 

Lesson 5: Distributing and Securing a Database

·       Split a Database for Multiple User Access

·       Implement Security

·       Set Passwords

·       Convert an Access Database to an ACCDE File

Lesson 6: Managing Switchboards

·       Create a Database Switchboard

·       Modify a Database Switchboard

·       Set Startup Options