Skip to content
Sorting and Filtering Data: Apply It 1
- Display records in datasheets
- Sort and filter records
- Aggregate data
- Preview and print records
- Open your database saved under LastName_BusinessCardDB.accdb
- Filter: Sort the contact table by last name A–Z.

- Rearrange a Column: rearrange the columns so that the
CompanyName
column appears immediately after the LastName
column.
- Use Aggregate Functions: add a total row calculate the total number of contacts by
CompanyName.
- Save your work. This assignment is ready to submit as needed.