Microsoft Access is a database development and maintenance program, but it can be confusing when trying to learn how to complete the tasks required to create an application. Microsoft Access 2003 In a Snap can quickly show you how to complete a specific task in an easy-to-follow format complete with illustrated steps. Sections of the book are organized into task categories such as Table Creation, Queries and Form Design. Intended to keep you focused and on-target, this book does not spend time explaining database architecture or application design. If you are the casual Access user or if you use it in your day-to-day work life, this book is a great reference tool!
I. INTRODUCTION TO RELATIONAL DATABASES AND ACCESS.
1. Start Here.
What Is a Relational Database?
What Types of Things Can I Do with Microsoft Access?
Starting Microsoft Access.
Opening an Existing Database.
The Access Desktop.
The Database Window.
A Preview of the Database Components.
Closing an Access Database.
Viewing and Navigating Table Data.
II. WORK WITH EXISTING DATABASES AND OBJECTS.
2. Working with an Existing Table.
Edit Table Data.
Add Records to a Table.
Delete Records from a Table.
Find and Replace Text in a Table.
Filter Table Data.
Modify the Appearance of a Datasheet.
Spell-Check Your Data.
Using the AutoCorrect Feature.
3. Working with an Existing Query.
Open a Query in Datasheet View.
Open a Query in Design View.
Add Fields to a Query.
Order a Query Result.
Refine a Query with Criteria.
Save a Query.
Print a Query Result.
Close a Query.
4. Working with an Existing Form.
Open a Form.
Work with Data.