•	The main outputs for this program are the two main queries/reports that I have created.  The two queries that were created were to find out how many people supported each house group.  Lastly to find out how many seats are still available in three sections, Front, Back and Middle of the theatre.  The way that the first query was done was via the totals function.  The column was calculated using the using group and count in the query.  Once this was completed and all values were displaying correctly I then created a report using the Report Wizard.  This displays both fields, House Group and then the count of the House Group to find out how many support each.  This was done so that it could be printed to provide a hard copy.  The second query was calculated again using totals but this time I used sum rather than count so that it will get the total amount of seats left in each section.  Once these were found I created a new column in the query so that I could then use the Expression Builder to take 200 away from this value as this is the total amount of seats that are available in this section.  This left me with the total amount of seats that were left.  Once I had this data I then created a second report and put all three fields in it, the Position, the Sum of the number of tickets available and then the value that had 200 taken away from this value.  Again, this was done so that I could create a printed hard copy to provide for evidence if needed.