Structure for a Publications database

[SJW]

As a relative novice on Access, I want to get the basic structure of a
publications database correct before starting. I have several hundred
publications I need to arrange that allows the user easy access to the
publications. We have decided on Five main categories, with multiple
sub-categories under each main category (the largest is six sub-categories,
the smallest two).
I was thinking that to go through the Main Switchboard to another
Switchboard page for categories, then further page (s) for sub-categories
would be cumbersome, as it would require a table for each sub-category (is
that correct assumption??).
But there must be a more efficient way of sorting. Would having a "Main
Categories" combo box on a Form, which asks the user to select the category
from a drop-down menu be more effective? Once they had selected their
category, then the sub-categories for that category appear on another Combo
box, which then allows the user to select their sub-category of interest.
Once that is selected, then they are able to view a list of the titles of
all publications under that sub-category and select the publication of
interest.

However, I am open to suggestions of the most effective means of sorting
these publications. Hopefully, I have explained myself clearly. I am using
Access2003. No doubt I'll have more questions, but I'd like to get the basic
structure right before starting.

many thanks for assistance
SJW

 

[KARL DEWEY]

as it would require a table for each sub-category (is that correct
ssumption??).
No, just a separate fields for categories and sub-categories.

If all you will be doing is what you stated in your post the I do not thing
you really need a switchboard. Use forms with cascading Combos to search and
data entry.