About this class
Students will learn how to finalize building an Access database. Students will also learn maintenance, troubleshooting, and enhancement skills for Access databases.
Features and functions in Office 365 and Office 2019 / 2016 are nearly identical. For this reason, users for all three versions (365, 2019 and 2016) attend the same class. The instructor will explain the few visual differences in the versions to you; just let the instructor know what version you are using.
What you'll be able to do
- Using Macros on Forms
- Using Macros on Tables and Reports
- Finalizing the Database Interface
- Enhancing Security on a Database
- Troubleshooting Tables
- Interacting Through Dialog Forms
- Using VBA
- Performing Database Maintenance
Course outline
Module 1Using Macros on Forms
- Using a Macro to Open a Form
- Using a Macro to Validate Data
- Level 2
Module 2Using Macros on Tables and Reports
- Table Macros
- Report Macros
Module 3Finalizing the Database Interface
- Create a Navigation From
- Create a Swtichboard
- Setting Startup Options
Module 4Enhancing Security on a Database
- Utilizing Advanced Startup Options
- Splitting a Database
- Password -Protecting a Database
Module 5Troubleshooting Tables
- Fixing Data in Fields
- Checking Object Dependencies
- Updating Database Objects Based on Table Changes
- Creating Many -to-Many Relationships
Module 6Interacting Through Dialog Forms
- Using a Form to Run a Query
- Using a Form to Run a Report
Module 7Using VBA
- Designing and Coding Interaction on a Form
- Testing VBA Code
- Adjusting and Enhancing VBA Code
- Protection VBA Code
- Using VBA on Exports
- Using VBA to Calculate Forms
Module 8Performing Database Maintenance
- Analyzing Database Performance
- Backing up a Database
- Compacting a Database
- Creating a blank copy of an Existing Database
Download the full outline (PDF)
Before you attend
Enhancing Security on a Database Maintain and troubleshoot a database Use Visual Basic for Applications (VBA) to automate database processes to use Access to build all four major aspects of a database: tables, queries, forms, and reports. Completion of the following courses or equivalent knowledge and ski lls is recommended: Microsoft Access Level 1
Run this for a team
Private cohorts run on your dates, at your site or online, with the labs pointed at your environment. Above about four people it usually costs less than buying seats.
More desktop applications classes
Introduction to Microsoft Planner
- $350 per seat
Introduction to Relational Database Design
- $395 per seat
Microsoft Access Level 1
- $650 per seat
2 dates on the calendar