COrrespondance DB

[Guest]

My experience of Access is very limited, so in order to obtain a better
understanding my aim is to create a small database that will help me to
manage incoming and outgoing correspondence.

The correspondence comes in with its own reference number, date, sender and
recipient etc.

The database will be used to store the correspondence details and allocate a
Company Document Reference number.

The table headings are shown below.


Project ID
Project Name
Project No
Project Start Date
Project End Date

CompanyDocumentReferenceID
CompanyReference No

IncomingDocumentRefernceID
IncomingReference No

RevisionID
Revision

DateID
Date

Sender/RecipientID
Name
Initials
Position
Discipline
Company

Document TitleID
Title

DocumentTypeID
DocumentType


The primary key is allocated to the word xxxxxID in each table. Is this
correct?

Should ther be any other type of key in the table and if there is how is it
included.

Should the CompanyDocumentRefernceID be in each table?

If the CompanyDocumentRefernceID goes in each table how are the tables
linked for the relation ships.

Many thanks for any assistance provided.

Zephyr

 

[Guest]

I can not tell what is to be one the top of the heap. Think of a database
as a room full of sheets of paper and you need to find something in
particular. How do you start looking - top to bottom, lwft to right, front
to rear, or some other relationship.

In this room you have filing cabinet, each cabinet has drawers, each drawer
has folders. each folder has stacks, and each stack has many sheets of paper.

How are the cabinets, drawers, folders, etc to be labeled so you do not need
to look at each sheet of paper.

What purpose are tables RevisionID/Revision and DateID/Date serve? They
seem like a list of revision letters or numbers and a list of dates.

What is to be the order of filing - Project, Company, or date. What has the
Sender's Discipline have to do with you filing scheme?

Lay out your tables as you would an outline or your filing cabinets.