Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
Search options in Microsoft Access
Use thebutton (or the shortcut) to find data in a table or in a form. This dialog will appear to let you choose what to search for and how to search for it.
Enter the text or numbers you're searching for here.
This setting determines how much of the table will be covered by the search.
- searches the records before the current record.
- searches through the records after the current record.
- makes the search go through the entire table.
This setting determines how much of the field is going to be searched.
- is the fastest type of search. It only looks at the first few characters of each record.
- looks for a record which is an exact match for the entire expression.
- is the most flexible type of search but also the slowest. It will find any record which contains the expression anywhere in the field.
Tick this if you want Access to take account of the case of the letters you're looking for. It's best to leave this clear unless you are absolutely sure that the data has been entered in the correct case. Addresses in particular can be a mixture of 'UPPER', 'lower', and 'Proper Case' entries.
Search Fields As Formatted
This box is greyed unless you have tickedIt becomes important when you have a field that is being displayed in a special format. For example, a search for '40' will find a price of '£40' if this box is clear. You would have to search for '£40' if the box were to be ticked.
Search Only Current Field
The search will be faster if you tick this box because Access will be able to concentrate on single field and may be able to use an index rather than having to use brute force techniques to examine every field.
Presetting the options
If you selecton the menu and select the page then you can set the default type of search.
- - equivalent to 'Whole Field'.
- - equivalent to 'Any Part of Field'
- - equivalent to 'Start of Field'.
Note that the option you choose won't take effect until the next time that you start Access.