Introduction

By the end of this lesson, you should be able to:

• Open a table in Datasheet view
• Navigate table records and across fields
• Understand the function of the Record Selector field

Opening an existing table in Datasheet view

Tables are created and maintained in the Tables tab of the Objects palette in Access. The contact management database contains four tables: calls, contact types, contacts, and switchboard items. We will discuss the Contacts table in this lesson.

A table opened in Datasheet view resembles a Microsoft Excel spreadsheet. It is used to input records into the database and will be discussed in this lesson.

To open an existing table from the tables object:

• Open the contact management database.
• In the database window, click the Tables tab from the Objects palette.
  
  NOTE: If the database window is not displayed by default, choose WindowContact Management: Database from the menu bar.
  
  
• To open the table in Datasheet view, double-click the Contacts table in the right window pane.
  
  OR
• Click once on the Contacts form and click Open.
  
  OR
• Right-click the Contacts form and select Open from the shortcut menu.

Displaying records by scrolling through the table

The vertical scroll bar is located along the right edge of the screen and can be used to move up or down the table if the total number of records exceeds the records shown on the screen. Similarly, the horizontal scroll bar located at the bottom of the screen can be used to move left or right across the window if the fields in a table exceed the number of fields displayed on the screen.

Using the vertical scroll bar:

• Click the up or down arrows in the scroll bar to move up or down through table records.

Using the horizontal scroll bar:

• Click the left or right arrows in the scroll bar to move left or right through the fields in a table.

Using the keyboard to navigate table records

Another way to navigate records in a table is to scroll up and down one screen at a time using the Page Up and Page Down keys on the keyboard. Other keys also provide shortcuts to move through fields and records, including:

The Record Selector

The Record Selector located to the left of each record in Datasheet view identifies the operation being performed against a selected record at any given time.

The Record Selector can display any of the following symbols:

• indicates the current record. The record is saved with the information displayed on the screen.
• indicates that the selected record is being edited and that changes have not yet been saved.
• indicates a blank record into which information for a new record can be added to the table.

A blank record row always appears as the last row in a table. You must add new table records using this row.

Challenge!

• Open the contact management database.
• Open the Contacts table in Datasheet view.
• In sequence, click through each of the following buttons in the status area: next record, last record, previous record, and first record.
• In the far right side of the title bar, click the Restore Down button. Practice scrolling through the table using the horizontal and vertical scroll bars. Take a screen print of the window showing the horizontal and vertical scroll bars.
• Practice using the keyboard to navigate table records. Notice how the cursor moves from record to record for each of the following keys:
  • Tab
  • Shift+Tab
  • End
  • Home
  • Page Down
  • Page Up
  • Down Arrow
  • Up Arrow
  • Ctrl+End
  • Ctrl+Home