Lookup tables & scoring system

[Clim]

I've been asked to prepare a DB for our Nursery dept. It's a form for visiting parents before their child joins the school. I have many lookup tables linked to the main table e.g. "Interest in Reading" may be (i)nil (ii)indifferent (iii) high. Each choice scores; i.e 1point for (i); 2 for (ii); etc. At the end they want a total score for all questions answered. On the form there are list boxes created from these aforementioned linked tables. What is the neatest (and easiest to understand for a relative newcomer to Access) way of doing this please
Thanks in anticipation.

 

[Tim Ferguson]

What is the neatest (and easiest to understand for a relative newcomer
to Access) way of doing this please?

I would be asking what advantage you hope to be gaining from Access in this
situation, given that you can create a solution in something like Excel in
a fraction of the time (like about five minutes...)

The "correct" solution would be a table for Applications, one for
Questions, one for Answers and one for Results -- see At Your Survey on
Steve Lebans web site for a working example. If you have started down the
Look Up Wizard path, then you are creating a huge amount of extra work that
you will have to undo before getting any useful results.

Best wishes


Tim F

 

[Clim]

Hi Tim,
Many thanks for your response; I assumed (maybe wrongly after all!) that I would need to use Access in order to best interrogate the data later and allow people to research the results according to their own criteria choices. Maybe Excel would allow this?
Ideas have been much appreciated-thanks
Paul

----- Tim Ferguson wrote: -----

What is the neatest (and easiest to understand for a relative newcomer
to Access) way of doing this please?

I would be asking what advantage you hope to be gaining from Access in this
situation, given that you can create a solution in something like Excel in
a fraction of the time (like about five minutes...)

The "correct" solution would be a table for Applications, one for
Questions, one for Answers and one for Results -- see At Your Survey on
Steve Lebans web site for a working example. If you have started down the
Look Up Wizard path, then you are creating a huge amount of extra work that
you will have to undo before getting any useful results.

Best wishes


Tim F

 

[Tim Ferguson]

Maybe Excel would allow this?

Excel has very strong and often under-appreciated list management tools,
including sorting, grouping and summarising, projection and selection and
so on. And because it's all GUI, it is much quicker than messing about with
programming and SQL solutions.

B Wishes


Tim F