1 / 6

Database Sorting & Filtering: Tools and Techniques

Understand the importance of sorting and filtering in databases for efficient data management in business operations. Learn about sorting in ascending or descending order, primary and secondary fields, and filtering records based on specific criteria using advanced techniques.

tuvya
Download Presentation

Database Sorting & Filtering: Tools and Techniques

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DatabasesSorting & Filtering Supplemental to Objective 5.01: Understand Database tables used in business.

  2. Sorting • To sort is to arrange the order of data/records in the database. • Ascending: A to Z or 0 to 9 • Descending: Z to A or 9 to 0 • Primary: first field considered in sorting order • Secondary: second field considered in the sorting order

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

  4. Filter Records Filter: Displays selected records in a database that match specified criteria. • Advantages of using filters • Easier to use than query method • Fast • Disadvantages of filters • All fields are displayed when using a filter • Cannot save filters like queries • Types of filters • By Form (key criteria into a form; more flexible because criteria can be set for more than one field) • By Selection (quick/easy option by highlighting a cell as criteria) • Excluding Selection (excludes data highlighted in cell) • Advanced Filter/Sort (works like a query)

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

  6. Advanced Filters Step 1 Step 2 An advanced filter gives one the ability to sort and set multiple conditions to be met for selection of data/records. Result

More Related