Representing and displaying multiple skill levels for list of skills

  • Thread starter Thread starter Nicholas James Pitt
  • Start date Start date
N

Nicholas James Pitt

Not sure whether this comes under table design or form design as the
question covers both so hope this group is Ok.

I have a questionaire that I am creating a database for. One of the
questions lists a number of skills e.g. Word Processing, Spreadsheets,
Databases etc. and has skill levels ranging from 1 to 10. My question is
what would be the best way of representing this in a table and what would be
the best way to display it on a form to allow the selections to be made.

Many thanks.

Nick
 
Hi Allan.

Thanks for your reply. Took your suggestion and it works like a charm.

Regards.

Nick
 
Nicholas James Pitt said:
Not sure whether this comes under table design or form design as the
question covers both so hope this group is Ok.

I have a questionaire that I am creating a database for. One of the
questions lists a number of skills e.g. Word Processing, Spreadsheets,
Databases etc. and has skill levels ranging from 1 to 10. My question is
what would be the best way of representing this in a table and what would
be the best way to display it on a form to allow the selections to be
made.

Many thanks.

Nick
Click to expand...

If there is a small, fixed number of such skills then the design will be
much easier if they are included directly in the questionaire-response
table. Just define a numeric field of type byte with a validation rule to
ensure people enter a number between 1 and 10. You could show this on a
form as a combobox (dropdown list) or perhaps an option group consisting of
10 radio buttons or in fact anything from a plain old texbox to the
lesser-spotted slider control.

If the number of skills becomes large or likely to change, then you could
have the classic 3-table setup where you have tblPeople, tblSkills and
tblPeopleSkills which is a junction table to show which people have which
skills. This could be shown on the form as a subform.
 
Hi Justin.

Thanks for your reply. The list in printed form has an option "Other". As
this means that people can list other skills, I went down the three table
route as you mentioned and using the option group for the skills level and a
combobox to select skills on a continuous sub-form it all seems to work
great.

Regards.

Nick
 
A lot of option groups with 10 buttons each would clutter the form and, if
other options become availabel in the future, more modification to accomodate
them. Either a combo box or a text box with validation would be better.
 
I would, for each skill, have an option group with 10 options.

In the forms header put the relevant number 1 to 10 above the relevant
column of options. So when the user makes a selection you are only storing
one value not 10.
 
Back
Top