Mimicking Paper Systems In Access. 

You can use the fields identified in the reports as the basis for the tables you create to store your data. Here's another tip to make your Access solutions a hit in offices where the same paper-based data entry form has been in use forever. Make the data entry form match the paper form as closely as possible. 

What that means is you can't just use the AutoForm tool to create a columnar- based data entry screen and assume that users will adapt to the design you've imposed on them. Instead, here are three tips to help make your online form mimic the paper form as closely as possible. 

Arrange the labels and input fields on your Access form in the same order they appear on the paper form. 

Try to match, as closely as possible, the font style, font size, and spacing between items, but don't worry about trying to cram everything into one screen. Data entry clerks don't mind clicking through to a second screen page when the screens look just like their paper forms. 

If the printed input form contains graphics such as lines, borders, or images, reproduce them too. If the client doesn't have electronic copies of the images on the forms, scan the document and create your own images.

<<<Back Home Next>>>