1 / 7

Sorting, Filtering, Editing Lists Project 6 Objectives

Key Terms for Lists . ascending order. sort field. database. filter. advance filter. AND search criteria. field. information. Slide 6-2. AutoFilter. sort. list. data. data form. OR search criteria. descending order. record. sort key. Database Versus Excel List. Slide 6-3. An Excel list is like a tab

dom
Download Presentation

Sorting, Filtering, Editing Lists Project 6 Objectives

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. Sorting, Filtering, Editing Lists Project 6 Objectives Using an Excel List as a Database (Lesson 1) Sorting Records on the Contents of One Field (Lesson 2) Sorting Records on the Contents of Two or More Fields (Lesson 3) Using AutoFilter with One Search Condition (Lesson 4) Using Custom AutoFilter with OR Search Criteria (Lesson 5) Using Custom AutoFilter with AND Search Criteria (Lesson 6) Adding and Deleting Records Using a Form (Lesson 7) Editing Records Using a Form (Lesson 8)

    2. Key Terms for Lists

    3. Database Versus Excel List

    4. Matching Criteria

    5. List Versus Filter

    6. OR and AND Criteria

    7. Fields in a Form

    8. Sample Exam Question

More Related