Creating Queries and Reports in Microsoft Access

3 Hours

Course Overview

This instructor-led course, through lecture and hands-on exploration, will teach students the basics of creating and editing queries and reports in Microsoft Access. This 3-hour course will also teach students how to find, sort, and filter data.

Course Objectives

Find, sort, and filter data
Create, edit, and save queries based on different data types
Create, edit, and save reports based on tables and queries
Design mailing labels

Course Outline

Finding, Sorting, and Filtering Records

Navigating Through Tables
Searching for Specific Records
Sorting Records
Filtering Records

Creating Queries to Extract Information

Creating Queries in Design View
Adding Query Fields
Reviewing Data Types and Criteria Examples
Writing Criteria for Queries
Running Queries
Saving and Closing Queries
Modifying Queries
Sorting Query Results
Performing a Single Field Sort
Performing a Multiple Field Sort
Deleting Query Fields
Printing Query Results
Using “AND” Criteria
Using “OR” Criteria
Creating Multi-Table Queries

Creating Basic Reports

Creating Reports Using the Wizard
Closing Reports
Switching Between Report Views
Opening Reports
Customizing Reports
Understanding Report Sections
Editing Report Titles
Working with Layouts
Saving Reports
Changing Page Setup Options
Printing Reports
Creating Mailing Labels

Cost and Delivery Format Options

We offer the above listed class as a private group class in the following delivery formats. Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9:00 am to 12:00 pm and 1:00 pm to 4:00 pm).

Private Group Class: Live Virtual
1-4 students	$850
5-8 students	$1000
9-12 students*	$1100
*$35 per additional student

Private Group Class: At Your Location
1-4 students	$1100
5-8 students	$1250
9-12 students*	$1350
*$35 per additional student

Private Group Training

Private group classes are cost effective when you have a group of students who need the same course. Volume discounts of 5% to 20% are available when five or more training days are scheduled. For classes conducted at your location, you are responsible for the classroom setup which should include:

A computer for each student (with the appropriate software installed), and
An instructor workstation connected to a visual display (e.g., projector, smartboard, etc.).

Customization

Softek can easily customize a training course that covers the specific topics you require and integrate examples relevant to your work environment. Course customization is billed at $150 per hour and covers time needed to meet, discuss, prepare, and incorporate any specific examples into the training program. Once we have a better idea of what you have in mind, we will be glad to provide a specific price quote for the customization.