Need advice on database design - Education Example

[Stephen Evans]

I have been asked to design a database to record details of
individuals level of knowledge following a skills audit.
The information supplied is name, subject, and a single entry in one
of five tick boxes to record the individuals level of knowledge.

What tables are required, is it possible to use radio buttons or tick
boxes when entering the information on a record?

How is a query constructed to report details of those that do not
reach one of the levels of attainment in a given subject?

I have not used access in a number of years, and are therefore finding
this difficult. Any assistance will be much appreciated.

regards

Steve

 

[Steve Schapel]

Steve

Essentially you need a table with 3 fields only to record the data you
have mentioned, for the person, subject, and knowledge level.

You might also want two other tables, to record all the people involved,
and a lookup table to list the available subjects.

Assuming you do this, for your data entry I would make a continuous view
form, based on your main table, with a combobox bound to the person
field, set up so that it displays a list of names (row source from the
Persons table) for you to select from; a combobox bound to the subject
field, set up so that it displays a list of subjects (row source from
the Subjects table) for you to select from; and an Option Group bound to
the Knowledge field, with 5 option buttons to represent the 5 levels.

This means that the Knowledge data will be stored in the table as a
number between 1 and 5, and you will be able to use this in the criteria
of any queries you need to select data for your reporting.

My reply is quite general, so please post back if you need any more
specific help with any of these steps.