[AccessD] Table Structure Ideas

Hi Everyone,

 

Got a complex form that we're turning into a DB and having difficulty coming
up with a good table structure to suit the form and the way the data is
collected and input.

 

They want the Access DB to mirror the form. You can see the form here:

 

http://download.actebs.com.au/FormDoc.jpg

 

As you can see by the example image above the sample are marked as A, B, C,
and D, but sometimes they display it vertically and other horizontally,
which is confusing the hell out of me. Any idea on how best to design the
table structure so the data is easy to work with down the track?

 

Any ideas most welcome.

 

Thanks in advance.

 

Vlado