Microsoft Access Essential Training (Office 2021/LTSC)

Course details

Learn how to build Access databases to store and retrieve your data more efficiently. In this course, Access expert Adam Wilbert explains the concepts behind relational databases, before moving on to building tables—the foundation of any database. He then shows how to define the relationships between tables and use queries to find and filter data. Adam also shows how to apply rules and validation to minimize data entry errors; build an interface for the database from forms, complete with interactive buttons and combo boxes; create reports for printing and sharing; and automate these tasks and many others with macros.

Concepts

Introduction

Building databases with Access
What you should know

Getting Started

Building Access databases
Relational database concepts
Create the database file
All about the Trust Center
Digging into ribbon tabs
The database Navigation Pane
Customize the Quick Access Toolbar
Create a database backup

Creating Tables

Table structures and relationships
Create a table and set data types
Enter data
Primary and foreign keys
Importing tables

Setting Field Properties

Relationships and referential integrity
Editing table structure in Design view
Control input with masks
Set a default value
Data validation rules
Data lookup fields
Additional field properties

Organizing Records

Sorting table data
Filtering table rows
Deleting records

Using Queries

What are queries
The Simple Query Wizard
Build queries in Design view
Establishing constraints with criteria
Specifying criteria with wildcards
Incorporating AND and OR statements
Filtering with mathematical comparisons
Create flexible queries with parameters
Build expressions
Obtain summary statistics

Creating Forms

Understand the role of forms
Generate forms from tables
Adjusting form elements in Layout view
Using the Form Wizard
Form Design view
Find records

Creating Reports

Introducing reports
The Report Wizard
Edit a report in Design view
Edit a report in Layout view
Group and sort records
Creating calculated totals
Apply conditional formatting rules
Adjust print settings

Maintaining the Database

Customize groups in the Navigation Pane
Compact and repair the database
Examine database object relationships
Document your thought process
Print the blueprint of your database
Split a database into front and back ends
Protect the database with a password
Set startup options

Conclusion

Next steps