Microsoft Access 2007 Forms

in Form

Microsoft Access 2007 forms are used for entering data to your database. You could enter data directly into a table, but a form will give you a better interface to work with. Creating Microsoft Access 2007 forms is now easier than ever. Generally when creating an Access form, one tends to either use the wizard or go into design view and manually create it. In Microsoft Access 2007 you can still do this, but now there are a few other options worth considering.

First go to the navigation pane and select the table to be used for the form. Go up to the Ribbon and select the create tab. Now go along to the forms section on the Ribbon and click the button that says 'Form'. Microsoft Access will then go ahead and create a very quick simple form for you. You could then go into design view if you wished to customize it further. You also have the option of something called layout view which allows you to make alterations to the form while seeing the data in it at the same time. To switch views click the 'View' button under the Office button at the top left of the screen.

Other types of form you can also create are a multiple items form. This form shows many records in a datasheet format. To create this type of form first make sure you click on the table you require in the navigation pane. Then make sure you are on the create tab and go along to the forms section. Click the multiple items form button.

Microsoft Access 2007 forms also allow creation of what is known as a split form. This type of form will show a datasheet of records in the lower section of the form and a single record in the upper section. By selecting a record in the datasheet you can enter it's data in the single record in the upper section of the form. To create this type of form first make sure you click on the table you require in the navigation pane. Then make sure you are on the create tab and go along to the forms section. Click the split form button.

Main forms, sub forms, split and multiple record forms are all examples of the power of the new Microsoft Access 2007 forms.

Author Box
Paul Roger Barnett has 1 articles online

The #1 solution for total MS Access mastery
http://access-databases.com/ms-access-tutorial/

Add New Comment

Microsoft Access 2007 Forms

Log in or Create Account to post a comment.
     
*
*
Security Code: Captcha Image Change Image
This article was published on 2010/03/31