Creating your Movie database

Once you're happy with your groups design, open up Access, create a new database called YahooMovies and have a go at:

1. Designing the required tables (fields, types, primary keys)
2. Setting the relationships for your tables (remember: Enforce referential integrity!)
3. Add some test data for your primary tables, then for your other tables.
4. Create some basic forms for your primary tables, then your other tables (you may need subforms)
5. Convert any appropriate fields into Combo boxes so that, even though your form stores the an ID in the table, it displays user-friendly information in the combo box.
6. Create a query that displays all the Cinemas that each movie is screening in.