CCNC/CCNC Module 5/Retrieving data with queries/Basic Query Operations
|Basic Query Operations|
Searching a Table for Data
Searching for Data
A good way to search for data is from the database table (or query) directly. When a table is opened a number of buttons are available on the toolbar that facilitate searching, filtering and sorting data. To open the table for searching, right-click on the table and select open.
Opening the Search Dialog
To search for a specific word, number or date in a record or a set of records within a specific column press the "Find Record" button on the toolbar. This will present the Record Search dialog.
Setting the search parameters
The "Record Search" dialog box will appear and you can enter the word, number or date you want to search for and select which field to look in. Click on the Search button and the value being searched will be highlighted when it is found.
Test your knowledge