MAKING A DATABASE

[MAR]

am about to do an access database that will store
information about projects, so far i can visualise a
client table(client id(p.k..), client name, address etc, a
project table(proj id(p.k.) client id(f.k.) proj name,
proj type, proj start date etc. Then i have to record the
amount of time spent by our emlpoyees each month on the
various projects, there are two groups a and b, and i also
have to record all invoices received each month for each
project. How do you thinki should do this?
Do you reckon:
a) have a 'Month' table with entries for each project for
each month - this ends up with a load of repeating fields.
b) have a new table for each month-this will result in a
load of tables.
c) Have separate tables for group a, group b and for the
invoice entries?

 

[chris]

I suggest you use a single "ProjectTime" table that has
columns for Project Id, employee, group, and either
startDateTime and EndDateTime or Date and TimeSpent.

Not sure about the "group" What are they groups of?
Clients?, employees?, Projects?
The group should probably be a column on one of the other
tables.
Your reports/queries can produce monthly details/summaries
from this.