Access 2010: An introduction in pdf

In Access 2010 data is stored in tables. Each table holds data about a specific ‘thing’ and is related to at least one other table. Although the data is held in tables, the best way to access and edit data is not within these tables, but by using data entry forms. Queries are used to filter the data and also to do other things, some of which we will see on this course. Reports let you group the data together in printer-friendly format. 

Aims and Learning Objectives

This course provides an introduction to Access 2010 databases. By the end of this course, 

you will be able to:

• navigate within and between data entry forms;
• edit, add, delete, sort, find and filter data;
• create simple single, multi-table and action queries;
• create a simple grouped report based on a multi-table query.

Note: this document cannot be used with Access 2003; those using Access 2007 or Access 2013 will find minor differences.