creating a database to organize files

[Jez.Slade]

I want to create an Access Database that will allow the user to:
-Enter a Description / Name of a pdf
-Catagorize the pdf in multiple catagories (cross referencing)
-define key words to the pdf

there will be roughly 400 pdf's that will be entered and catagorized,
some in as many as 4-5 catagories, some only in 1.

User will be able to search for pdfs by catagory, name, or keyword

User will be able to view lists of pdf's by catagory

User will be able to print full lists of pdf's by catagory or
individually


Is there already a template that will do this?

if not, where is a good tutorial?

I havn't used access in several years, so am a bit rusty, and have 0
experience in the 07 version... Any and all advise is welcome.

Thank you!

JEz

 

[Fred]

Your application is very simple and can be done with one flat table.

I think that you received no answer because you phrased your question as the
"T" (Template) word.

You are writing to experts that could design your database in in their head
in 30 seconds and in 5 minutes write / tell you how to do it. By using the
"T" word, you inadvertantly told them that, instead of 5 minutes of their
expertise, you want them to find somebody else's work to use, and then learn
the other person's work so that they can tell you how to adapt the other
person's work to your application.



Sincerely,


Fred

 

[John W. Vinson]

I want to create an Access Database that will allow the user to:
-Enter a Description / Name of a pdf
-Catagorize the pdf in multiple catagories (cross referencing)
-define key words to the pdf

there will be roughly 400 pdf's that will be entered and catagorized,
some in as many as 4-5 catagories, some only in 1.

User will be able to search for pdfs by catagory, name, or keyword

User will be able to view lists of pdf's by catagory

User will be able to print full lists of pdf's by catagory or
individually


Is there already a template that will do this?

if not, where is a good tutorial?

I havn't used access in several years, so am a bit rusty, and have 0
experience in the 07 version... Any and all advise is welcome.

I'd recommend three tables: a table of Documents, a table of Keywords, and a
table of DocumentKeywords.

Documents
DocID <primary key>
Filename <text, full path and filename; or Hyperlink>
Description <text or memo>

Keywords
Keyword Text <primary key>

DocumentKeywords
DocID <link to Documents>
Keyword <link to Keywords> <two field joint primary key>

You could then use a form based on Documents, with a subform based on
DocumentKeywords; include a combo box on the subform based on Keywords.
Queries joining Documents to DocumentKeywords will let you create all your
desired lists, using forms for onscreen display or Reports for printing.