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
- 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
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:
- Click the Form View button
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.
- Select the fields you want to give to Forms- Select Tables / Queries that you want to have on the Form
- Click Next .
- Click Next- Select the layout for the form
- Click Next- Select the type
- Choose where you want to open the Form or edit the Form.- design. Create a title for the Form
- Click Finish .
You should read it
May be interested
- How to create Macros in Word 2007macros are advanced features, which can speed up editing or formatting that you can execute regularly in a word document. they record the sequence of choices you choose so that a series of actions can be completed in one step.
- MS Access - Lesson 13: Creating Reports (report)reports (reports) are a way to view and analyze a large amount of data. you can use the report wizard or create an arbitrary report that you need.
- MS Word - Lesson 14: Create Web Pagessimple web pages can be created in word using the save as feature. in a web document, you can insert images and hyperlinks. to view documents as a website:
- MS Access - Lesson 14: Print the reportafter you create a report, you can print the report.
- MS Word - Lesson 15: Create an automatic numberautomatic sequence numbers allow you to format and organize text with numbers, bullets (round dots), or a border.
- MS Access 2003 - Chapter 10: Using additional toolsin management methods, access is more than just a simple database management. one of the biggest proofs is the use of additional tools that microsoft chooses with access.