Register Now      202-747-5000

Creating Queries and Reports in Microsoft Access

365 | 2019 | 2016
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

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).

We offer the above listed class as a private group class in the following delivery formats:

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 or Softek
1-4 students $1000
5-8 students $1150
9-12 students* $1250
*$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 $125 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. There is a 2-hour minimum fee for customization.

Why Choose Softek?

  • Live, in-person training
  • Instructors with 10+ years of experience
  • Detailed training guide
  • Certificate of completion
  • Money-back guarantee