DVD Collection Database

[I R Foof]

Hi, I have 2000+ DVDs and Blu-rays that I want to make into a database. The time consuming part is one thing access can help with and I have seen it done before. The problem is I do not know how it is done. I can build the form to include Name, type(BD or DVD), Movie or TV Series. My biggest problem, getting any data entered into an Excel spreadsheet, for easier viewing of the list of movies. I would like a button that requires all inputs to be complete prior to comepleting the entry. Any ideas would be helpful. Please remember am still new and not overly familiar with the lingo.
Thanks

[orange]

Here is a free data model for a generic CD/DVD collection. It should give you some ideas.

I just did a google search and found this link that may be of interest to you.
Good luck.

[ranman256]

note for the tMovie table...throw in columns for the various formats you may have (you could have > 1 format)
[Title]
[year]
[DVD]
[BRD]
[VHS]
[LaserDisk]
[Beta]

[OTOTO]

are you aware that excel has an option to create forms too?

[OTOTO]

Add the form creator icon to your Quick Access Toolbar by going into Excel Options > Customize > adding the icon that the arrow is point to!!!!!!

[kagoodwin13]

Hi, I have 2000+ DVDs and Blu-rays that I want to make into a database. The time consuming part is one thing access can help with and I have seen it done before. The problem is I do not know how it is done. I can build the form to include Name, type(BD or DVD), Movie or TV Series. My biggest problem, getting any data entered into an Excel spreadsheet, for easier viewing of the list of movies. I would like a button that requires all inputs to be complete prior to comepleting the entry. Any ideas would be helpful. Please remember am still new and not overly familiar with the lingo.
Thanks

1. Establish a table to hold the information. See ranman256's post for ideas.
2. Make a form. If you would like to save the info immediately (like Excel), make the form while the form is open. If not, go on after step 3.
3. Add the fields you would like to collect information on (Movie name, year, actor, format, etc.).

If you would like a "save" button to check if the form is complete:
3a. The fields on the form need to be "unbound fields" so that they do not write directly into the table before saving.
4. Make a command button on your form. This will be your save button.
5. Right click the button and select "Properties." Click the "Event" tab, and then click "On Click."
6. In the code window, write some VBA code to check if the fields are not null.
7. In the code window, after checking if the fields are not null, write some SQL code to INSERT your information to the table that is saving your information.

I realize this probably seems like jargon right now, but those are the terms you can look up to figure out how to make your database happen. After you get it set up, feel free to ask questions here. This is a pretty common thing to do with Access, so there should be plenty of people that can help you here.

Good luck!

[kagoodwin13]

I just remember too - you don't have to make a form if you don't want to. You can make all of the fields (columns) on your table required, so if you enter a new record, the record will not save unless all of the required fields are filled out. That would probably be a lot easier than what I suggested above.

[OTOTO]

My advice for this database. Do not get involved with anything beyond 2NF. Too confusing for newbie form design.

As far as confirming that all the fields have been filled in, in the table require that these fields contain data.