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

6
Databases Databases Sorting & Sorting & Filtering Filtering Supplemental to Objective Supplemental to Objective 5.01: 5.01: Understand Database Understand Database tables used in business. tables used in business.

Upload: angel-charles

Post on 29-Jan-2016

214 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: Databases Sorting & Filtering Supplemental to Objective 5.01: Understand Database tables used in business

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.

Page 2: Databases Sorting & Filtering Supplemental to Objective 5.01: Understand Database tables used 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

Page 3: Databases Sorting & Filtering Supplemental to Objective 5.01: Understand Database tables used in business

SortingSorting

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

Page 4: Databases Sorting & Filtering Supplemental to Objective 5.01: Understand Database tables used in business

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)

Page 5: Databases Sorting & Filtering Supplemental to Objective 5.01: Understand Database tables used in business

Filter by Selection

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

Page 6: Databases Sorting & Filtering Supplemental to Objective 5.01: Understand Database tables used in business

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