What is the primary function of the built-in field property 'Validation Text' in an MS Access table designer screen?
A. It specifies the custom error message displayed to users when data violates a Validation Rule.
B. It functions as a placeholder pattern to guide manual typists.
C. It sets the default value displayed inside the datasheet cell field.
D. It defines the calculation rule used to verify alphanumeric formats.
Answer: Option A
Solution (By JKSSB Mock Tests)
Validation Text contains the custom error message that alerts users when an invalid entry violates the data constraints specified in the Validation Rule property.
In MS Access, what type of table relationship layout is formed when a single record in Table A matches multiple records in Table B, but a record in Table B matches only one record in Table A?
Explanation:
A One-to-Many relationship is the most common relationship type in relational databases, where a primary key record in one table links to multiple foreign key records in another table.
No comments yet. Be the first to start the discussion!