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

graphics/1_icon.jpg

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

graphics/2_icon.jpg

Click the table.

graphics/3_icon.jpg

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.

graphics/02inf10.jpg

Select and Resize a Column or Row

  • Click the column or row selector to select a column or row.

  • Drag the border between the column or row selectors to resize a column or row.

    Each record has a unique identification number, which appears in the Specific Record box when that record is selected.

    graphics/02inf11.jpg

Enter a New Record in a Table

graphics/1_icon.jpg

Open the table in Datasheet view from a switchboard or from the Objects bar in the Database window.

graphics/2_icon.jpg

Click the New Record button.

graphics/3_icon.jpg

Press Tab to accept the AutoNumber entry.

graphics/4_icon.jpg

Enter the data for the first field. If you make a typing mistake, press Backspace.

graphics/5_icon.jpg

Press Tab to move to the next field or Shift+Tab to move to the previous field.

graphics/6_icon.jpg

When you reach the end of the record, click the New Record button or press Tab to go to the next record. Access saves your changes when you move to the next record.

graphics/02inf12.jpg

Delete a Record from a Table

graphics/1_icon.jpg

Right-click the row selector.

graphics/2_icon.jpg

Click Delete Record.

graphics/3_icon.jpg

Click Yes to confirm the deletion.

graphics/02inf13.jpg

Did You Know?

You can AutoNumber fields . The first field in a table is often an AutoNumber field, which Access uses to assign a unique number to each record. You can't select or change this value.




Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

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