Examine data that was imported from Excel. Filter data in Access just like you do in Excel, for just what you want to see.
Turn on a totals row to sum columns. Best-fit columns and change column widths. See how a new AutoNumber value is automatically assigned, and totals are changed, when a new record is created. Look up a customer code using a quick query.
Here are the other videos in this series:
Shuffle - 2 - Totals Query
Shuffle - 3 - Table Design
Shuffle - 4 - Append Query
Here is the video that shows how to do the import:
import an Excel spreadsheet into an Access database