EAV Tables and Access

[grovelli]

I find it difficult to get my head around the EAV data model concept. Can I have an example of a table that uses such concept?

the data type of a value column in a row-modelled table is pre-determined, whereas in an EAV table, a value's data type depends on a attribute recorded in a particular row.

[HansV]

I'm busy right now. I'll get back to you later today.

[HansV]

Here is a very simple example (tables only): questionnaires with questions with different response types.

EAV.zip

[grovelli]

It does mention understanding the EAV model does require time
Have you ever used this data model in Access applications?

[HansV]

Yes, in my previous job I built an actual questionnaire database using EAV.

[grovelli]

"the data type of a value column in a row-modelled table is pre-determined, whereas in an EAV table, a value's data type depends on an attribute recorded in a particular row"
You can actually see that being the case in your tblQuestion and it's interesting that you use the LookUp tab to represent a table column whose data type can vary because normally table fields data types are set in design view.