CCNC/CCNC Module 5/Retrieving data with queries/Basic Query Operations

---

Searching a Table for Data

Outcomes

Upon completion of this tutorial the learner will be able to: Search a table for data Open the search dialog Set the search parameters

Searching for Data

Figure 1. Opening a Table

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

Figure 2. The Search Button

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

Figure 3. 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

Searching...

1. Searching data can be done from within an open table or query? TRUE → Absolutely Correct! FALSE → Incorrect, searches can be executed upon tables and queries. Click here to review the topic. 2. Which of the following is not a valid data type for a search? (a) Number → Incorrect, Binary is not the valid data type. Click here to review the topic. (b) Binary → Absolutely correct! (c) Text → Incorrect, Binary is not the valid data type. Click here to review the topic. (d) Date → Incorrect, Binary is not the valid data type. Click here to review the topic. Your score is 0 / 0