"Using Microsoft Access forms to display records in a far easier layout and format will give users the confidence and the comfort in controlling data processing tasks..."

Designing forms is critical for other users who will be responsible for the day-to-day running of a database and have very little knowledge of the structure of an Access database or its background processes.

This type of component is deemed as part of the front-end of Microsoft Access and is an optional object that is implemented as part of the database application.

To help identify whether you will need an Access Form, you may need to answer some of the following questions:

• Are you going to be the sole user of the Access database application?


• How many other users may be responsible for maintaining your Access database?


• What is the life expectancy for your database?


• Are general user's proficient with Microsoft Access and their management tools?


• Do you need to add some level of security?


• Do you have sensitive data that you need to restrict?

These are just some common questions that need answering in order to allocate the amount of development time required for forms.

The four types are:

• Data Entry Form - Forms which give users an easy to use interface to add, modify and delete records.


• Screen Enquiries (Read Only) - Forms that allow users to view as read only screens restricting functionality and filtering for certain records only.


• Dialog Box - Forms which act as a communication portal between users and the system passing data and values to interact with Access.


• Menu Screen (Switchboard) - Forms which allow users to navigate around the database system without ever knowing or having access to the background design. There is a section that follows for the newer Access 2010 Navigation Forms.

Each link above will focus on the specifics and the design process step by step to help developers produce good looking forms.

If you want a more generic understanding of a Form's canvas and their controls and properties, you may want to view how to design an Access Form from scratch.

Forms can also have nested forms known as Access sub-forms which is a form inside another and will usually be related by a common join. The process can be via the wizard control or by setting its properties between the main and sub forms.

By learning to set up the relational database in Access, the wizards normally handle the rest. The only added caveat is some design layouts will need manually updating - Access layouts for forms are pretty poor!

Note: You can download the database file of your version to test the examples explained and illustrated throughout this website.

Return from Access Forms to About Access Databases home page