|
CLAIT Plus 2006 Unit 3 Creating & Using a Database using Access 2003
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
|
