How do I use Access to organize a list of movies?

[php111]

Hello everyone!

I am new to the forums and new to Access and never used a database software before.

I ordered Access by ordering Office 365 Personal. I am waiting for an email after processing my information.

How do I use Access to organize a list of movies and a list of TV series shows/episodes? How do I organize the single movies in alphabetical order and have the series in chronological order in release year and have the TV series in chronological order of episodes within their respective season by release/airdate order? May I please ask if this would be possible?



Thank you,

[orange]

php111,

You are asking many questions. What I am seeing "between the lines" is that you are not familiar with Database Principles, nor with database design approaches (tutorial here). There is much more to creating a database(s) that you are seeking than purchasing software.

Here is a small analogy (way off topic for sure). Consider a request to fly a 747 such that it banks to the right -- it sounds straightforward, but would assume you knew something about the physics of flight; had accomplished numerous successful take-offs and landings; had familiarity with the plane's instrumentation/avionics..... All this to point out you need to learn and become familiar with some of the basics of database; then some of the specifics of Access and Office 365 Personal.

Please see a previous post with many useful links to help with learning the basics.

Good luck with your new software and project.

[php111]

orange,

Thank you so much for the information. However, in my opinion its a lot of work just to use the software for what I am asking.

[ranman256]

I would have table: tTITLES
[MovieID]
[name]
[ReleaseYr]
[IsTVshow] (y/n)
[rating]
[Genre]


also: tEpisodes
[MovieID]
[Epi#]
[title]
[descr]

tActors
[ActorID]
[last]
[first]


tCast
[ActorID]
[MovieID]
[CharName]

[php111]

@ranman256,

Thank you very much! I will try that.

[orange]

php111,

There's more to database than buying the software -- that was my point.
Did you look at the links I provided? They will lead you through many aspects of database design and development, and you will learn from them.

see this for more info specific to your Movies, Actors etc.
http://www.databasedev.co.uk/dvd_col...ata_model.html

Good luck.

[php111]

I did not reply because for a number of reasons.

1.) It is too complicated for me.

2.) Its way too complex for me to even think about and I did and have been trying to say this.

3.) I really admit that this has gone beyond what I could even do and I did looked at one of the links and I am sorry but I did not understand it and that was like the first few paragraphs so I closed it out.