CMC
Technology and Academic Integrity
E-COMMUNICATION PRESENTATION E-PAPER DATA ANALYSIS E-RESEARCH E-ETHICS DATABASE
 
banner
welcome more menu
intro to dbs
design more menu
simple db more menu
queries more menu
forms more menu
reports more menu
miscellaneous more menu
conclusion more menu
Go to Automatic Form Generationnext

Data Entry Forms

Why Forms are Useful
The datasheet view may be useful for entering large amounts of data or testing the database, but it is not particularly user friendly, especially for those who are unfamiliar with Access. This is where forms come in. Much like the DMV gives you forms that clearly indicate what information they want and in what format it should be, Access gives you the opportunity to create similar, user-friendly forms. There are two major benefits of this. Firstly, forms are very easy to use. Instead of the datasheet view, users are greeted with simple areas to enter information. More importantly, the type and format of input is restricted. For example, if you have a date field, users will not be able to enter "heehee." Instead, they will be forced to use a date drop down. This can also help with such difficulties as some people entering dates as MM/DD/YY and some as DD/MM/YY.

back Back to Queries

Copyright © 2007 Claremont McKenna College