Creating Forms

Creating Forms

 

 

What is Form in MS- Access?

 

Forms are like display cases in stores that make it easier to view or get the items that you want. Since forms are objects through which you or other users can add, edit, or display the data stored in your Access database, the design of your form is an important aspect. If you database is going to be used by multiple users, well-designed forms is essential for efficiency and data entry accuracy.

There are several ways of creating a form in an Access desktop database and this article points you to some of the common ways.

 

 



 

Create a form from an existing table or query

- Create a blank form

1. To create a form with no controls or preformatted elements: On the Create tab, click Blank Form. Access opens a blank form in Layout view, and displays the Field List pane.
2. In the Field List pane, click the plus sign (+) next to the table or tables that contain the fields that you want to see on the form.
3. To add a field to the form, double-click it or drag it onto the form. To add several fields at once, hold down CTRL and click several fields, and then drag them onto the form at the same time.

NOTE    The order of the tables in the Field List pane can change, depending on which part of the form is currently selected. If you are not able to add a field to the form, try selecting a different part of the form and then try adding the field again.

1. Use the tools in the Controls group on the Form Layout Tools tab to add a logo, title, page numbers, or the date and time to the form.
2. If you want to add a wider variety of controls to the form, click Design and use the tools in the Controls group.  

 

-Create a form that displays multiple records

A multiple item form, also known as a continuous form, and is useful if you want a form that displays multiple records but is more customizable than a datasheet, you can use the Multiple Items tool.

1. In the Navigation Pane, click the table or query that contains the data you want to see on your form.
2. On the Create tab and click More Forms > Multiple Items.

Access creates the form and displays it in Layout view. In Layout view, you can make design changes to the form while it is displaying data. For example, you can adjust the size of the text boxes to fit the data.

 

-Create a Navigation form

A navigation form is simply a form that contains a Navigation Control. Navigation forms are a great addition to any database, but creating a navigation form is particularly important if you plan to publish a database to the Web, because the Access Navigation Pane does not display in a browser.

1. Open the database to which you want to add a navigation form.
2. On the Create tab, in the Forms group, click Navigation, and then select the style of navigation form that you want.

Access creates the form, adds the Navigation Control to it, and displays the form in Layout view.