Data was imported into Access from Excel. In part 1, we examined it, and learned how to do a few things in datasheet view like filtering, sizing columns, and showing totals. To get unique values, we'll make a query and then change it to a Totals query, and use an aggregate function to calculate something. We'll use Group By, Max, and Expression.
Here are the other videos in this series:
Shuffle - 1 - Examine Data (imported from Excel)
Shuffle - 3 - Table Design
Shuffle - 4 - Append Query