Preview

06 - Sorting and Filtering

 1. Access offers a variety of sorting and filtering tools to help you refine your data and keep it _______.

  organised

  dropped

  queried

  featured

 2. Sorting records consists of _____________them in alphabetical, incremental, chronological, or Boolean order. Sorting can be performed on fields that have numbers, strings, date, time, or Boolean values.

  querying

  rearranging

  reporting

  searching for

 3. When sorting records in alphabetical, incremental, or chronological order, the empty fields always come first.

  TRUE

  FALSE

 4. To sort records, you must _____________ that would be used as the reference. To do this, on the table or query, click a field under the column of your choice.

  specify the report

  specify the form

  specify the field

  specify the button

 5. On what field has the following database been sorted?
on_which_field_has_the_sort_beendone.gif

  By Category (alphabetically)

  By Model (numerically)

  By Purchase Price (numerically)

  by Make (alphabetically)

 6. A ______ is a criterion or a set of criteria that must be applied to a set of records to create a list of records that abide by a common rule.

  filter

  query

  formula

  report

 7. To filter records that display on a data sheet, first decide what __________ to use.

  formula

  row

  data element

  column

 8. What does the image below show (note the highlighted section)
clearing_filter_option.gif

  This is showing how to show the results more clearly (i.e using a better font)

  This is showing the removing of filtering

  This is showing clearing all values from the whole database

  This is showing how to make the colour transparent (e.g. clear)

 9. To sort the records, identify and click the column header, a cell under a column, a control, or its label. Then, in the Sort & Filter section of the Ribbon, click the _______________.
sorting_records_example_estate.gif

  query button

  Ascending button

  report wizard button

  column button

 10. Sort Descending sorts your records from ____________________.

  bottom to top

  numeric to alphabetic

  top to bottom

  the letter D onward