1. Click on the Access button on the right and save the 'concerts' database to your area.

2. Open the database.

This database is used by a ticket booking agency to keep records of which bands are playing concerts at which venues.

3. There are three tables which have been linked together to form a relational database. Unfortunately, they have been linked together incorrectly.

• Delete the relationships which have been set up.
• Set up the relationships correctly.
• Enforce referential integrity.
• Ensure that all cascading records are updated.

4. Go to the 'venues table' and add two new records.

Yyou can make them up the details

5. Open the 'bands' form and add three new records using the form.

You can make up the details.

6. A field has been missed from the 'bookings' form.

Open the bookings form and add the field 'number of nights'