Apr 07 2024 07:46 AM
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 do what I am looking for; mainly because it is just a spreadsheet.
Apr 07 2024 10:22 AM
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.
Apr 07 2024 12:34 PM - edited Apr 07 2024 12:35 PM
So, what do you expect from us? You say you found something that "doesn't do what I am looking for". We do not know what you are looking for. What data do you want to store about movies? Actors, directors, ......
Apr 07 2024 04:29 PM
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.
Apr 07 2024 04:36 PM
Apr 07 2024 05:55 PM
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.
Apr 07 2024 08:25 PM
Apr 08 2024 11:22 AM