In MS Access, which of the following is not a valid field property?
A. Field Size
B. Sort Order
C. Caption
D. Format
Answer: Option B
Solution (By JKSSB Mock Tests)
Field properties include Field Size, Format, Caption, Default Value, etc. Sort Order is not a field property; sorting is applied in queries or tables via the Sort row.
Which property under an MS Access query design matrix allows database administrators to filter records to show only those matching a specific range, such as values between 100 and 500?
Explanation:
The Criteria row in the Query Design grid is where you input logical expressions (such as 'Between 100 And 500') to filter the records extracted from the database.
No comments yet. Be the first to start the discussion!