Course Length
Full day
Course Description
This class introduces participants to Access, a database management program used to store different types of information in an organized way so it can be easily and selectively retrieved. Users will create a new database and work with an existing database. Participants will learn how to manage and present the information using tables, queries, forms, and reports.
Course Topics
Getting Started
- Orientation to Microsoft Access
- Create a simple Access Database
- Get Help in Microsoft Access
Working with Table Data
- Modify table data
- Sort & Filter records
- Create Lookups
Querying a Database
- Join data from different tables in a query
- Sort and Filter data in a query
- Perform calculations in a query
Creating Advanced Queries
- Create Parameter queries
- Create Action queries
- Create Unmatched and Duplicate queries
- Summarize data
Generating Reports
- Create a report
- Add controls to a report
- Enhance the appearance of a report
- Prepare a report for print
What Participants Receive
Each participant receives a guide containing step-by-step instructions.
