Finding, Filtering, Sorting  «Prev  Next»

Sorting and Finding Access Data - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Use the Sort feature if you want to
Please select all the correct answers.
  A. Find the earliest date in a field
  B. Find the biggest value in a field
  C. Put projects in order by due date
  D. Find a particular client

2. You can use the Find and Replace dialog box to
Please select all the correct answers.
  A. Find the entire contents of a field
  B. Find a portion of the contents of a field
  C. Find the largest value in a field
  D. Find text in the same case that you type in the Find What box

3. In Microsoft Access, which keyboard shortcut performs an ascending sort on a selected field?
Please select the best answer.
  A. Ctrl-F
  B. Ctrl-A
  C. There is no keyboard shortcut for sorting — you must use the toolbar
  D. Ctrl-S

4. To display the Find and Replace dialog box in Microsoft Access you can (choose all that apply)
Please select all the correct answers.
  A. Press Ctrl-F
  B. Click the Find button (binoculars icon) on the toolbar
  C. Click the Sort Ascending button on the toolbar
  D. Click the Sort Descending button on the toolbar
  E. Choose Edit>>Find from the menu

5. In the Find and Replace dialog box, you can specify where you want to look for the text within the table by using the
Please select the best answer.
  A. Match Case option
  B. Match option
  C. Look In option
  D. Find What option