Access Challenge 1

We've run out of VBA challenges, so it's time to move on to our Access Challenges! Here's the first installment...

Few weeks ago, we worked through some exercises to create Forms with Subforms. After chatting last week, a few people are still a bit hazy about the details of creating forms with subforms. This challenge will give us an opportunity to practise using subforms.

So far, our Yahoo! Movie database allows us to enter a new screening of a movie at a certain cinema complex. We've created a nice form with dropdowns to help us select the Cinema complex and the movie, but it would be a bit of a pain to use if we had to add a whole list of screenings of a certain movie, or on the other hand, a whole list of movies for a certain Cinema complex! That's where subforms come in handy!

Your challenge is to open up your Yahoo! Movies database and:

• Create a form that allows you to add multiple new screenings for a certain movie.
• Create a second form that allows you to add multiple movie screenings for a certain Cinema Complex

Both of these forms will require a subform - and the easiest way to do that is to choose the right fields for your form - and the easiest way to do that is to plan your form on paper first! If you want to practise and revise first, see if you can find a tutorial on Subforms on Microsoft's Roadmap to Access 2003 training. Good luck!