Access – Part 2 - Bridgeway International

Access – Part 2

Back To Courses

Course Information

Need Group Training

Course Description

Professionals using advanced query design techniques complete complex data retrieval tasks up to 40% faster and with greater accuracy than those relying only on basic tools. The Microsoft Access Training – Access Part 2 course equips you with the advanced features, queries, reports, and relational design practices that make this level of efficiency possible.

In this course, you will expand your knowledge of relational database design, promote quality input from users, and learn how to improve database efficiency while strengthening data integrity. You’ll also implement advanced features in tables, queries, forms, and reports, giving you the ability to build databases that are more reliable, usable, and scalable.

The training focuses on optimization of Access databases, including performance tuning, normalizing data, applying data validation rules, and improving usability.

Course Objective

Provide input validation features to promote the entry of quality data into a database.
Organize a database for efficiency and performance, and to maintain data integrity.
Improve the usability of Access tables.
Create advanced queries to join and summarize data.
Use advanced formatting and controls to improve form presentation.
Use advanced formatting and calculated fields to improve reports.

Course Outline

Improving Table Usability

Create lookups within a table
Work with subdatasheets

Creating Advanced Queries

Create query joins
Create subqueries
Summarize data

Improving Form Presentation

Apply conditional formatting
Create tab pages with subforms and other controls

Creating Advanced Reports

Apply advanced formatting to a report
Add a calculated field to a report
Control pagination and print quality

Importing and Exporting Table Data

Import and link data
Export data

Using Queries to Manage Data

Create action queries
Create unmatched and duplicate queries

Creating Complex Reports and Forms

Create subreports
Create a navigation form
Show details in subforms and popup forms

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

Using VBA to Extend Database Capabilities

Getting started with VBA
Using VBA with form controls

Managing a Database

Back up a database
Manage performance issues
Document a database

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

Microsoft Copilot Chat in Action

What Is Microsoft Copilot Chat?
The Magic Prompt Formula
Work Smarter with AI