Learn Access Now!
Chapter 4
Previous Section in Chapter 5
Chapter 6
Chapter 5: Sorting and Filtering Information
(This is section 3 of 3 in this chapter)
Summary
Access lets you quickly and easily sort and filter your data. These two closely related operations can help you manage your data more efficiently. This chapter has taught you how you can both sort and filter information.
Before you move on to Chapter 6, make sure you understand the following key concepts:
- Sorting places data in a specific order.
- Information can be sorted either in ascending order (from smallest to largest) or descending order (from largest to smallest).
- You can use the simple sort feature to quickly sort a table based on the contents of one or more adjacent fields.
- You can use a complex sort to sort multiple fields that are not adjacent. You can also use a complex sort to sort multiple fields in different orders (ascending and descending).
- To create a complex sort, use the Filter window.
- A filter is a way to temporarily limit what records Access displays. A filter creates a subset of your table.
- You create a filter by specifying criteria for Access to use when selecting records to display. You specify the criteria using the Filter window.
- A filter is lost when you close a table. You can save and later reuse a filter if you save it as a query.
In Chapter 6, you will learn about a topic that is closely related to filters--queries.
Learn Access Now!
Chapter 4
Previous Section in Chapter 5
Chapter 6