Database design

  • Thread starter Thread starter Kaz
  • Start date Start date
K

Kaz

I need to create a database for the various policies in
our organisation, not sure where to start as I am pretty
new at access.
There are several departments which are broken down into
sections. eg Support & Planning = I.T,Finance, Stores, etc
Each section has 1 or more policys.
I need a link to the policy as a word doc and short a
description of the policy.
Users need to be able to access the policys on the
intranet.
Any help in pointing me in the right direction would be
appreciated.
 
How about
tblDepartments
dptDptID autonumber PrimaryKey
dptTitle

tblSections
secSecID autonumber primarykey
secDptID foreign key to tblDepartments.dptDptID
secTitle

tblPolicies
polPolID autonumber primarykey
polTitle
polFileName

tblPolSec
posPoSID autonumber primarykey
posPolID foreign key to tblPolicies.polPolID
posSecID foreign key to tblSections.secSecID
 
Back
Top