Access 2010: Forms

Access Forms are an excellent way for users of a database to add or modify data. By using forms for data entry, a database designer can validate and control the data that enters a database as well as create an "easier" method of data input.

Additionally, forms can be used as a navigation object, or Switchboard, to direct a database user to the different areas of a database, even if the user has never used Access. In this workshop, participants will learn how to:

  • Create a form from a table or query using AutoForm
  • Create a form from a table or query using the Form Wizard
  • Create a form directly in the Design View
  • Modify a form in Design View
  • Add subforms for records in a form
  • Sort and filter records in a form
  • Format controls conditionally
Office Productivity


We highly recommend that you attend any prerequisite workshops listed below since familiarity with the skills and concepts taught in them is essential to benefit fully from subsequent workshops.

However, if you have independently learned the skills and concepts of the required workshop(s), your "equivalent skills" will be accepted as a substitute for attending the prerequisite workshop(s).

To help you determine your skill level, click workshop titles below (if any) for descriptions which outline the topics taught in each workshop and that are assumed in later sessions. You are expected to know the commands and concepts listed within the descriptions for the prerequisite workshop. In most cases, you can also refer to workshop handouts and other helpful materials from the workshop description page.

In addition to any specific prerequisites listed, you should have, as a minimum, basic computing skills.

Pre-requisite workshops

Upcoming workshops

There are currently no upcoming workshops scheduled for

The University of Kansas prohibits discrimination on the basis of race, color, ethnicity, religion, sex, national origin, age, ancestry, disability, status as a veteran, sexual orientation, marital status, parental status, gender identity, gender expression and genetic information in the University’s programs and activities. The following person has been designated to handle inquiries regarding the non-discrimination policies: Director of the Office of Institutional Opportunity and Access,, 1246 W. Campus Road, Room 153A, Lawrence, KS, 66045, (785)864-6414, 711 TTY.