Revision quiz on Access

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)

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)

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

_________________ 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.