RelationalDBDesign
SiteMap
Data Manipulation
Access Features
Building Database
Tables Queries
Business Rules
Cursors Views
Database Creation
SQL Monitoring
Database Relationships
«Prev
Next»
Access Features
Define Database Relationships
Different-types-accessRelationships
One-to-One one-to-Many
Many-to-many Relationship
Referential Integrity Access
Cascade Update Delete
Referential Integrity
Working With Web
Using hyperlinks Forms
Data Access Pages
Data Access Types
Create Grouping Style Page
Working With Web Conclusion
Access Tools
Microsoft Access Security
Working With Startup Dialog
Access Add In
Encrypting, Decrypting Database
Understanding Access Replication
Replicating Access Databases
Convert Microsoft Access
Access Tools Conclusion
Using Access Macros
Access Macros
Create Access Macro
Assign Macro
Running Queries Macros
Available Access Macros
Macros Conclusion
Cascade Update Delete Options - Quiz
1.
When the Referential Integrity check box is checked in the one-to-many relationship between Clients and Projects, without having Cascade Delete and Cascade Update set to True, you then: (Please select all that apply.)
Please select all the correct answers.
A.
Cannot add records in the Projects table without assigning an existing client from the Clients table
B.
Delete clients that have existing projects
C.
Change the ClientNo field in the Clients table
D.
Delete projects in the Projects table
2.
Checking the Cascade Update option in a relationship allows you to:
Please select the best answer.
A.
Add entries on the sides that use a primary key
B.
Update primary fields in a relationship and have them cascade down the relationships
C.
Delete related records and have them cascade down the relationship
3.
Checking the Cascade Delete option lets you:
Please select the best answer.
A.
Delete field entries from the one side of a one-to-many relationship
B.
Delete records on the many side of a one-to-many relationship.
C.
Delete records on the one side of a one-to-many relationship.
D.
Update primary key fields on the one side of a one-to-many relationship.