Docstoc

Microsoft Access Assignment _2

Document Sample
Microsoft Access Assignment _2 Powered By Docstoc
					                            Microsoft Access Assignment #2

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              NOTES
                                                              TYPE



  HIGH IN DRY                4                  500           ROCK &             weddings,
                                                              ROLL               balls,
                                                                                 dances
                                                                                 preferred



  SQUARE DANCE               3                  650           COUNTRY            prefers
  TRIO                                                        &                  C&W gigs
                                                              WESTERN            and
                                                                                 concerts
                                                                                 suitable for
                                                                                 weddings,



  BLUE SOX                   4                  400           JAZZ               jazz
  QUARTET                                                                        festivals,
                                                                                 dances.
                                                                                 Prefers
                                                                                 smaller
                                                                                 gigs.



  YOUNG AND                  5                  750           ROCK &             young
  PROUD                                                       ROLL               band, suits
                                                                                 concerts
                                                                                 and school
                                                                                 functions



  MATTHEW AND                3                  750           ROCK &             a young
SON                                                        ROLL               band,
                                                                              prefers gigs
                                                                              with a
                                                                              younger
                                                                              audience



CRUISING                   5                 500           JAZZ               suitable for
                                                                              older
                                                                              audiences,
                                                                              has a good
                                                                              repertoire
                                                                              of older
                                                                              dance
                                                                              numbers



NORTHERN                   4                 750           ROCK &             suits an
LIGHTS                                                     ROLL               older
                                                                              audience,
                                                                              plays older
                                                                              rock songs



COUNTRY                    5                 650           COUNTRY            a good all
CHARM                                                      &                  round band
                                                           WESTERN            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
            file indicate 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 the report above for only those bands which have five members.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:7
posted:11/19/2011
language:English
pages:3