"Databases with Access Learning Made Simple" by Moira Stephen

This handy textbook covers all you need to know to begin to use databases such as Microsoft Access. Written by experienced trainers for inexperienced learners to succeed, matched to main qualifications. Colourful approach to support self-study and training courses alike

Contents
Preface
1 Getting started
What is a database?
Access objects
Preparing your data
Normalisation
Primary key
Book shop example
Getting into Access
The Access screen
Help
On-line Help
Exercises
2 Building a database
Creating a database
Opening a database
Creating a table
Data types
Properties
Designing the table
Setting the primary key
Save and close
Multi-table databases
Exercises
3 Relationships
Relationships
Showing tables
Making relationships
Referential integrity
Editing and deleting
Printing
Exercises
4 Data entry and edit
Using Datasheet view
Entering data
Editing
Add and delete records
Adjusting the design
Data and related tables
Exercises
5 Forms
Creating forms
Save and close a form
Forms and related tables
Form Wizard
Design view
Form header and footer
Fields and controls
Labels
Images
Exercises
6 Datasheet view
Simple sort
Multi-level sort
Find
Replace
Filtering
The subdatasheet
Format a datasheet
Hide and Show
Freezing columns
Print Preview
Page Setup
Print
Exercises
7 Queries
The query grid
Saving a query
Multi-table queries
Selection criteria
Multiple criteria
Wild card characters
Is Null/Is Not Null
Exercises
8 Reports 1
Creating reports
Save and close a report
Report Wizard
Summary calculations
Exercises
Index