762 Chapter 25 Explore an Access 2010 Database
When you view a table in Datasheet view, you see the table’s data in columns (fields)
and rows (records). The first row contains column headings (field names). In this format,
the table is often simply referred to as a datasheet.FieldField namesRecord
Field names, fields, and records in a table.If two tables have one or more field names in common, you can embed the datasheet
from one table in another. By using an embedded datasheet, called a subdatasheet, you
can see the information in more than one table at the same time. For example, you might
want to embed an Orders datasheet in a Customers table so that you can see the orders
each customer has placed.
In this exercise, you’ll open existing database tables and explore the table structure in
different views.SET UP You need the GardenCompany01 database you worked with in the preceding
exercise to complete this exercise. Open the GardenCompany01 database, ensure that
tables are listed in the Navigation pane, and then follow the steps.- In the Navigation pane, double-click Products. Then at the right end of the
Navigation pane title bar, click the Shutter Bar Close button so that you can
see more of the table’s fields.