Is there a way in Access to have my table look just like it does in Excel with the subtotals after each group?
First time I've ever seen a request to do that - usually someone sets up Access tables like spreadsheets first, then asks why they can't figure out how to get info in or out! You don't want to do that. Generally, we don't store calculations in records either - you calculate when needed but in forms, queries and reports, and we don't create tables that look like sheets. Relational databases are tall (related data is in rows, not columns) not wide like sheets. You probably should start with understanding database normalization first.
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.