| A form is a database object that can be used to write, to modify or to show the data of a table or queries. The forms can be used to control the access to the data, as what fields or rows of data are going to be showed. |
| Consider the forms like windows by which the users see and reach the data bases. An effective form accelerates the database¡¯s uses, since the users do not have to look for what they need. |
| Create a form |
| You can use the tool Form to create a form with a single click. When you uses this tool, all the fields of the underlying data source are placed in the form. You can begin to use the new form immediately, or, can modify it in the View Presentation or Design to fit it with your needs. |
| 1) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form. |
  |
| Illustration 1: Select the Files tables. |
| 2) In the create tab, in the group Forms, clicks in Form. |
 |
| Illustration 2: Select the Form command. |
| 3) Access creates the form and shows it in the Presentation View. Inside this view, changes of form¡¯s design can be made while it shows data. |
 |
| Illustration 3: Form in presentation view. Click here to view larger image. |
| 4) If Access finds a single table that has a relation to one or several tables or queries, will add a data sheet to the form based on the table or consults related. |
 |
| Illustration 4: Form based on a table with related tables. Click here to view larger image. |
| A split form is a new characteristic of Microsoft Office Access 2007 that allows obtaining two views of data simultaneously: a Form View and a Data sheet View. |
| The two views are connected to the same data source and are synchronous among them. |
| 5) In order to create a split form, use the tool Split Form. |
| 6) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form. |
 |
| Illustration 5: Create a split form based on a query. |
| 7) In the Create, in the group Forms, clicks in Split Form. |
 |
| Illustration 6: Create a split form based on a query. Click here to view larger image. |
| 8) Access creates the form and shows it in the Presentation View. Inside this View, changes in form¡¯s design can be made while it shows data. |
| Create a form that shows several records |
| If it is desired to have a form that shows several registries instead a data sheet, you can use the tool Multiple Item¡¯s Forms. |
 |
| Illustration 7: Multiple items forms. |
| 9) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form. |
| 10) In the Create, in the group Forms, clicks in Multiple Items. |
 |
| Illustration 8: Multiple items forms. Click here to view larger image. |
| Create a form with the wizard |
| In order to select with better criteria the fields that are going to appear in a form, you can use the Wizard for forms instead of the diverse tools of form creation previously mentioned. |
| 11) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form. |
| 12) In the Create, in the group Forms, clicks in More Forms. |
 |
| Illustration 9: More Form options. Click here to view larger image. |
| 13) Select the Form Wizard command. |
| 14) Select the Query or table and fields to use in the form creation. Press the NEXT button. |
 |
| Illustration 10: Query / table and fields selection. |
| 15) Select the form layout. Press the NEXT button. |
 |
| Illustration 11: Form Layout. |
| 16) Select the form style. Press the NEXT button. |
 |
| Illustration 12: Form Style. |
| 17) Select the form Title. Live activated the Open the form to view or enter information option. Press the FINISH button. |
 |
| Illustration 13: Form Title. |
| 18) Finished form would be as shown below. |
 |
| Illustration 14: Finished Form. Click here to view larger image. |
| Create a form from blank template |
| You can use the tool Form to create a blank form and customize it to feet your needs. |
| 19) In the exploration panel, clicks in the table or query that contains the data that wish to see in the form. |
| 20) In the Create, in the group Forms, clicks in Blank Forms. |
 |
| Illustration 15: Blank Form command. |
| 21) Access opens a form in Presentation view and shows the List of Fields. |
 |
| Illustration 16: Field List panel. |
| 22) Drag a field from the List of Fields to the Design area. |
 |
| Illustration 17: Drag the desired fields. Click here to view larger image. |
 |
| Illustration 18: Fields manipulation. Click here to view larger image. |
| 23) With the tools of the group Controls in the Format tab, you can add images, logos, title, numbers of pages or the date and the hour to the form. |
 |
| Illustration 19: Additional form Controls. |
| 24) Add a Title to the form. |
 |
| Illustration 20: Additional form Controls. |
| 24) Add the date to the form. |
 |
| Illustration 21: Additional form Controls. Click here to view larger image. |
discuss this topic to forum
