Theatre Project - Set up a Bookings Database

Mr Lowe's Lessons...

Theatre Topic - Bookings Database - SET UP A "BOOKING FORM"

Now you have to set up a booking form linked to the booking query

This will make it easier to enter bookings on your database

STEP BY STEP GUIDE

Click on the "Forms" tab
Double click "Create form by using wizard"
Select the "qrybookings" from the drop down menu

Your screen should now look like this...

Then click the >> button to move all the fields in to the right hand window
Click "Next"
On the next window select "by tblcustomers" and click the "Linked forms" option

Your screen should now look like this...

Then click "Next"

Then choose a colour scheme in the next window and click "Next" again

You should now have a window like the one below appear

Enter the form and Subform names as shown above then click Finish

You should now get a form on the screen that shows a customer details form
with a button on it that links it to their bookings when you click it.
See the picture below.

The forms can be put in to "Design View" and the fields and headings
can be moved around so that the form looks better

You can now add some customers on to your database...

BACK TO MAIN PAGE