CLAIT Plus 2006 Unit 3 Creating and using a Database using Access 2010

Description

The 3rd guide in the CLAIT Plus 2006 series will teach you how to design, create and save a database, to add, amend and delete fields and records. You will learn how to import data and how to interrogate a database using complex criteria. Additionally, you will be able to create and format reports and to present data professionally.

CONTENTS:

Opening and Closing Databases

Creating Databases

Setting Field Properties

Defining Field Types

Entering Records

Importing Data

Inserting and Deleting Records

Adding and Deleting Fields

Using Ranges of Values in Queries

Using Pattern Searches and Non Matches

Using Dates in Queries

Using AND and OR in Queries

Creating Reports

Using Calculated Fields

Creating Grouped Reports

Controlling Page Setup

Printing Reports