GCFLearnFree.org

Every day I fall a little more in love with your site.”

Online Learner

GCFGlobal.org
Creating Opportunities For A Better Life.®
  • All Topics
  • Access XP
  • Opening a Table and Learning to Navigate Records

Access XP

Single page view print copy

Opening a Table and Learning to Navigate Records

Opening an Existing Table in Datasheet View

Tables are created and maintained in the Tables tab of the Objects palette in Microsoft 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 (Contacts) from the Tables Object:

  • Open the Contact Management database.
  • In the database window, click on the Tables tab from the Object palette.

    NOTE: If the database window is not displayed by default, choose WindowContact Management: Database from the menu bar.

    Contacts Table in Tables Object

  • To open the table in Datasheet View, double-click the Contacts table in the right window pane.

    (You could also either click once on the Contacts form and then click the Open button, or you could right-click on the Contacts form and select Open from the shortcut menu.
previous next
previous 1 2 3 4 5 6 7 next
Terms Of Use

©1998-2014 Goodwill Community Foundation, Inc. All rights reserved.