Master Visually®: Microsoft® Office 2007

Chapter 23. Finding and Querying Data

Find Data

You can search for records that contain specific data. You can also search for data in tables, queries, and forms.

By default, Access performs a search of the current table. To perform a more advanced search, you can create a query.

You can specify how you want Access to search for data in a field. The Any Part of Field option allows you to find data anywhere in a field. For example, a search for smith finds Smithson and Macsmith. The Whole Field option allows you to find data that is exactly the same as the data that you specify. For example, a search for smith finds Smith but not Smithson. You can also choose the Start of Field option to find data only at the beginning of a field. For example, a search ...