databases sorting & filtering supplemental to objective 5.01: understand database tables used in...
TRANSCRIPT
![Page 1: Databases Sorting & Filtering Supplemental to Objective 5.01: Understand Database tables used in business](https://reader036.vdocuments.us/reader036/viewer/2022082714/5697bf791a28abf838c821fb/html5/thumbnails/1.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082714/5697bf791a28abf838c821fb/html5/thumbnails/2.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082714/5697bf791a28abf838c821fb/html5/thumbnails/3.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082714/5697bf791a28abf838c821fb/html5/thumbnails/4.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082714/5697bf791a28abf838c821fb/html5/thumbnails/5.jpg)
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](https://reader036.vdocuments.us/reader036/viewer/2022082714/5697bf791a28abf838c821fb/html5/thumbnails/6.jpg)
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