I am wondering if someone can critique my database design?
I feel that the database is quite "buggy." For example,
1.) There's a lot of run time errors popping up (see screen shot).
2.) I don't like that you can only see the coded value after the value has been entered in the form view. For example, for questions that have codes associated with a value, all you can see is the code (e.g., 1, 2, 3, 4), not the actual value. It would be better if the user can see both.
Sometimes if you hit the wrong button, the entire database just vanishes or gets renamed. This is very strange and has happened to me twice while I was trying to give a training on this database. .
I wonder if this is just Access or does my database just have a poor design?
Please see attached. Any help is greatly appreciated!