Which view in MS Access allows you to view data in a spreadsheet-like format?
A. Layout View
B. Design View
C. Form View
D. Datasheet View
Answer: Option D
Solution (By JKSSB Mock Tests)
Datasheet View displays data in rows and columns, similar to a spreadsheet. Design View is for structure, Form View for forms, Layout View for form/report layout.
In MS Access, which relationship layout constraint ensures that records cannot be deleted from a parent table if matching child records exist in a linked table?
Explanation:
Enforcing Referential Integrity ensures that relationships between tables stay consistent, preventing orphan records by blocking deletions in a parent table when linked child rows exist.
No comments yet. Be the first to start the discussion!