Microsoft Access Developer Question:
Download Questions PDF

Tell me why don't my table relationships show as '1' and '∞'? All I have is the line?

Answer:

You have probably not chosen to have referential integrity checked when you created the relationship. Delete the relationship (click on the line then choose delete) and try again, this time choosing to have referential integrity checked.

Referential integrity is important. For example, in the Chelmer Leisure database, for the 1:m relationship between the Category and the Membership Tables, referential integrity will ensure that all member records have a membership type that is already listed in the Category table.

Download Microsoft Access Developer Interview Questions And Answers PDF

Previous QuestionNext Question
Tell me when I assigned a primary key to my table in Microsoft Access, I was expecting my data to be sorted. Am I using the correct procedure?Tell me how do I convert an Access database to/from another version?