Select fields and records - Access - Microsoft Office Online

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Select fields and records

Applies to: Microsoft Office Access 2003

Show Select fields and records in a datasheet

The following table lists mouse techniques for selecting data or records in Datasheet view (Datasheet view: A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).

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 .
Adjacent fields	The left edge of a field and drag to extend the selection.
A column	The field selector (field selector: A small box or bar that you click to select an entire column in a datasheet.).
Adjacent columns	The field name at the top of the column and then drag to extend the selection.
A record	The record selector (record selector: A small box or bar to the left of a record that you can click to select the entire record in Datasheet view and Form view.).
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.

Show Select fields and records in a data access page

The following table lists mouse techniques for selecting data or records in Page view (Page view: An Access window in which you can browse the contents of a data access page. Pages have the same functionality in Page view as in Internet Explorer 5.0 or later.).

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.