Microsoft Access Essential Training (Office 2021/LTSC)

Learn how to use Microsoft Access to build desktop databases.

Introduction

• Building databases with Access
• What you should know

1. 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

2. Creating Tables

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

3. 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

4. Organizing Records

• Sorting table data
• Filtering table rows
• Deleting records

5. 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

6. 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

7. 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

8. 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