• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Touring a Table

A database is made up of groups of fields organized into tables. A field is a specific category of information, such as a name or a product. Related fields are grouped in tables. All the fields dealing with customers might be grouped in a Customer table, while fields dealing with products might be grouped in a Products table. You usually enter data into fields one entity at a time (one customer at a time, one product at a time, and so on). Access stores all the data for a single entity in a record. You can view a table in Datasheet or Design view. Design view allows you to work with your table's fields. Datasheet view shows a grid of fields and records. The fields appear as columns and the records as rows.

Open and View a Table

In the Database window, click Tables on the Objects bar.

Click the table.

Click Open. The table opens in Datasheet view.

  • Drag the horizontal scroll box to scroll through the fields in a table.

  • Drag the vertical scroll box to scroll through the records in a table.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint