Free Access 2003 quiz - Test Your Skills!

Creating main and subforms for a one to many relationship

The aim of this quiz is to check your knowledge of Creating main and subforms for a one to many relationship in Access 2003.

Please ensure that you read all questions carefully and spell all answers correctly! Once you have completed the quiz, please click the 'score my answers!' button to find out how you did.

If you like this quiz, there are plenty more where it came from! You can see the full list of subjects here.

You can learn more about our classroom, online and soft skills courses at our Happy websites.

Questions

  1. Look at the main and subform below. Where would you click to see the record of the next organisation in the table? Click on the correct position on the picture below.

  2. You're about to create a main and subform for a one to many relationship. Which table will the main form be based on?

  3. Where would you click to quickly transfer all the fields of this table into the Selected fields area?

  4. You want to make sure you create a form with a subform on the same page. Where would you click on the picture below, before clicking Next?

  5. You're about to finish creating your main and subform based on the two tables listed below. First you have to give each one a name. What would be the most sensible name for the main form? Click in the circle next to the correct answer below.

    Screen shot for question 5

Top