Microsoft Office Tutorials and References
In Depth Information
Viewing Your Tables
This chapter guides you through creating tables and defining fields in
Datasheet view. Chapter 2 of this minibook goes into the details you need to
know about creating and editing fields in Design view. The other chapters in
this minibook cover all the other important details that keep your tables —
and the data in them — in good shape for use in queries, forms, reports, and
the other objects in your database, as well as ways to analyze data with the
tools available within a datasheet without resorting to the more powerful
(and complicated) tools that Access provides.
If you want to look at existing tables, skip to “Working with a Datasheet Full
of Data,” later in this chapter. When you want to enter new data, change
existing data, or refine field definitions, look for the pertinent section
headings throughout this minibook.
Viewing Your Tables
Do you already have tables that you want to view? To display an existing
table, find the Tables heading at the top of the list in the Navigation Pane,
followed by the names of all the tables in the database. Double-click the
name of the table you want to display, and the table appears in Datasheet
The Navigation Pane appears as a pane on the left side of the Access
window or as a white bar along the left side of the window; click the bar to
display the pane. (See Book I, Chapter 2 for more information on using the
If you don’t see a Tables heading followed by all the tables in the database,
here’s how to get a look at the tables in your database: Right-click the
Navigation Pane title, and choose Category ➪ Object Type from the contextual
menu. Now you should see the objects in the database, sorted by object
type — that is, Tables, Queries, Forms, and Reports (see Book I, Chapter 2).
You may still need to use the Navigation Pane’s drop-down menu to display
either Tables or All Access Objects.
You can display tables in two views:
✦ Datasheet: This view is similar to a spreadsheet, displaying your data in
rows and columns. Rows are the records; columns are the fields. In
Figure 1-1, you see a datasheet with all the parts labeled. Use a datasheet
to view, enter, edit, and delete data. In Datasheet view, you can also
create and delete fields, sort and filter data, check spelling, and find
data. This chapter is all about table Datasheet view.