Microsoft Access Essential Training (Office 2024/LTSC)

Course details

In this comprehensive course for business professionals and database admins, data visualization expert Adam Wilbert guides you through using Microsoft Access 2024 for your database solutions. Learn how to build and manage relational databases; analyze the structure and relationships within databases; and evaluate and improve database performance through advanced queries and automation. Build essential skills for developing, maintaining, and optimizing Access databases in environments that require long-term stability and support. Leverage Access's powerful features to design efficient data structures, create user-friendly forms and reports, and automate processes, all within the context of the Long-Term Servicing Channel version's unique considerations. By the end of the course, you will be able to design secure, efficient databases tailored to specific organizational needs.

Concepts

Introduction

Building databases with Access
What you should know about Access 2024

Getting Started in Microsoft Access (Office 2024)

Building Access databases
Create the database file
Understand the Access Trust Center
Digging into ribbon tabs
The database Navigation Pane

Creating Tables in Access

Database concepts
Table structures and data types
Create a table and set data types
Enter data
The role of primary and foreign keys
Relating tables together with key fields
Importing tables

Setting Field Properties in Access

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 in Access

Sorting table data
Filtering table rows
Deleting records

Using Queries in Access

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
Introducing the SQL query language

Creating Forms in Access

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 in Access

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

Automate the Access Database with Macros

Create your first macro
Work with embedded macros
Take a quick peek at the Visual Basic language

Maintaining the Database

Customize groups in the Navigation Pane
Customize the Quick Access Toolbar
Compact and repair the database
Create a database backup
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

Final thoughts - Applying your Access skills