home filing system - need sample

[ellism1]

I'm looking for a sample database (not a single table, but more robust
design).

I have some ideas, based on something we have at work, but I'm wondering if
anyone else has done this and could suggest a structure.
What I'm trying to do is to index with keywords all the files I have in my
filing cabinets at home. I have multiple business activities, volunteer
interests and general personal files that I want to be able to search for,
regardless of their specific file title. alphabetical filing has been
insufficient for me to find things that I put in my filing cabinet years
ago. maybe can't remember exactly what I called it or what cabinet, or
bookshelf it is on. I want to go through all the files and index each item.
then as I add things to it, it won't matter where I physically put the item,
just that I index it with sufficient keywords and text so I can later search
for it and find it's index number. For example, in our office, we have an
extensive list of keywords defined. Files in folders are indexed with a
sequential number 00015-A-1 means it's file number 15 in file cabinet A,
drawer 1. It will have a description which is the title on the tab of the
file folder and then a series of keywords which are written on the front of
the folder and entered in the Lotus Notes database along with an unlimited
amount of text or even electronic files.

I want to create a similar structure at home, but use Access because Lotus
Notes won't be available to me at home.
Any suggestions?

 

[Guest]

Microsoft has a number of templates posted, this one could possibly be
modified to support your needs. There are fields for Pages and Shelf Number.
Those could perhaps be modified to being a Storage Location and Shelf/Drawer
Number. You would probably want to personalize the Topics for your own
needs. Remember, if you are changing the names of fields, those will need to
be updated in the queries and forms associated with the tables using those
fields. If you don't want to be bothered with that, you can just make a note
to yourself that certain fields have new meanings, and just update the titles
on the forms to reflect what they are (since titles are just text fields).
The Notes field may be a memo field, which I believe cannot be searched on.
However, you might be able to use the Publisher Name field for searchable
terms, since that should be a simple text field. Then the Cover Type could
be used to indicate whether this is a book, magazine, stapled copy, or
whatever.

There doesn't seem to be any good search mechanism built in to this
particular template, so you would have to create some forms that could do
that.

http://office.microsoft.com/en-us/templates/TC010186431033.aspx?CategoryID=CT011366831033