Select fields and records

Microsoft Office Access 2003

The following table lists mouse techniques for selecting data or records in Datasheet view.

To select Click
Data in a field Where you want to start selecting and drag across the data.
An entire field The left edge of the field in a datasheet, where the pointer changes into Button image.
Adjacent fields The left edge of a field and drag to extend the selection.
A column The field selector.
Adjacent columns The field name at the top of the column and then drag to extend the selection.
A record The record selector.
Multiple records The record selector of the first record, and then drag to extend the selection.
All records Select All Records on the Edit menu.

ShowSelect fields and records in a data access page

The following table lists mouse techniques for selecting data or records in Page view.

To select Click
Data in a field Where you want to start selecting and drag across the data
An entire field Three times within the field
A record A field that belongs to the record
The following table lists keyboard techniques for selecting data or records in Page view.
To select Do this
Data in a field Move the insertion point to the start of the text you want to select, and then hold down SHIFT and press the arrow keys to move to the end of the selection.
An entire field Move the insertion point to anywhere in the field, press HOME, and then press SHIFT+END.
A record Press TAB until a field that belongs to the record gets focus.

Note     Your data access page might have a Microsoft Office PivotTable Component, Spreadsheet Component, or Chart Component, which have their own methods of selection. To display Help for one of these components, click Help Button image on its toolbar.