COMPUTER SCIENCE AND ENGINEERING
DATABASE MANAGEMENT SYSTEM
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Query
|
|
|
Report
|
|
|
Sort
|
|
|
Table
|
Detailed explanation-1: -The sort feature is responsible for controlling the sequence, or order, of the records.
Detailed explanation-2: -What is it called when you want to see database records in a certain order? A foreign key. Look at the information in the database table.
Detailed explanation-3: -On the Home tab, in the Sort & Filter group, click Advanced and then click Advanced Filter/Sort on the shortcut menu. A new document tab appears, containing a design grid and a window in which you can select a field on which to sort. In the window, double-click the field that you want to use to sort.
Detailed explanation-4: -Under the Home tab of the Access ribbon, find the set of options labeled “Sort & Filter.” You’ll find two symbols at the left, one with an “A” over a “Z” with a down arrow next to it (Ascending), and the other with a “Z” over an “A” and an arrow (Descending).