Learn Access Now! Chapter 1 Previous Section in Chapter 2 Chapter 3

Chapter 2: Access in an Hour

(This is section 7 of 7 in this chapter)

Summary

In this chapter, you caught your first glimpse of the power Access brings to your desktop. You now know how you can use the development tools built into Access (such as the Table Wizard) to quickly and easily set up tables. You also know how to create your own database and enter information in tables.

Before moving on to Chapter 3, make sure you understand the following key concepts:

You can create a database by using the File menu New Database command or by using the New tool.
You can use the Table Wizard to quickly and easily create a table.
The Table Wizard provides many sample tables. You can use these as they are or use them as a starting point for a custom database.
Use a primary key in your table to help Access efficiently order the table and quickly find records.
The Datasheet lets you directly enter information in a table and edit existing information.
You can use the Find command to search for information in your table. This command lets you build search criteria using wildcard characters, if desired.
You can use the Replace command to replace information in your table. This command is similar to the Find command, but also allows the replacements.
To delete a record from the Datasheet, select the record and press the DELETE key or choose the Delete option from the Edit menu.
Access saves your changes on a record-by-record basis. When you move from one record to another, Access automatically saves any changes to the older record to disk.

In Chapter 3, you will learn a few more tricks for working with your new database and table.

Learn Access Now! Chapter 1 Previous Section in Chapter 2 Chapter 3