Mr Lowe's Lessons...
Mr Lowe's Lessons...
Theatre Topic - Bookings Database
Forms again - REMEMBER - Forms present the data in the database in a more user friendly way
That is one reason why we use them. We can use them to add or edit data in the database...
They can be linked to Tables OR Queries
Setting up a FORM that is linked to the
Customers Table
Here is a step by step guide
You have set up a form on a database before
so I will go through it quite quickly
Click the "Forms" button on the left hand side of the database objects window
Double click "Create Form by using wizard"
Select the customers table ( tblcustomers ) from the Tables / Queries drop down menu
Click the >> button to move all the fields that you want available on the form to the right hand side - Click Next
Next choose how you want your form to look - I suggest "Justified" - Click "Next"
Now choose a colour scheme that you want for your form - then Click "Next"
Name the form "frmcustomers" Then click finish
You should now have a form on the screen that shows the all the details of the first record in your customers table...
You can add yourself as a customer if you wish...
Now we are going to investigate
what a "switchboard" is and set one up...