MS Access MCQ with Answers

Is used to delete all the records of all tables in a database

Will repeat the recent delete operation to all the records of current table

Is available in edit relatiionship dialog box which makes sure that all the related records will be deleted automatically whn the record from parent table is deleted

None of above

Means do not change the value in the primary key field if that record has related records in another table

Means change all the related records in child tables if the record in parent table is changed

Means do not change the value in the primary key field if that record has related records in another table and Means change all the related records in child tables if the record in parent table is changed

None of above

From edit menu choose delete relationship

Select the relationship line and press delete

Choose delete option from relationship menu

All of above

Right click the relationship line and choose edit relationship

Double click the relationship line

Right click the relationship line and choose edit relationship and Double click the relationship line

None of above

Or conditions

And conditions

Not condition

None of above