Forum Discussion
silvershanen
Apr 07, 2024Copper Contributor
database creation
I am trying to create a database that will allow me to keep careful track of all the movies I own, and other audio visual stuff like records. I have been looking but the only template I found doesn't...
George_Hepworth
Apr 07, 2024Silver Contributor
What is your level of experience creating relational database applications in the past? Do you feel comfortable modifying an existing sample accdb to suit your needs?
I can share an Access relational database application which is used to capture information about books, which is not all that dissimilar from movies in most respects. It would, obviously, require adaptation.
silvershanen
Apr 07, 2024Copper Contributor
my experience level might as well be zero. As in I only know the things that interest me and for the most part that doesn't usually include things on computers. That being said I do like to organize my interests as it were.
As to adapting what you are talking about, I wouldn't know if it would work unless I was looking at it. I must say that I do have a knack for making things work if they are close to what I am looking for.
- George_HepworthApr 08, 2024Silver Contributor
Thank you. That suggests you wouldn't get much useful out of this sample relational database application. Unfortunately, the kinds of skills and knowledge required won't be picked up right away.
I suggest you start with the basic principles of relational database design, or Normalization.
The videos in this playlist are probably a good starting point.- silvershanenApr 08, 2024Copper ContributorOk, well I had to ask, and I will look at those in the next couple days.
Thank you.- George_HepworthApr 08, 2024Silver ContributorIf you invest time and effort into learning how relational databases work and learn how to do it properly, it can be very rewarding. Good luck and remember, when you encounter specific issues that CAN be addressed in a forum like this, many experienced developers are willing to help.