MS Access 2007 - Lesson 12: Design Forms

TipsMake.com - Forms allows you to control the interface of the data entry screen and the generated reports. In this article, we will show you how to create a Form and view the Form in Access 2007.

Form Views

There are 3 ways to view Forms in Access:

Design View Allows you to design forms including headers, footers and details in the form. You can also add images and controls that appear on the Form. Form View This is a dynamic page that allows users to enter and edit data or adjust data in a field. Layout View This view allows you to design the Form and manipulate data.

Create a form

You can create a Form from a table or a query. To create a Form:

- Click the Create tab

- Click the Form Design button

MS Access 2007 - Lesson 12: Design Forms Picture 1

- Click the Add Existing Fields button - Click the Format tab

- In the Field List box on the right, click and drag the fields you want onto the Form

MS Access 2007 - Lesson 12: Design Forms Picture 2

Edit the properties in the Property Sheet dialog box - To change the colors and fonts, click the Property Sheet button on the Arrange tab

- Select the section you want to edit

- Select the attribute you want to edit

- Click the Views button on the Home tab to preview the Form:

MS Access 2007 - Lesson 12: Design Forms Picture 3

- Click the Form View button

MS Access 2007 - Lesson 12: Design Forms Picture 4

You can create a Form with help from the Form Wizard.To use the Form Wizard:Form Wizard

- On the Create tab, click the down arrow to More Forms

- Click Form Wizard.

MS Access 2007 - Lesson 12: Design Forms Picture 5

- Select the fields you want to give to Forms- Select Tables / Queries that you want to have on the Form

- Click Next .

MS Access 2007 - Lesson 12: Design Forms Picture 6

- Click Next- Select the layout for the form

MS Access 2007 - Lesson 12: Design Forms Picture 7

- Click Next- Select the type

MS Access 2007 - Lesson 12: Design Forms Picture 8

- Choose where you want to open the Form or edit the Form.- design. Create a title for the Form

- Click Finish .

MS Access 2007 - Lesson 12: Design Forms Picture 9