WorksheetsFixing Relationships
Total questions: 8
Worksheet time: 5mins
What does the error message refer to?
that there is no primary key
that there is no foreign key
that there is no referential integrity
that the tables are open
How do you fix this error?
Set the primary key.
Enforce referential integrity
Close all the tables.
Fix the data type of the field.
What does this error message refer to?
that someone is using your account
that someone is using your database file
that Department table is open
that someone hacked into your system
Which of the following may be the reason(s) causing this error?
The common fields have different field name.
There may be a spelling error with the related record.
There may be an extra space with the related record.
The common fields have different data types.
You have linked the wrong fields.
How do you delete a relationship?
Right click on the table and select hide table.
Right click on the Relationship tab and select Close.
Double click on the Relationship and select Cancel.
Right click on the Relationship and select Delete.
How to you remove all the relationships created at once.
Click on Clear Layout.
Click on Edit Relationships.
Click on Close.
Select all the tables and press Delete.
There is no need to save the relationship because Access automatically save it for you.
True
False
Which one is more complicated? Interpersonal relationship or Relationship between tables?
