How would you design this database?

[LBERG]

Hi,



I have designed one database to date (so I'm not very experienced), and had the help of this forum. For the next database I am tasked with, I'm not sure if Access is the right program to use or how to set it up, so any advice is appreciated.

Basically, I have a very large number of documents which I need to set up into an electronic library.

I want the user to be able to search the library by topic, document type (Q&A, meeting minutes, reports, etc), and by key word search.

Any ideas on how to design this type of database?

Thanks in advance!!!

LBERG

[LBERG]

Here's what I am thinking:

I'll need a table each for topics, document types, and key words, as well as a table hyperlinked to the documents themselves. But I'm not sure if each document can be related to multiple key words etc?

[orange]

There are some free data models at
http://www.databaseanswers.org/data_models/index.htm

some relate to Documents that may apply.

Do you have a List of Topics? Document Types? KeyWords?

How would/do you plan to populate these tables?

Just curious. Good luck