Download sample pages in Adobe Acrobat format
Download Adobe Acrobat Reader

Contents 44 Pages

INTRODUCTION

Database Design
Stages in Creating a Database

STARTING ACCESS

The Office Assistant – Help Using Access
Opening an Existing Database
Creating a New Database
Creating a Database Using a Database Wizard
Creating a Database from Scratch
Creating Tables
Creating a Table using the Table Wizard
Creating a Table from Scratch
Defining Fields
Data Types
Setting the Properties of a Field
Adding, Deleting and Modifying Fields
Setting the Primary Key in a Table
Table Relationships

ENTERING DATA INTO A TABLE

Using Cut, Copy and Paste
Selecting in the Datasheet
Adding, Deleting and Modifying a Record
The Undo Command

MANIPULATING THE DATABASE

Sorting and Filtering
Performing a Quick Sort
More Complex Sorting and Filtering
Refining the Query

USING FORMS

Creating a Form Automatically
Refining a Form
Making Data Entry Even Easier

REPORTING

Creating a Report Automatically
Refining the Report

SAVING

PRINTING

APPENDIX IMPORTING AND EXPORTING