Vidyalelo
Computer Fundamentals · all questions

MS Access
practice.

Practice every MCQ with options. Use Show answers when you want the correct option and solution.

514

Questions

20/26

Page

Pick an option on a question to see the right answer and solution.

The quickest way to add a field to the selected fields list is to double-click its field name in this list.

Select an option to see the answer and solution.

What is the difference between 'Open' and 'Open Exclusively'?

Select an option to see the answer and solution.

in MS Access, OLE Object Data type can store

Select an option to see the answer and solution.

A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?

Select an option to see the answer and solution.

A relationship is created between how many tables?

Select an option to see the answer and solution.

A form defines

Select an option to see the answer and solution.

Which of the following statements about criteria in a query is NOT true?

Select an option to see the answer and solution.

Which of the following field properties is an expression that specifies criteria or requirements for entering data?

Select an option to see the answer and solution.

Referential integrity cannot be set for _______________ relationships.

Select an option to see the answer and solution.

When you add fields in ________, a Field List pane displays.

Select an option to see the answer and solution.

To display value from table for a label control

Select an option to see the answer and solution.

In a junction table, the _________ field consists of the foreign key from both the linked tables.

Select an option to see the answer and solution.

In a datasheet, what does each column represent?

Select an option to see the answer and solution.

You can move between fields in a form by using any of these keys except

Select an option to see the answer and solution.

What do you call a collection of records matching parameters of a query?

Select an option to see the answer and solution.

Which data type is better to use for storing the price of an item?

Select an option to see the answer and solution.

In Access press CTRL+W or CTRL+F4 to

Select an option to see the answer and solution.

A query prompts a user for a data and then displays only records that contain the specified date. The type of of query is this

Select an option to see the answer and solution.

A report module includes code for all event _______ triggered by events occurring on a specific report or its controls.

Select an option to see the answer and solution.

What are the columns in a Microsoft Access table called?

Select an option to see the answer and solution.