Create An Actors Table

Submitted By amanveerkataria
Words: 2192
Pages: 9

Date | Task Description | Done? | | Part A: Create the Actor and Bookings Tables | | | Actor Table | | 12/9/11 | • Import the data from Actor.xls to create an Actor Table. | | | • Select an appropriate key field for the Actor Table, ensuring this will be a unique value. | | | Bookings Table | | | • Import the data from Bookings.xls to create a Bookings Table. | | | • Select an appropriate key field for the Bookings Table, ensuring it will be a unique value | | | • Select an appropriate name for field number 4 in this table. (Field number 4 indicates the date for a booking to finish.) | | | Create 2 validation rules/checks | | | | [4] | | | | Part B: Create a link between the Actor Table and the Bookings Table. | | | Create a simple logo which could be used by Actors Associates on all their documents. | | | Week 2 (12th September 2011) | [2] | | | | Part C: | | 19/9/11 | Design 2 data capture forms (1 for the Actor Table and 1 for the Bookings table) for Actors Associates to use when recording data about clients and bookings. The data capture forms will be completed by a member of staff. | | | You should include your logo on each form. | | | Week 3 (19th September 2011) | [3] |

| Part D: | | 26/9/11 | One actor has moved to London as she was successful in an audition for a part in a play in a theatre in The West End. Her details are shown below. Remove her record from the database. | | | [1] |

| Part E: | | 19/9/11 | Two new performers have signed up with Actors Associates. Their details need to be entered into the database. | | | New Performer Number 1 | | | Sarah Mintoff is a female singer who performs in musicals only. She performs under her real name and lives at 17 Leverogue Road, Belfast, BT8 3BH. Her telephone number is 90581249. She charges £90 per performance. She drives her own car. Assign her Actor ID number 19. | | | New Performer Number 2 | | | A comic actor called Alan Valance lives at 23 Crumlin Gardens in Belfast, postcode BT13 5FD. His real name is James Smith and he does not have his own transport. Alan only gives evening performances. His telephone number is 90581631. He charges £150 per evening performance. Assign him Actor ID number 20. | | | New Booking | | | Alan Valance has received a booking already. He is to appear at the Empire Theatre and the play starts on 25th May 2010 for 7 nights only. The booking was taken on 15th April 2010. Terry from Acting Associates has decided to record the booking under Booking ID number 27. | | | | [3] | | Part F: | | | The company needs an alphabetic list of all actors on their books in order to circulate all theatres in Ireland. Create a customised report which contains information from the Actor Table which is sorted by both Actor Surname and Actor Firstname. Make sure all fields are included and all data is visible. Name this report ACTORLIST. | | | Week 4 (26th September 2011) | [2] |

| Part G: | | 3/10/11 | A drama producer is attempting to put on a show. He knows a comedy will attract a large audience and has asked Terry to produce a list of comedy actors. Create a query which will search for the comedy actors’ surnames, firstnames and contact numbers. Name this query COMEDY. | | | | [2] | | | Part H: | | | The company is often asked for actors with their own transport if a play is to be “taken on the road”. In order to prepare for future enquiries Terry has decided to create a query looking for all comedy actors who have their own transport. Create this query for him and ensure only the fields showing the actors’ name and full contact details are included. Name this query CARCOMEDY. | | | Week 5 (3rd October 2011) | [3] | | Part I: | | 10/10/11 | The Council for Dramatic Arts is to hold a gala evening for awards to local actors. As a trial run Terry wants to produce