Font size
WorksheetsRevision quiz on Access
Total questions: 12
Worksheet time: 8mins
The view of the table that can be used to specify the data types and properties of the fields in a table. (Just write view name)
(a)
What is the most suitable data type for the Permanent field in the given table?
Short Text
Yes/No
Long Text
Date/Time
The property that allows you to specify an error message that gets displayed when the given criteria specified in Validation Rule is violated. (Enter in lowercase)
(a)
Which of the following statement will help you set the criteria in the Query Design Grid to retrieve the names of those books whose name starts with letter 'M'?
="M*"
=LIKE "M"
LIKE "M*"
="M#"
In a Query Design Grid, which of the following options will you choose to
display the records in ascending or descending order?
Criteria
Sort
Show
Or
(a) provides a convenient user interface to view, modify and
enter data in a database table.
We can give multiple criteria to filter out records from the
database tables using queries.
TRUE
FALSE
Mary, Sarah, Siddharth
Mary, Siddharth
Mary, Sarah
Sarah, Siddharth
We can choose to display and hide the fields in the Query Result window by selecting the _________ option.
Sort
Criteria
Or
Show
Srishti wants to add details of a new employee who has just joined the organization. State whether she will be adding a new record or a new field.
(a)
The ____________property helps us set the maximum number of characters that can be entered in a text-based field.
Validation Rule
Default Value
Format
Field Size
The criteria "KA???" will retrieve which of the following books if used under the Book_name field of the Books table in the Query Design Grid?
KAORT
KATYREWQS
KOPER
KSTYRE
