About Lesson
After completing this course, participants will have learned to:
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