Microsoft Access 2007 Forms

Microsoft Access 2007 Forms

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. This is also true in newer versions such as Access 2010. Generally when creating an Access screen, one tends to either use the wizard or go into design view and manually create it. In Microsoft Access 2007 and 2010 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’. MS 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 screen 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.

MS 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, sub, split and multiple record are all examples of the power of the new Microsoft Access 2007 forms.