Microsoft Access Level 3 - 91-045 Course Outline

(1 Day)

Overview

In this course, you will create and manage an Access database.

You will:

  • Navigate within the Microsoft Access application environment, create a simple database, and customize Access configuration options.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Audience Profile

This course is designed for students who wish to establish a foundational understanding of Microsoft Office Access, including the skills necessary to create a new database, construct data tables, design forms and reports, and create queries.

Prerequisites

To ensure your success in this course, you should have end-user skills with any current version of Windows, including being able to start programs, switch between programs, locate saved files, close programs, and use a browser to access websites.

Course Outline

Course Content

Lesson 1: Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and Configure Options in Microsoft Access

Lesson 2: Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Lesson 3: Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Lesson 4: Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

Lesson 5: Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organize Report Information

Topic F: Format Reports

Appendix A: Microsoft Office Access Exam 77- 730

Appendix B: Microsoft Access Common Keyboard Shortcuts