MS Access 2007 - Lesson 12: Design Forms

Forms allow 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.

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

Picture 1 of MS Access 2007 - Lesson 12: Design Forms

- 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

Picture 2 of MS Access 2007 - Lesson 12: Design Forms

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:

Picture 3 of MS Access 2007 - Lesson 12: Design Forms

- Click the Form View button

Picture 4 of MS Access 2007 - Lesson 12: Design Forms

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.

Picture 5 of MS Access 2007 - Lesson 12: Design Forms

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

- Click Next .

Picture 6 of MS Access 2007 - Lesson 12: Design Forms

- Click Next- Select the layout for the form

Picture 7 of MS Access 2007 - Lesson 12: Design Forms

- Click Next- Select the type

Picture 8 of MS Access 2007 - Lesson 12: Design Forms

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

- Click Finish .

Picture 9 of MS Access 2007 - Lesson 12: Design Forms

Update 25 May 2019
Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile