| Module 01 | |||
| Add Controls to Forms | 00:11:00 | ||
| Enhance Navigation and Organization of Forms | 00:14:00 | ||
| Apply Conditional Formatting | 00:04:00 | ||
| Module 02 | |||
| Import Data into Access | 00:08:00 | ||
| Export Access Data | 00:06:00 | ||
| Link Tables to External Data Sources | 00:05:00 | ||
| Create a Mail Merge | 00:02:00 | ||
| Module 03 | |||
| Create a Macro | 00:08:00 | ||
| Restrict Records by Using a Condition | 00:04:00 | ||
| Validate Data by Using a Macro | 00:05:00 | ||
| Automate Data Entry by Using a Macro | 00:04:00 | ||
| Module 04 | |||
| Manage a Database | 00:08:00 | ||
| Determine Object Dependency | 00:04:00 | ||
| Module 05 | |||
| Manage a Database | 00:07:00 | ||
| Determine Object Dependency | 00:04:00 | ||
| Document a Database | 00:04:00 | ||
| Module 06 | |||
| Splitting a Database for Multiple User Access | 00:05:00 | ||
| Implement Security | 00:03:00 | ||
| Convert an Access Database to an ACCDE File | 00:04:00 | ||
| Package a Database with a Digital Signature | 00:01:00 | ||
| Module 07 | |||
| Create a Database Switchboard | 00:05:00 | ||
| Modify a Database Switchboard | 00:02:00 | ||
| Set Start up Options | 00:04:00 | ||
| Mock Exam | |||
| Mock Exam- Microsoft Access Advanced Level | 00:20:00 | ||
| Final Exam | |||
| Final Exam- Microsoft Access Advanced Level | 00:20:00 | ||