databases sorting & filtering supplemental to objective 5.01: understand database tables used in...

DatabasesDatabasesSorting & FilteringSorting & Filtering

Supplemental to Objective 5.01:Supplemental to Objective 5.01:

Understand Database tables used Understand Database tables used in business.in business.

SortingSorting

To sort is to arrange the order of To sort is to arrange the order of data/records in the database.data/records in the database. AscendingAscending: A to Z or 0 to 9: A to Z or 0 to 9

DescendingDescending: Z to A or 9 to 0: Z to A or 9 to 0

PrimaryPrimary: first field considered in sorting order: first field considered in sorting order

SecondarySecondary: second field considered in the : second field considered in the sorting ordersorting order

SortingSorting

Sort using the Sort command on the Records menu, or the Sorting tool on the toolbar.

Filter RecordsFilter RecordsFilter:Filter: Displays selected records in a database that match Displays selected records in a database that match specified criteria.specified criteria.

Advantages of using filtersAdvantages of using filters

• Easier to use than query methodEasier to use than query method

• FastFast

Disadvantages of filtersDisadvantages of filters

• All fields are displayed when using a filterAll fields are displayed when using a filter

• Cannot save filters like queriesCannot save filters like queries

Types of filtersTypes of filters

• By FormBy Form (key criteria into a form; more flexible because criteria can be set (key criteria into a form; more flexible because criteria can be set for more than one field)for more than one field)

• By SelectionBy Selection (quick/easy option by highlighting a cell as criteria) (quick/easy option by highlighting a cell as criteria)

• Excluding SelectionExcluding Selection (excludes data highlighted in cell) (excludes data highlighted in cell)

• Advanced Filter/SortAdvanced Filter/Sort (works like a query) (works like a query)

Filter by Selection

Selects records by matching the selected condition or criteria. Only those records will be visible.

Advanced FiltersAdvanced Filters

An advanced filter gives one the ability to sort and set multiple conditions to be met for selection of data/records.

Step 1

Step 2

Result