Database for central filing system

[editprod]

I'd like to create an Access database for my the central filing system
of my office. My boss can never find where files are. We have approx.
2000 files in a dozen file drawers, each drawer with a master category
(company, goverment, organiations, archives, etc.) and containng folders
sorted alphabetically by subcategories or topics. There's a lot of
overlap and imprecise naming for the subcategories. The database should
provde the means to search eletronically to locate files by cabinet,
drawer, main category, sub-category, the myriad of freestyle
subjects/keywords describing the contents of the files, date, or
numbering convention.

I've had previous experience the production department of a book
publisher where tracked computer files and backup tapes & CDS. We used
table design to list titles by book series, ISBN #, author, book title,
date, etc. I'd like to do something similar for my current employer, be
it a table design or other front end. Any suggestions? (Any template out
there already designed for this task?)

Thanks.

[Barry Edmund Wright]

On Jun 9, 2:13 pm, editprod <[e-mail]:

I'd like to create an Access database for my the central filing system
of my office. My boss can never find where files are. We have approx.
2000 files in a dozen file drawers, each drawer with a master category
(company, goverment, organiations, archives, etc.) and containng folders
sorted alphabetically by subcategories or topics. There's a lot of
overlap and imprecise naming for the subcategories. The database should

Try not to reinvent the wheel. A cursory google search revealed
several filing systems this is one of them.
http://www.thepapertiger.com/buy_org...l_software.php

provde the means to search eletronically to locate files by cabinet,
drawer, main category, sub-category, the myriad of freestyle
subjects/keywords describing the contents of the files, date, or
numbering convention.

I've had previous experience the production department of a book
publisher where tracked computer files and backup tapes & CDS. We used
table design to list titles by book series, ISBN #, author, book title,
date, etc. I'd like to do something similar for my current employer, be
it a table design or other front end. Any suggestions? (Any template out
there already designed for this task?)

Thanks.