Solved

Please help with Access 2007 Form Design (current form attached)

Posted on 2011-03-02
10
252 Views
Last Modified: 2012-05-11
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,
Bevo
EE-ABS-Example.accdb
0
Comment
Question by:Bevos
  • 4
  • 4
10 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 334 total points
ID: 35019255
<do more experienced database creators have feedback on how to make the form more asthetically pleasing?>
Beauty is in the eye of the beholder.

You can listen to Experts argue all week as to what is "aesthetically pleasing"

"Form follows function"
Make the form *Work* worry about looks later...

I am sure other experts will post great suggestion of your "Space" issues...

;-)

JeffCoachman
0
 

Author Comment

by:Bevos
ID: 35019292
Hi again Jeff, thanks for the feedback.  I agree with what you're saying, but do you believe there is no way to adjust how the items here are entered to make it more functional for the user?

Thanks for any feedback,
bevo
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35019315
Yes adjusting the controls was your second issue...

I was posting on your first concern about aesthetics...

;-)
0
 

Author Comment

by:Bevos
ID: 35019361
Haha, thanks :)
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 334 total points
ID: 35023040
The first thing I will say is that tblPtCharacteristics is not "Normalized"

The tip-off is that you have fields named: XXX1, XXX2, XXX3, ...etc

This is a fairly involved subject, but this need to be taken care of first. (Before any discussion about form design.)

Here are some great references:
http://databases.about.com/od/specificproducts/a/normalization.htm
http://support.microsoft.com/kb/283878
http://www.amazon.com/Database-Design-Mere-Mortals-Hands-/dp/0201752840/ref=sr_1_1?s=books&ie=UTF8&qid=1299109358&sr=1-1

JeffCoachman
0
 

Author Comment

by:Bevos
ID: 35023139
Hi Jeff, so to get it to be 1NF I need to have each of those as a separate table? i.e. tblRace1 with [Record Number] as unique ID and then a relationship to the original database?  Is that the only type of error you see or are there more?

Bevo!
0
 
LVL 28

Assisted Solution

by:burrcm
burrcm earned 166 total points
ID: 35042300
In terms of space and simplicity of appearance, I like to have a selection on one form open another and close the current one, or a stack of subforms which become visible / invisible based on selection, leaving the original form open if for example there are parameter fields on the first form which remain valid throughout the process. The advantage of this system is plenty of real estate to work with and uncomplicated layouts along the way. I trust this makes sense to you.

Chris B
0
 

Author Comment

by:Bevos
ID: 35057546
It does now! Thanks Chris B.  So, if I wanted to describe groups of patients, I should have a subform that's opened when the user selects group?  This form would have the characteristics of that group listed and then a button to add or remove other groups assigned to that [Call Number].  Anyway that I think that is great advice so far.  

Thanks again Chris,
Bevo
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 35059517
...but the table(s) still needs to be normalized first...

Again, Tables design and relationships first.

Forms only after the design is proven to be sound...

;-)

JeffCoachman
0

Featured Post

Free Trending Threat Insights Every Day

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now