Microsoft Access 365: Part 2

Lesson 1: Implementing Advanced Form Design

• Topic A: Add Controls to Forms
• Topic B: Set Form Controls
• Topic C: Create Subforms
• Topic D: Organize Information with Tab Pages
• Topic E: Enhance Navigation with Forms
• Topic F: Format a Form
• Topic G: Apply Conditional Formatting

Lesson 2: Using Data Validation

• Topic A: Form and Field Validation
• Topic B: Data Validation Using Controls

Lesson 3: Using Macros to Improve User Interface Design

• Topic A: Create a Macro
• Topic B: Restrict Records Using a Condition
• Topic C: Validate Data Using a Macro
• Topic D: Automate Data Entry Using a Macro
• Topic E: Convert a Macro to VBA

Lesson 4: Using Advanced Database Management

• Topic A: Link Tables to External Data Sources
• Topic B: Manage a Database
• Topic C: Determine Object Dependency
• Topic D: Document a Database
• Topic E: Analyze the Performance of a Database

Lesson 5: Distributing and Securing a Database

• Topic A: Split a Database for Multiple User Access
• Topic B: Implement Security
• Topic C: Passwords
• Topic D: Convert an Access Database to an ACCDE File
• Topic E: Package a Database with a Digital Signature

Lesson 6: Managing Switchboards

• Topic A: Create a Database Switchboard
• Topic B: Modify a Database Switchboard
• Topic C: Set Startup Options