Finding Data


graphics/03inf24.jpg

graphics/one_icon.jpg

Click in the field, or column, on which you want to search. For example, to search by last name , click anywhere in the Last Name column.

graphics/two_icon.jpg

Open the Edit menu and choose Find .

graphics/three_icon.jpg

The Find and Replace dialog box opens with the Find tab displayed. In the Find What field, type the entry you want to find.

graphics/four_icon.jpg

Optionally, to search the entire table rather than the field you chose in step 1, click the down arrow next to the Look in field and choose the table name from the list that appears.

INTRODUCTION

In a large table, scanning through the records to find the one you want may be too time-consuming . Instead, search for the record you need. Access enables you to search any of the table's fields. For example, if you remember a client's first name but not his last, you can search for all matching first names .

TIP

Understanding Search Options

The various search options in the Find and Replace dialog box enable you to narrow your search. For example, suppose that you know that a customer's last name starts with Str but aren't sure what follows . You could type Str in the Find What field and then select Start of Field from the Match drop-down list. You can also specify that Access return only those entries that match the capitalization you typed. For example, if you type Smith in the Find What field, Access returns records that contain the entry Smith , but not smith or SMITH .

graphics/03inf25.jpg

graphics/five_icon.jpg

Click the down arrow next to the Match field and select Whole Field, Any Part of Field , or Start of Field .

graphics/six_icon.jpg

Click the Find Next button.

graphics/seven_icon.jpg

Access locates and selects the record with the first matching entry. If this is not the record you need, click the Find Next button to find the next match and repeat as needed.

graphics/eight_icon.jpg

Access notifies you when no more matches are found. Click OK .

TIP

Moving the Dialog Box

You may need to move the Find and Replace dialog box to view the matches. Click and drag the dialog box's title bar to move it out of the way.

TIP

Closing Find and Replace

To close the Find and Replace dialog box, click the Cancel button.



Easy Microsoft Office Access 2003
Easy Microsoft Office Access 2003
ISBN: 789729598
EAN: N/A
Year: 2003
Pages: 174

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net