Basic database design - using tables to feed lookups

[nkuck]

This is going to be an easy one. I am creating a library database of books,
leaflets, brochures, etc. I want to have certain drop-down links (in cells)
be restricted to specific inputs for the materials desriptions. I'm stumbling
around MS's site with little luck so far.
i.e. Categories: TYPE-drama, ficion, romance, etc (limited to my list)
Details: Theme-suspence, action, etc (limited to my list)
etc., etc.

 

[Duane Hookom]

You mention "database design" but then state "in cells". If you are using
Access, you would use the combo box wizard on forms to create dropdowns based
on small lookup tables.

 

[John W. Vinson]

This is going to be an easy one. I am creating a library database of books,
leaflets, brochures, etc. I want to have certain drop-down links (in cells)
be restricted to specific inputs for the materials desriptions. I'm stumbling
around MS's site with little luck so far.
i.e. Categories: TYPE-drama, ficion, romance, etc (limited to my list)
Details: Theme-suspence, action, etc (limited to my list)
etc., etc.

"Cells" is an Excel concept; database tables don't contain cells. And you
should not be looking at Table datasheets directly in any case - you should
have a properly normalized set of tables, and use Forms (with combo boxes,
dropdowns if you will) on the Form.

Here's some resources to get started; Crystal's video might be a good jumping
off point.

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

 

[Tony Toews [MVP]]

This is going to be an easy one. I am creating a library database of books,
leaflets, brochures, etc. I

Fred might've already done a lot of the work for you. See Fred Boer
Library Systems: Home of "My Library" and "My First Library"
http://www3.sympatico.ca/lornarourke/fred.html

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a free, convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/