Objective 1.3 Navigate through a database
- 1.3.1 Navigate specific records
- 1.3.2 Create and modify navigation forms
- 1.3.3 Set a form as the startup option
- 1.3.4 Display objects in the Navigation Pane
- 1.3.5 Change object views
OBJECTIVE 1.3: Contents
1.3.1 Navigate specific records
Navigate specific records
You have a choice of tools when you need to find a specific record in a table or in the results of a query, or when you’re working with a form or report. Navigation buttons that appear at the bottom of a form or a table in Datasheet view move from record to record or to the first or last record. The record indicator displays which record is selected. The navigation area also includes a simple search box in which you can enter the text you want to search for. Access finds the first instance of that text in any of the object’s fields.
Use the search box in the navigation area to find specific records
On the Home tab, commands in the Find group help you locate records, perform find-and-replace operations, and move between records by using the Go To options. In the Find dialog box, you can select an option to search the current field or the current document (the full database). The Match box provides options for matching the whole field, any part of the field, or the start of the field. For example, if you were searching for records for pasta, you could enter pasta and match the whole field, pa and match the start of the field, or st and match any part of the field. You can also conduct case-sensitive searches. The Search Fields As Formatted check box is selected by default. You can clear this option to search for values as Access stores them rather than as they are formatted in the database.
Another approach for navigating to a specific record is to use the options that Access provides for sorting and filtering records. You can sort the records in text fields in ascending or descending order, and in number fields from smallest to largest or largest to smallest. When you filter records, only the records that match the filter’s criteria are displayed. This reduces a long list of records to just a few records among many.
See Also: For information about sorting and filtering records, see “2.3.3 Find, sort, and filter data” in “Objective 2.3: Manage records in tables.”
To use the navigation area
In the navigation area at the bottom of a table, query, or form, use the arrows to move to the first, next, previous, or last record in the record set.
To find a specific record, in the navigation area’s search box, enter text related to the record.
To go to a record
On the Home tab, in the Find group, click Go To, and then click First, Previous, Next, or Last.
To find records
1. On the Home tab, in the Find group, click Find.
2. In the Find And Replace dialog box, in the Find What box, enter text related to the record you want to locate.
3. Use the Look In, Match, and Search lists and the Match Case option to specify conditions that Access will use to locate records.
4. Click Find Next.