Access 2010 - Queries Basic
ACC-10-04
Duration
2 hours
Who should attend?
Anyone who is responsible for finding information in a database or for creating reports in a database and has not attended the module ACC-03-01 Microsoft Access 2003 Introduction.
Pre-requisites
Attendees should be familiar with the concepts of tables, fields and records. They should also have experience of viewing and inputting data through the use of forms.
Objectives
To design and save simple queries to find information in a database.
Course Content
Find
Find information in forms and tables using the Find tool.
Filters
Find information using the Filter tool. Filter in tables. Filter in forms.
Queries
Queries based on one table. Queries based on more than one table. Queries with calculations. Queries with parameters. Queries with statistics.
