Question: please answer with a full explanation When creating a database in Microsoft access Foreign keys must be specified for each table. In access it is

please answer with a full explanation

  1. When creating a database in Microsoft access
  1. Foreign keys must be specified for each table.
  2. In access it is impossible to create a table without designing a primary key.
  3. All data and three problems resulting error messages.
  4. Referential integrity is only enforced for those relationships for which the database design or user places a check mark in a box for enforce referential integrity during or after creation of the relationship in the relationship layout.
  5. To delete a relationship, simply deleting one of the tables involved in the relationship will do the trick.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!