Mr Lowe's Lessons...
Mr Lowe's Lessons...
Theatre Topic - Bookings Database
A QUERY CAN SEARCH AND SORT DATA ON A DATABASE
SEARCHING AND SORTING DATA CAN BE REFERRED TO AS "PROCESSING" DATA
Setting up a query that searches for unsold
tickets
Here is a step by step guide
Having a query that searches the tickets table to show any
unsold tickets is really useful
If a customer asked "which tickets are available"
you could search for that information quickly
Make Sure that you have all the ticket information
on the Tickets Table before you do this part.
You have to click on the Queries button in the Database Objects window
Double click "Create query by using wizard"
Select the tickets table ( tbltickets ) from the Tables / Queries drop down menu
Click the >> button to move all the fields that you want on the query to the right hand side - Click Next
Name the query "qryavailabletickets" THEN choose "Modify the query design" radio button and click finish
This puts the query in to DESIGN VIEW
In the "Criteria" row under the "Sold" field write the word "No"
Next type [enter Circle, Stalls or Side Stalls Left or Right] in the "Criteria" row under the "Seat Position" field. NOTE THE SQUARE BRACKETS
Click the save icon and close the query
Double click the query - You should get a window come on the screen - type in "Stalls"
The Query will show you a list of all the available seats for sale (None are sold so the list should be complete)
Close the query. Go the the Tickets Table and put a tick in the sold column of the first three tickets.
Then close the table and try the query again. WHAT
DO YOU THINK WILL HAPPEN ???
IF YOU HAVE GOT THIS FAR YOU ARE DOING FABULOUS
:-)