Build a strong foundation in Microsoft Access by gaining hands-on experience creating databases, designing tables, and generating queries and reports. You’ll explore how to manage data efficiently and use key tools like forms and filters to streamline information retrieval and analysis.
Overview
Syllabus
Getting Started with Access
- Orientation to Microsoft Access
- Create a Simple Access Database
- Get Help and Configure Options in Microsoft Access
Working with Table Data
- Modify Table Data
- Sort and Filter Records
Querying a Database
- Create Basic Queries
- Sort and Filter Data in a Query
- Perform Calculations in a Query
Using Forms
- Create Basic Access Forms
- Work with Data on Access Forms
Generating Reports
- Create a Report
- Add Controls to a Report
- Enhance the Appearance of a Report
- Prepare a Report for Print
- Organize Report Information
- Format Reports
Taught by
Linda Haynes-Jackson, Clarissa J. Corbin, and Brian Simms