I've had several people ask me about designing forms in Access. I realized that it's a topic I have not really covered to this point.
So, I'm starting a new series of articles focusing on form design.
Many (most?) of these articles will be little more than screenshots to help inspire you to create your own designs. I am by no means a designer, so don't expect to be blown away by pretty interfaces. However, I do go to great lengths to make my forms as user-friendly as possible.
Some of the topics I'll touch on include:
- Matching form design with table relationships (i.e., 1:1, 1:∞, ∞:∞)
- Font choices
- Color choices
- Visual consistency
- Bound vs. unbound forms
- Subforms vs. standalone forms
- Tab controls
- Overlapping windows vs. tabbed documents
- Form resizing
- Entering dates
- Checking for empty fields
- Highlighting the active control
- Highlighting the active row
If there are any topics you are particularly interested in, be sure to let me know in the comments below.
If you use an RSS reader, you can subscribe to new articles in this series by using this link: Form Design RSS Feed. Alternatively, you can just bookmark the Form Design tag site below and check back occasionally for updates.
Better yet, subscribe to my weekly newsletter and get seven articles about the Microsoft Access world delivered to your inbox every Sunday morning!