Course Curriculum
| Module 1: Improving the Structure of a Database | |||
| Using the Table Analyzer Wizard | 00:09:00 | ||
| Append Querying to Normalize a Table | 00:10:00 | ||
| Creating a Junction Table | 00:06:00 | ||
| Module 2: Maintaining a Database | |||
| Backup Up a Database | 00:03:00 | ||
| Using the Compact and Repair Database Tool | 00:03:00 | ||
| Using the Object Dependencies Tool | 00:03:00 | ||
| Module 8: Using the Database Documenter Tool | 00:02:00 | ||
| Using the Analyze Performance Tool | 00:02:00 | ||
| Module 3: Working with Navigation Forms and Startup Options | |||
| Creating a Navigation Form | 00:03:00 | ||
| Modifying a Navigation Form | 00:05:00 | ||
| Setting the Startup Options | 00:03:00 | ||
| Module 4: Configuring Access for Multiple Users | |||
| Using the Database Splitter | 00:04:00 | ||
| Configuring Trusted Locations | 00:03:00 | ||
| Password Protecting a Database | 00:04:00 | ||
| Password Protecting Modules | 00:02:00 | ||
| Converting a Database to an ACCDE File | 00:02:00 | ||
| Module 5: Automating Processes with VBA | |||
| Understanding VBA Basics | 00:03:00 | ||
| Exploring Variables and Control Flow Statements | 00:10:00 | ||
| Exporting a Table or Query with VBA | 00:09:00 | ||
| Converting a Macro to VBA | 00:02:00 | ||
| Module 6: Using Table Events | |||
| Understanding Table Events | 00:02:00 | ||
| Using the Before Change Event Command | 00:07:00 | ||
| Using the After Update Event Command | 00:04:00 | ||
15 STUDENTS ENROLLED












