Microsoft Access Microsoft Access 20002000

Using TablesUsing Tables

Field NamesField Names

RecordsRecords

FieldsFieldsFields and RecordsFields and Records

Each Category of information in a record is called a field.The Columns in the table are called fields.

All the information in a table about one person or item is called a recordThe Rows in the table are called records.

Moving Around a TableMoving Around a Table

Row Selector

First RecordButton

Previous RecordButton

Record Number

Next RecordButton

Last RecordButton

New RecordButton

Horizontal Scroll Bar

Close WindowButton

Using the Keyboard to move around in a table

To move to Key(s) to press

First field in first record CTRL + HOME

Last field in last record CTRL + END

First field in current record

HOME

Last field in current record

END

Previous Record UP ARROW

Next Record DOWN ARROW

Previous Field SHIFT + TAB

Next Field ENTER or TAB