Access 2010

We have no courses for the current term. If you are interested in taking an Access 2010 class, please fill out our FlexStart Form.

Access 2010 - Creating Queries

In Access, queries allow you to ask questions of your data. Queries are the engine of Access, allowing you to manipulate your data to give you output that is useful to you.  The most basic query type is the Select query where you supply the parameters of the data you are seeking by means of criteria.  For example, you may want to know how many customers in the state of Florida spent more than $250 in the month of August 2011. These are by far the most widely used queries.  We will also cover multi-table queries, using calculations in queries, a total query, a parameter query, find duplicates and find unmatched queries. However there are many other very useful query types that we will cover such as the Action Queries: Make-Table query, Append query, Update query and Delete query.  Requirement: Basic experience using Access 2010 or 2007.