RE: Creating an DB for an Office Tota/Skills

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Do you have any tables? I would suggest the following to get you started:

tblPeople
================
peoPeoID primary key autonumber
peoFirstName
peoLastName
peoStatus
peoComments

tblAbsentPeople
===================
abpAbPID primary key autonumber
abpPeoID foreign key to tblPeople.peoPeoID
abpDate date they will be gone
abpReason reason for absense

tblDates (one record for every possible date)
===================
datDate date/time field

Create a cartesian query that will display every person for every date like:
qcarPeopleDates
=====================
SELECT peoPeoID, datDate
FROM tblPeople, tblDates;

Then create a query of qcarPeopleDates and tblAbsentPeople. Set the joins
between the table to the date and peoID fields. Have the join display all
records from the qcarPeopleDates. Set the criteria under abpAbPID to:
Is Null
This will then display every person for every date that they will not be
absent.

For skills, create two more tables:

tblSkills (one record per skill)
==============
skiSkiID autonumber primary key
skiSkill skill title

tblPeopleSkills (one record per person per skill)
=================
pesPeSID autonumber primary key
pesPeoID foreign key to tblPeople.peoPeoID
pesSkiID foreign key to tblSkills.skiSkiID

--
Duane Hookom
Microsoft Access MVP


"Tobes" wrote:

Im tryin to create a database where if i download the *** with the data of
people absent from my office. Inputed that data into a table somehow. Then
how
could i make it show me the people in the office instead of thw people
absent. So something like subtract the names from a total list of all the
people in the office.

Then also create a skills section which gives each person in the office a
tick or X in a table with their skills in it. So then people could look at
this go, oh on monday 31st .. MR joe Bloggs is in and he is skilled in
....... and look what skills he has an X in...

Does this make any sense ? if so how would i go about doing it :P?

.

Quantcast