About working with data in a datasheet

The Table Datasheet and Query Datasheet toolbars provide many of the tools you need to find, edit, and print records.

Print or preview data.

Check spelling.

Cut, copy, or paste selected text, fields, whole records, or the entire datasheet.

Sort records.

Filter records, and find or replace values.

Add or delete records.

You can find tools for working with columns, rows, and subdatasheets in the datasheet itself, or by right-clicking a column selector.

Use the column selector to move, hide, or rename a column.

Resize columns or rows.

Use subdatasheets to view related data.

Freeze the leftmost column so that it is displayed as you scroll to the right.

You can use the navigation toolbar to move through the records in a datasheet.

Go to the first record.

Go to the previous record.

Type a record number to move to.

Go to the next record.

Go to the last record.

Go to a blank (new) record.