It’s staggering how many shareware and commercial database applications have appalling data entry screens. Many developers seem to think that well-oiled inner workings are all that’s needed to sell an application, when any user knows that, when you get down to it, the interface is the app.
When you’re designing a database application, you’re taking on the role of a developer. As you do so, remember to keep the soul of a user. While the brain work in building a database comes during the design stage, the hard slog comes when you – or other people – start adding data to that structure, especially when there are copious amounts of data to add. You can alleviate much of the tedium of data entry by ensuring your data entry forms are logically organized, easy on the eyes and efficient.
Exactly how you design your data entry screens will depend on the database program you’re using, the amount of data you’re dealing with, the needs and likes of the data entry personnel, and any application-specific requirements that may exist.
If you’re designing a database purely for your own use it’s still worth designing well-thought-out data entry screens. After all, why should you make life harder for yourself when a little effort in the design phase will make using your database easier for all time?
The following guidelines will help you design data attractive and easy-to-use data entry screens.
Group related fields together and use boxes or color coding to make it easy for users to zero in on information quickly.
Space fields on the screen so users can easily spot the field they need to edit.
If possible, make sure all your fields are visible simultaneously, so users don’t have to keep switching between the keyboard (for data entry) and the mouse (for scrolling), and so users can see all information at a glance. It’s also worth avoiding scrolled data entry screens as people have a tendency to forget about those invisible fields lurking off the bottom of the screen and leave them blank.
If you have a large number of fields in your database and you don’t want to create clutter but still want to avoid scrolling, try using a tabbed interface (see Figure 2). With a tabbed interface, you can separate fields into logical groupings, with each group on its own tab. This approach avoids clutter while keeping everything on the screen.
At the most, your data entry screens should use three fonts – one for the headings, one for field labels, and one for the field contents themselves.
For best readability, use sans serif fonts such as Arial, Verdana and Trebuchet MS (sans serif fonts lack the little ‘feet’ or extra small lines at the end of characters that you’ll find in serif fonts such as Times New Roman). If large amounts of text will be entered in text fields, you may wish to use Times New Roman or another serif font for the fields. Choose standard fonts, especially if your database will be used on a variety of computers. Make sure all text is of a readable size.
Avoid lairy colors. Instead choose soft colors or those that provide good contrast for the fields and captions. If a number of people will be using your database application, keep in mind that some of them may be color blind or suffer from other eyesight difficulties.
Dump the default data entry screens created by Approach, Access, FileMaker and most other databases. They are usually poorly organized and either look boring or hard to read. Access is particularly bad in this respect, while FileMaker offers the best standard screens.
Use these default screens as a starting point and tweak them or, if you don’t mind the extra work, build your screens from scratch.
Ensure that Tab order is correct. During data entry, you move from field to field using the Tab key. It’s important you ensure the Tab order is consistent, so that the insertion point moves from the first field on the screen to the last without jumping about. Incorrect tab order will not only frustrate your users, but it may cause them to enter data into the wrong field.
You can change the tab order in Lotus Approach via the View Menu, Show Tab Order option when in Design Mode. In FileMaker Pro, you can change the tab order in Layout Mode via the Layout Menu, Set Tab Order option. In Access, open the form in Design View and choose Tab Order from the View Menu.
If you application has more than one data entry screen, use the same look and the same organizational principles for each screen. If, for example, you place a Close button on one data entry screen so users can close the screen with a mouse click, include the same box in a similar location on other screens.
Add descriptive help where possible. Your data entry forms should be as self-explanatory as possible, with commonsense labels on each field.
You can make data entry even easier by providing help for each field. In Microsoft Access, for example, you can add a pop-up field tool tip which will appear when the user lets their cursor linger on a field (see Figure 3).
If your database doesn’t support such tool tips, you can include instructions directly on the data entry form itself. For instance, if you want people to enter phone numbers without including any special characters (such as hyphens or parentheses) you can add a message to that effect beside the phone number field, thus: Enter numbers only, eg. 0291237745.
You can speed up data entry dramatically by providing shortcuts such as drop-down boxes with predefined choices, auto-filled fields, multiple choice fields and so on (see Figure 4). Some of these features you can add during the database definition stage, although we kept things simple in the previous tutorial and avoided such options. Others you can add when you design your data entry forms. Still others you can introduce by using lookup tables or related tables, which let users ‘look up’ related information and have it entered automatically.
You should design your forms so they check for invalid data and give users a chance to correct mistakes they’ve made. Much of this validation can be done during database definition; some you’ll add during form design.
We’ll look at data validation in more detail in the future as well.
Each database program provides different tools for designing data entry forms. Most are very fiddly to work with, so it pays to practice. One of the best ways to do that is to use the standard data entry form created by the database and then mess around with it. Don’t do this experimenting on a ‘live’ database. Create a sample one from scratch, if you like, and work with it.
If you’re using Lotus Approach, you modify the data entry screens by clicking the Design button on the toolbar. Then click the Properties button on the toolbar (its icon is a yellow square overlaying a blue square at an angle) and then try clicking different objects on the screen and inspecting and changing the contents of the Properties box for that object.
In FileMaker Pro select Layout Mode from the View Menu. Right-click an object to adjust its properties.
In Access, select a table in the Tables section of the database objects window, click the New Object: Autoform button on the toolbar to create a new form, and then click the View button on the toolbar to switch to Design View. Click the Properties button on the toolbar and select different objects on the form to adjust the settings.
We’ll do some hands-on forms design in the next article in this series.