Access Questionaire with score weighting to each question

[craigmase]

Good afternoon
I'm looking to build an access database as an audit/questionaire tool
This was simple enough in Excel but the powers that be want access

So it's a few sections of questions that will be score weighted, so it determines whether a person has passed the section using multiple choice answers. then at the end determine if pass/fail the questions as a whole...

does that make sense?

The problem is I'm a complete noob...

 

[Kyle123]

A questionnaire in a relational database is generally very hard. The problem is that of data types and how to store the answers.

Before worrying about weighting, you need to get a very good understanding of relational database principles or you are going to make a mess that will make life very, very difficult in the future.

I suggest starting here (Relational Database Principles), get an understanding, sketch out a database schema and ask for feedback. Access isn't like Excel, it's not trivial to change structure which means getting the design right from the outset is the most important thing.

 

[craigmase]

Thanks I will have a look