Home Page Contact Dave Thompson Consulting Site Map
Dave Thompson Consulting
408 Rose Drive
Allen, Texas 75002
(972) 727-5670
A Resource List Database Program for Microsoft® Access
II. List Navigation
V. Keyboard-Only (Mouseless) Operation
II. List Navigation
Figure II-1. Resource List Search Commands
The list may be searched by Name, Code, or Specialty. While the list may also be sorted by the same fields, when a find/lookup operation is conducted, the list automatically sorts by the Find criteria such as Name.
Search Name - Leading Characters
(Click to enlarge. Opens in new window)
Figure II-2a. Search: Name Starts With "do"
Figure II-2b. Search Result
The name field may be searched by entering the first few characters (one or more) of the name. When the search is run, the program will position the list at the first entry meeting your criteria. In the case of "Doe", you can search for "d", "do", or "doe".
Search Name - Contains
Figure II-3a. Search: Name Contains "hosp"
Figure II-3b. First record having "hosp" in name
Note that once you begin a Contains search, a new command button appears. Find Next can be used to search for other entries in the database where the name field contains "hosp".
Figure II-3c. Second record having "hosp" in name
The contains search feature provides a useful method to search the database as an alternative to the conventional "starts with" approach.