Microsoft Access 2021 - Part 2

About This Course:

This intermediate-level Microsoft Access course is designed for users who are already familiar with the fundamentals of Access and want to expand their skills to build more powerful, efficient, and user-friendly databases. In this course, participants will learn how to enhance forms for better usability, use macros and VBA to automate tasks, and design databases that are optimized for multi-user environments.

Course Objectives:

• Customize form layouts for enhanced usability

• Use control layouts and tab order for efficient data entry

• Apply conditional formatting for better user experience

• Export Access data to Excel and Word

• Import data from external sources (Excel, SharePoint, text files)

• Link Access to external databases

• Introduction to macros and their purpose

• Create and manage macro actions

• Use macros to automate form behavior and navigation

• Introduction to VBA in Access

• Use VBA to enhance form controls and events

• Write simple procedures for data automation

• Normalize data for efficiency and consistency

• Organize data into appropriate tables

• Define relationships and enforce referential integrity

• Split a database into front-end and back-end

• Set permissions and lock down objects

• Prepare a database for multi-user deployment

• Build and customize a database switchboard

• Use navigation forms for easier access to features

• Set startup options and control user experience

Audience:

• Intermediate to advanced users familiar with Microsoft Access basics who want to deepen their skills and create more robust, user-friendly databases.

Prerequisites:

• Completion of Microsoft Access Part 1 or equivalent experience with Access tables, forms, queries, and reports.