Free Access 2003 quiz - Test Your Skills!

Editing relationships

The aim of this quiz is to check your knowledge of Editing relationships in Access 2003.

We've detected that you don't have Javascript enabled in your browser - you can still try the Quiz, but clickable 'image map' questions won't work. Please enable Javascript and refresh this page. If you can't, you can follow this link for a version which converts image questions to multiple-choice. You may also prefer to use the multiple-choice version if you use screen reading software, like JAWS, to browse.

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

You're using a database with a one to many relationship, with referential integrity enforced and cascade delete switched off . What would happen if you tried to delete a record in the one table? Click next to the correct option below.

Please select an answer...
- You would delete the record from the one table, thereby deleting related records in the many table as well
- You would delete the record from the one table but the related records in the many table would remain
- Access wouldn't let you delete the record
- Access would ask you if you were sure you wanted to delete the record
Where would you double click to start editing the relationship below? Click on the correct position on the picture below.

Please select an answer...
Where would you click to turn on cascade delete? Click on the correct position on the picture below.

Please select an answer...
What would you do to delete the relationship below? Click next to the correct option below.

Please select an answer...
- Right click on the line, then click Delete
- Double click the line, then select Cascade Delete
- Double click the line, then click Cancel
- Select both tables, then press Delete

Top