Microsoft Access 2019/2021: Advanced
Learn advanced Access features
Description
You're ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from casual database users or occasional designers. This is the third part of a three-course series that covers the skills needed to perform database design and development.
Course Outline
Lesson 1: Importing and Exporting Table Data
- Import and Link Data
- Export Data
- Create a Mail Merge
Lesson 2: Using Queries to Manage Data
- Create Action Queries
- Create Unmatched and Duplicate Queries
Lesson 3: Creating Complex Reports and Forms
- Create Subreports
- Create a Navigation Form
- Show Details in Subforms and Popup Forms
Lesson 4: Creating Access Macros
- Create a Standalone Macro to Automate Repetitive Tasks
- Create a Macro to Program a User Interface Component
- Restrict Records by Using a Condition
- Create a Data Macro
Lesson 5: Using VBA to Extend Database Capabilities
- Getting Started with VBA
- Using VBA with Form Controls
Lesson 6: Managing a Database
- Back Up a Database
- Manage Performance Issues
- Document a Database
Lesson 7: Distributing and Securing a Database
- Split a Database for Multiple-User Access
- Implement Security
- Convert an Access Database to an ACCDE File
- Package a Database with a Digital Signature
Prerequisites
Prior Course Recommendation:
- Microsoft Access for Office 2019/2021: Part 1
- Microsoft Access for Office 2019/2021: Part 2