Which criteria do not return the position "Officer" as a match in MS Access?
position = "*ff*"
position = "O??icer"
position = " ?ff*"
position = "O#r"
Correct answer is D
No explanation has been provided for this answer.
Which of the following is not a type of relationship that can be applied in Access database
One to One
One to Many
Many to Many
All of above can be applied
Correct answer is D
No explanation has been provided for this answer.
Cascade delete option in MS Access
is used to delete all the records of all tables in a database
will repeat the recent delete operation to all the records of current table
is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted
None of the above
Correct answer is C
No explanation has been provided for this answer.
(IF [Age]>65, "Senior","Adult"). In Ms Access, this expression is an example of:
A conditional expression
Algebraic expression
A financial expression
None of the above
Correct answer is A
No explanation has been provided for this answer.
In MS Access, how can you make a date field DOB store the dates like "2002/10/17" ?
By setting the input mask property to "yyyy/mm/dd"
By setting the format property to "yyyy/mm/dd"
By entering dates in yyyy, mm, dd order
None of the above
Correct answer is B
No explanation has been provided for this answer.