Access Intermediate: Filter, Sort and Query Data

Selected Date [ See all available dates ]

Thursday, October 26, 2017
1:00 PM - 4:00 PM*
Trainer: Tim
How would you prefer to attend?
*All times are in the US/Pacific timezone.
[See all available dates]

Class Details

Price per person:$149
Length of class:three hours
Version covered:2016 for Windows

Description

In this three-hour training session, you will learn how to apply filters to data using wildcards and SQL operators, sort records, convert a filter to a query, and create queries using the Wizard and from scratch. You will use INNER and OUTER joins in queries, parameters, grouping and calculations. Lastly, you will learn how to create simple forms and reports.


Prerequisites

This class is ideally suited for people who have taken Access Session 1 training or have at least six months of experience using Access.


Outline

Filtering Records
- Filter records by menu, selection and form
- Sort records by one or more fields
- Toggle and remove filters and sorts

Querying Records
- Create Select queries
- The Query Wizard
- Design a query from scratch
- Filter data using a query
- Join data from different tables
- Inner vs Outer joins
- Write calculations in a query
- Use parameters in queries
- Create Update queries
- Group and summarize data

Creating Forms and Reports
- Create a simple form
- Create a simple report
- Preview a report before printing


Printable Course Description