The Table Datasheet and Query Datasheet toolbars (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.) 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 (subdatasheet: A datasheet that is nested within another datasheet and that contains data related or joined to the first datasheet.) in the datasheet itself, or by right-clicking a column selector (column selector: The horizontal bar at the top of a column. You can click a column selector to select an entire column in the query design grid or the filter design grid.).

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.