forms in access 2007

download the database

If you wish, you can now download the basic framework of the database to play with.

There are still several forms to be created but the tables are all there and it might be useful to compare this version with the one you've built-up this far.

The file is in .zip format and you have to extract it before you use it.

As far as I know, the file is absolutely clean, checked by Trend Micro PC-cillin.

Download MikeGarage database.

creating a maintenance form

To create a form in Access 2007 you simply go to the Create tab, select the table and hit the Form button.
A simple Maintenance Form (to add, change, delete and locate data) is built automatically with Subforms for related data.
Anything you want to change can be done through the Design View button.

Once you've got data in the Customers table, use the form Search box to locate any customer by name, address, phone, etc.

To change the order of the fields on the form you simply move them about in Design View.
However, when you do that they probably won't be in the right order when you tab through them. You have to change the Tab order with a right-click on the form.

the vehicles form

This one is a bit different because the relationship shown is that of the child of the Invoice.
To get the customer information to appear on the form we have to add it manually in Design View.