Microsoft Access Introductory

Microsoft Access is a relational database that can help you and your organization collect and manage large amounts of data. Access is a versatile tool. Use it as a personal management tool or use it as a construction set to develop applications for an entire department or organization. This course focuses the user on how to manage their data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

COURSE CONTENT

GETTING STARTED WITH ACCESS

• Orientation to Microsoft Access

• Create a Simple Access Database

• Get Help in Microsoft Access

WORKING WITH TABLE DATA

• Modify Table Data

• Sort and 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

CUSTOMIZING THE ACCESS ENVIRONMENT

• The Access Options Dialog Box