Dance Studio Management Database

[advomystics]

I am very new to Access. I did do an online training course last week. I am trying to create a database that will help with the Dance Studio I work for. Right now everything is done on paper and is a pain. I have started with 4 tables: tblCharges, tblDanceClasses, tblStudents, and tblTeachers.

First of all....Has anyone created a database that is already like this so I do not have to recreate the wheel?



Second, If not, I am not sure where to go from here. I want to assign the teachers and the students to the classes. I want to track charges and payments, too. Any suggestions??

[ssanfu]

I do not know of any Dance Studio dBs.

The best thing you could do is sit down with pencil & paper (or whiteboard) and design your table structure. Then sketch forms, design queries.

Orange recommends this site frequently for newcomers:
"Since you are new to Access, I recommend you watch the youtube series on Database by Dr. Daniel Soper.
It is an 8 part series, but I suggest you watch 1,2 and 4 to begin. The first video starts here."

Then there are tutorials at Roger"s Access Library at
http://www.rogersaccesslibrary.com/forum/forum46.html

[advomystics]

Thank you. I have been researching videos on youtube. I will definitely look these up.

[orange]

Cross posted: http://www.access-programmers.co.uk/...d.php?t=284119

[alansidman]

Maybe something here http://www.databaseanswers.org/data_models/

[advomystics]

I think that will definitely help me. Especially with relationships and queries. Thank you