Hello, I am building an Access 2007 form for users to enter data concerning medical literature. The form will end up being more complex than the version posted here, but in this early state I would just like to know if there are less cumbersome ways to go about doing some of the data entry tasks. The database consists currently of 1 form, frmPtCharacteristics, and several tables from which combo/list boxes are populated. My question is from two points:
first, do more experienced database creators have feedback on how to make the form more asthetically pleasing?
second, are there ways to improve the usage of space on the form? That is to say, can something be done to reduce having 3 repeated fields for Race etc... to describe the patient population of a study? This is my primary concern as a study might have more than 3 different categories for these variables and it would be awful to have to make additional selections for each of these. Maybe this is unavoidable, but I wanted to get some expert opinions on the matter before I resign myself to it.
Please, any help at this stage would be invaluable,