Tables Bands Tables Venues Tables Lighting Tables Sound

  • Slides: 14
Download presentation
Tables - Bands

Tables - Bands

Tables - Venues

Tables - Venues

Tables - Lighting

Tables - Lighting

Tables - Sound

Tables - Sound

Tables Bookings Lookup from table BANDS Lookup from table VENUES Lookup from table LIGHTING

Tables Bookings Lookup from table BANDS Lookup from table VENUES Lookup from table LIGHTING Lookup from table SOUND

Tables – Ticket Entry Lookup for Booking. Number SELECT [Bookings]. [Booking Number], [Bookings]. [Booking

Tables – Ticket Entry Lookup for Booking. Number SELECT [Bookings]. [Booking Number], [Bookings]. [Booking Date], [Bookings]. [Band], [Bookings]. [Venue] FROM Bookings; Use the lookup wizard to select the fields above and make sure you are not hiding the first column

Forms Create a basic form for each table and included a Add record button

Forms Create a basic form for each table and included a Add record button at the bottom of each as shown. Add Booking button created using the wizard and selecting RECORD OPERATION / ADD NEW RECORDS

Forms – Main menu form Buttons to open forms – Created using the wizard

Forms – Main menu form Buttons to open forms – Created using the wizard and FORM OPERATIONS Button to run a report “Balance Sheet” – Created in the wizard using REPORT OPERATIONS

Queries - Expenditure The following screenshots are all from the same query Tables used:

Queries - Expenditure The following screenshots are all from the same query Tables used:

Queries - Expenditure The following screenshots are all from the same query Query Part

Queries - Expenditure The following screenshots are all from the same query Query Part 1

Queries - Expenditure The following screenshots are all from the same query Query Part

Queries - Expenditure The following screenshots are all from the same query Query Part 2

Queries - Expenditure The following screenshots are all from the same query Query Part

Queries - Expenditure The following screenshots are all from the same query Query Part 3

Queries - Expenditure The following screenshots are all from the same query Query Part

Queries - Expenditure The following screenshots are all from the same query Query Part 4

Reports – Balance Sheet Use the report wizard to produce a basic outline then

Reports – Balance Sheet Use the report wizard to produce a basic outline then amend it as follows