Journal of Course Experiences- Database Project

I intend to use Access to manage my cheerleading program. We collect a TON of paperwork each season for each participant. We need to keep track of the paperwork collected, plus be able to access the contact information, plus other information gathered at any given time. I have been tracking all this information with Excel, while effective, I know in the back of my mind, is not most efficient.

The hardest part of creating a database is deciding how it should be structured. What tables do you need to hold information? How can or will the tables be related?

Of course, I am discovering that I am my greatest distraction in getting this assignment done. It was challenging to come up with a third table for the assignment, and now that I have, I'm making queries, and attempting calculations.

I am quickly realizing that a database is a work in progress and constantly evolving.