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
- When creating a database in Microsoft access
- Foreign keys must be specified for each table.
- In access it is impossible to create a table without designing a primary key.
- All data and three problems resulting error messages.
- 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.
- 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
