Proudly serving the D.C. metro
area for over 25 years.


Softek Services, Inc.
1156 15th Street, NW, Suite 100
Washington, DC 20005
(202) 747-5000

Computer Training Software Consulting Database Programming

Get tips on our Facebook Find us on Google+ Tweet Us Read Reviews on Yelp Softek on Linkedin

  • Instructor-led Training Instructor-led Training
  • Join a Public Class Join a Public Class
  • Private Group Classes Private Group Classes
  • Transition Classes Transition Classes
  • Virtual Training Virtual Training
  • Customization & Documentation Customization & Documentation
  • Web and Database Development Web and Database Development
  • We Have Classrooms We Have Classrooms
     

Creating Queries and Reports
in Microsoft Access

Version 2010 • 2013 • 2016

3 Hours

Learn how to find, sort, and filter data. This course will cover the basics of creating and editing queries and reports.

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

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

View Upcoming Schedule or Register for a Class

Is this the right course for you? Please contact our office at (202) 747-5000 if you have any questions.

Back to Agenda

Investment

Public Class

This class is only offered for private groups.

Private Group Classes

Any two 3-hour Microsoft classes must be scheduled on the same day to receive pricing (9 to 12pm and 1 to 4pm).

Conducted at Your Office

$500 flat fee for up to 8 students
$550 flat fee for up to 12 students
$35 per additional student

Conducted at Softek’s Facility

$575 flat fee for up to 8 students
$625 flat fee for up to 12 students
$35 per additional student

Have more or less students? Or, need to schedule more than one training day? Click here for a price quote based on your training needs. 

Why choose Softek?

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