About this Course
In this course, students add to their Access education in order to provide themselves with marketable job skills. This course builds on the foundational skills obtained by attending the Introduction to Access 2016 course.
Course Outline
Implementing Advanced Form Design
- Add Controls to Forms
- Enhance Navigation and Organization of Forms
- Apply Conditional Formatting
Sharing Data Across Applications
- Import Data into Access
- Export Access Data
- Link Tables to External Data Sources
- Create a Mail Merge
Using Macros to Improve User Interface Design
- Create a Macro
- Restrict Records Using a Condition
- Validate Data Using a Macro
- Automate Data Entry Using a Macro
Using VBA
- Getting Started with VBA
- Enhance Access Using VBA
Using Advanced Database Management
- Manage a Database
- Determine Object Dependency
- Document a Database
Distributing and Securing a Database
- Splitting a Database for Multiple User Access
- Implement Security
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
Managing Switchboards
- Create a Database Switchboard
- Modify a Database Switchboard
- Set Startup Options