Microsoft Office Tutorials and References
In Depth Information
Finding (and Replacing) Data
An AutoNumber field often serves the purpose of re-sorting data into its
original order, but if an AutoNumber field won’t work for the order you want,
consider adding a field that you can sort on to get your data in order. Don’t
let the order of records be a hidden clue to your data; include the data to
sort on explicitly in a field. (You may need a Date or Time Entered field if
that information is important, for example.)
Finding (and Replacing) Data
Do you like a quick-and-dirty approach, or do you prefer a more thoughtful
and refined strategy? Access accommodates both personalities. To search
quickly for data in a datasheet, use the Search box at the bottom of the
datasheet; it’s located to the right of the Record Navigator and to the left of the
scroll bar. Type your search text in the box, and with no further ado, Access
takes you to the first instance of the text. You don’t even have to press
Enter. In fact, as you type, Access is moving the focus in the datasheet to the
first instance of the text you’re typing. To find the next instance, press Enter.
Continue at will!
Book II
Chapter 3
If you want to be more specific about what you’re looking for, you may
prefer the Find and Replace dialog box. Access even takes the text you typed
in the Search box and puts it in the Find and Replace box automatically,
so you have it as a starting point. Display the Find and Replace dialog box
(shown in Figure 3-1) by pressing Ctrl+F or by clicking the Find button in the
Find group on the Home tab of the Ribbon.
Figure 3-1:
Press Ctrl+F
to see the
Find and
Replace
dialog box.
Using the Find and Replace dialog box for quick-and-dirty searches is as easy
as 1-2-3:
1. Press Ctrl+F to display the Find and Replace dialog box.
By default, Access searches the entire table. If you want to search within
a single field, put the cursor anywhere in that field’s column, click
the Find button, and then change the Look In setting on the Find and
Replace dialog box to Current Field.
2. In the Find What box, type what you’re looking for.
Search JabSto ::




Custom Search