Microsoft Access – Level 1

At the end of this workshop, you will be able to:

• Work with Tables, Forms, Queries and Reports
• Enter, edit and filter table data
• Create and set custom options for inputting table data
• Relate tables to one another using referential integrity
• Create and customize forms
• Work with different types of queries
• Create and print reports
• Import and export data to Excel and other formats

The Basics

• Database Concepts
• Getting Started
• Creating a Database
• Converting Access Files
• Working with Objects
• Using Access Help

Table Data

• Table Concepts
• Viewing Data in a Table
• Changing the Database Appearance
• Entering and Editing Data
• Applying Filters

Table Design

• Creating a Table
• Changing the Table Design

Data Entry

• Data Entry Concepts
• Data Formats
• Input Masks
• Input Validation
• Adding Records

Relationships

• Relationships Between Tables
• Creating a Relationship
• Referential Integrity
• Removing a Relationship
• Printing Relationships

Creating and Using Forms

• Creating a Form Using AutoForm
• Creating a Form Using the Form Wizard
• Creating a Form in Design View
• Opening a Form
• Changing a Form Design
• Adding Controls
• Placing Controls
• Multiple-Choice Controls
• Error Checking

Queries

• Using the Query Wizard
• Creating a Query in Design View
• Selecting and Sorting in a Query
• Calculations
• Action Queries
• Parameter Queries

Reports

• Creating Reports
• Using the Report Wizard
• Previewing Reports
• Creating Reports in Design View
• Changing Report Design
• Control Operations
• Control Attributes

Importing and Exporting Data

• Importing and Exporting
• Importing a Text File
• Importing Data from an Access Database
• Exporting Data
• Troubleshooting Importing and Exporting Problems

Printing

• Printing Objects
• Print Preview

There are no prerequisites for this course.

Note on Versions:
This workshop is applicable to users of Microsoft 365, 2019, and 2016 versions. While some features or layouts may differ slightly between versions, the core skills and tools covered remain consistent.

This workshop is intended for anyone who has a good working knowledge of Microsoft Office products and is seeking to understand how to work with databases.