The orgency for manager of the Noiseworks Music Agency.

Your new job is assistant to the manager of the Noiseworks Music Agency. The agency books bands for various functions and the manager has asked you to maintain the list of bands for which the company handles bookings. This is a sample of the information to be kept:
BAND NAME MEMBERS PRICE MUSIC TYPE NOTES
HIGH IN DRY 4 500 ROCK & ROLL weddings, balls, dances preferred
SQUARE DANCE TRIO 3 650 COUNTRY & WESTERN prefers C&W gigs and concerts suitable for weddings,
BLUE SOX QUARTET 4 400 JAZZ jazz festivals, dances. Prefers smaller gigs.
YOUNG AND PROUD 5 750 ROCK & ROLL young band, suits concerts and school functions
MATTHEW AND SON 3 750 ROCK & ROLL a young band, prefers gigs with a younger audience
CRUISING 5 500 JAZZ suitable for older audiences, has a good repertoire of older dance numbers
NORTHERN LIGHTS 4 750 ROCK & ROLL suits an older audience, plays older rock songs
COUNTRY CHARM 5 650 COUNTRY & WESTERN a good all round band with a preference for C&W

1. Create a database file called Bands and a table called NOISEWRKS within the file, to contain the information above.
2. Enter the data for the bands.
3. Add one more band to your file:
   o Flying Colours, 5 members costing $800. The band plays jazz and the notes in the fileindicate that the band is suitable for dances and mature audiences.
4. Make these changes to the data in your file:
   o Blue Sox Quartet has increased its price to $550.
   o Cruising has increased its price to $700.
5. Matthew and Son has split up.Remove details of this band from the file.
6. List only the band names and the notes. Save the Query
7. List all the bands that play jazz. Save the Query
8. List all the Rock & Roll bands that cost less than $700. Save the Query.
9. List all the band names and the price for bands which play Country & Western. Save the Query.
10. List all the bands which play either Rock & Roll or jazz. Save the Query.
11. How many bands cost more than $650? Save the query
12. What is the average number of members in the jazz bands? Save the Query.
13. Create and print a report for your file. Include in your report the band name, the price and the notes kept on each band, grouped by music type. Add your name, the assignment number, question number and date to the bottom right corner of the report. Format the report professionally on the page.
14. Print (save as pdf, no need to print on paper) the report above for only those bands which have five members.

Sample Solution