15.3 Displaying data
Searching a database allows the display to be limited to only those records that you want to see. When you specify a criteria you can apply a query to limit the number of records displayed.
True or False? Write out the true sentences and change the false sentences so that they are true.
|
Sorting records is the most efficient way of finding data. |
|
A query is a search of a database for records that meet a certain condition. |
|
To create a query you need to select the query command and choose the fields to be displayed. |
|
The method of entering a simple query depends on the DBMS. |
|
Relational operators (AND, OR, NOT) are used to combine simple queries. |
|
Logical operators (=,<>,<,>,<=,>=) are used for simple queries. |
|
Searching a database to retrieve information can be done on one way. |
|
Ascending order arranges data from largest to smallest (9-0) or from last to first (Z-A). |
|
Descending order arranges data from smallest to largest (0-9) or from first to last (A-Z). |
|
Searching is the process of arranging data in a particular order. |