Topic 1

Implementing Advanced Form Design

• Types of Controls
• Move Form Controls
• Sub forms
• Navigation Control and Navigation Forms
• Insert Headers and Footers
• Conditional Formatting
• Tab Pages

Topic 2

Using Data Validation

• Field Properties
• Form Validation

Topic 3

Using Macros to Improve User Interface Design

• Macros
• Macro Conditions
• Event Properties for Data Validation
• Event Properties for Automating Data Entry
• Macros and VBA

Topic 4

Using Advanced Database Management

• Macros
• External Data Sources
• Exclusive Mode
• Object Dependency
• The Database Documenter
• Performance Analyser

Topic 5

Distributing and Securing a Database

• Splitting a Database
• Security Strategies in Access 2016
• Password Protection Guidelines
• The ACCDE File Format
• Digital Signatures

Topic 6

Managing Switchboards

• Switchboards
• Switchboard Modification
• Database Start-up Options