Business Database Help

[Jsha]

I am setting up a Database for my company, we want to do it in our local branch first then hopefully we can role the idea out to the entire company. I have started the database already just setting up the tables I need, I think my Design is slightly off though. I am asking for the forums help if that is okay, okay here is the setup.

Areas Needed:
Employee
Projects
Clients

Employee Area:
Date of Hire
fname
lname
salary
title
timesheets
etc...

Project Area:
project #
project name
client
budget info
etc...

Client Area:
client name
addy
contact info
etc....

Project area is going to be the main hub for everthing else, the project number is the key to the entire database. client will be attached to a project via project number, employees timesheets tracked by project number, invoices printed by project number. timesheets will generate the invoices to the client. You guys get the idea, I hope that some of you guys can help me in the spare time you have.

Again, i am looking for Design assistance, i will post a sketch of my design in a couple.

 

[carash77ash]

Go and get yourself access 2003 for dummies. It is a great reference guide to starting out. It will explain how access works and the principles behind db design.

It also gives great examples.

I still use the book as a guide when stuck on a prob.

Ash

 

[RV]

Project area is going to be the main hub for everthing else

Not what I'd suggest.
You need to think in relational databases and normalisation, using main hubs as per your idea is bad and I mean bad practice.

Read up first and have a look at sample databases, such as the Northwind sample.

RV