This course focuses on the design and construction of an Access database – viewing, navigating, searching and entering data in a database, as well as basic relational database design and creating simple tables, queries, forms and reports. Take Access 2019 – Level 1 to 3 to prepare for the MOS Certification exam for Microsoft Access 2019.
Course Outline
Lesson 1: Improving Table Usability
- Create Lookups Within a Table
- Work with Subdatasheets
Lesson 2: Creating Advanced Queries
- Create Query Joins
- Create Subqueries
- Summarize Data
Lesson 3: Improving Form Presentation
- Apply Conditional Formatting
- Create Tab Pages with Subforms and Other Controls
Lesson 4: Creating Advanced Reports
- Apply Advanced Formatting to a Report
- Add a Calculated Field to a Report
- Control Pagination and Print Quality
- Add a Chart to a Report
Lesson 5: Importing and Exporting Table Data
- Import and Link Data
- Export Data
- Create a Mail Merge
Lesson 6: Using Queries to Manage Data
- Create Action Queries
- Create Unmatched and Duplicate Queries
Lesson 7: Creating Complex Reports and Forms
- Create Subreports
- Create a Navigation Form
- Show Details in Subforms and Popup Forms
Lesson 8: 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 9: Using VBA to Extend Database Capabilities
- Getting started with VBA
- Using VBA with Form Controls
Lesson 10: Managing a Database
- Back Up a Database
- Manage Performance Issues
- Document a Database
Lesson 11: 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
