Opening and Closing a Table in Datasheet View


graphics/03inf02.jpg

graphics/one_icon.jpg

After you've opened the database that contains the table you want to open , click the Tables option in the Objects bar to display the available tables in that database.

graphics/two_icon.jpg

Click the table you want to open.

graphics/three_icon.jpg

Click the Open button in the database window's toolbar.

INTRODUCTION

To enter data in a table, you start by opening the table in Datasheet view. Looking at a table in Datasheet view is similar to looking at an Excel worksheet; you see a grid of columns and rows. Each column stores a field, and the column heading is the field name . Each row is a record. From within Datasheet view, you can enter data.

TIP

Shortcut

As a shortcut, you can double-click the table in the database window instead of clicking it and then clicking the Open button.

graphics/03inf03.jpg

graphics/four_icon.jpg

The table opens in Datasheet view. If you have entered records in the table, they are visible; if not, the table is blank.

graphics/five_icon.jpg

To close the table window, click its Close button.

TIP

Changing Views

When the table is open, you can click the Views button on the Standard toolbar in the main Access window to switch from Datasheet view to Design view and vice versa. You use Design view to alter the structure of the database, discussed in Parts 2 and 4.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net