Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Tables - Bands PowerPoint Presentation
Download Presentation
Tables - Bands

Tables - Bands

97 Vues Download Presentation
Télécharger la présentation

Tables - Bands

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Tables - Bands

  2. Tables - Venues

  3. Tables - Lighting

  4. Tables - Sound

  5. Tables - Bookings Lookup from table BANDS Lookup from table VENUES Lookup from table LIGHTING Lookup from table SOUND

  6. Tables – Ticket Entry Lookup for BookingNumber 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

  7. 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

  8. Forms – Main 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

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

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

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

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

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

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