Often, before you can complete a task in Access, you must first select the data that you want to work with. Many common tasks such as editing, formatting, copying, cutting, and pasting all require you to know how to select information.
You can also select text by pressing and holding the Shift key while using the arrow keys to select the text you want. To replace text, select the text you want to replace, then type the new text with which you want to replace it.
Position the mouse over the left edge of the cell you want to select and click to select the cell.
Select a record or row
Position the mouse over the record selector and click to select the record. To select multiple records, drag down until you have highlighted all the records you want to select.
Select a field or column
Position the mouse over the name of the field you want to select and click to select it.