Another bit of advice since you are new to Access. Think in terms of two "old Programmer's Rules" that I always offer to new folks.
Rule 1. If you can't do it on paper, you can't do it in Access.
Meaning, first you must understand the data flow of your business before you can write an Access database that can track, simulate, or support that business. I often tell folks to invest in a dry-erase board and some sticky notes to draw out a logical depiction of how data SHOULD flow in your business whether you are doing it by hand or by machine. You put up notes representing the things in your business and draw lines representing how they are related to each other in your business flow. You think about what has to happen and in what sequence. At some point you will be able to see a path of data from table A to table B through query C.
It is in this stage that you will discover multiple relationships among the elements of your business. You will see where sometimes there is a simple relationship, but sometimes it gets more complex and will need junction tables to handle assignments.
Rule 2. Access won't tell you anything you didn't tell it first.
Meaning, decide what you want to get out of this database application. Then decide what data you need to feed it in order to be able to retrieve that result. For example, if your dance studio sells dance-related clothing, you might need to know a person's clothing size, so you would have to ask about that. If you want to send notices to someone via their e-mail, you need to know their e-mail - so you have to ask for that information. If a person has strong preferences about sub-categories of whatever style you are teaching, that is something you would want to capture to be better able to server your customers.
In other words, when you are studying whatever you need to learn for Access, also think about what you need to ask that Access (by itself) could never know.
You don't say whether you are doing modern jazz, tap, ballet, or ballroom styles. I don't claim to know much about all of those - but I'm a former Arthur Murray "Silver" standard student myself, so I know at least some of the vagaries of the ballroom variant of that business, including getting hold of teaching materials such as videos of each particular move for review by your less experienced instructors.
I wish you the best of luck in that business.
