Sorting and Filtering Data: Apply It 1

  • Display records in datasheets
  • Sort and filter records
  • Aggregate data
  • Preview and print records
  1. Open your database saved under LastName_BusinessCardDB.accdb
  2. Filter: Sort the contact table by last name A–Z.
    Access database contacts are sorted alphabetically by last name.
  3. Rearrange a Column: rearrange the columns so that the CompanyName column appears immediately after the LastName column.
  4. Use Aggregate Functions: add a total row calculate the total number of contacts byCompanyName.
  5. Save your work. This assignment is ready to submit as needed.