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

9/26

Page

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

When entering field name, how many characters you can type in maximum?

Select an option to see the answer and solution.

In a table to insert User's Voice, Data field should be

Select an option to see the answer and solution.

In Access press to Complete the wizard

Select an option to see the answer and solution.

Which do you click to display the table's primary key and indexes in a separate window?

Select an option to see the answer and solution.

Any report, including a basic report, can be modified in _________.

Select an option to see the answer and solution.

The Search tool is best used when searching for ______ data.

Select an option to see the answer and solution.

Which of the following is not a database object in MS Access?

Select an option to see the answer and solution.

This type of database contains multiple tables that are connected to produce combined output from all tables.

Select an option to see the answer and solution.

Which of the following is not a database application?

Select an option to see the answer and solution.

Which is not a command that is selectable from right click menu of a field column?

Select an option to see the answer and solution.

A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

Select an option to see the answer and solution.

__________ is used to build 'intuitive' queries.

Select an option to see the answer and solution.

What is the type of query that extracts data from a table and puts them into separate table?

Select an option to see the answer and solution.

Which of the following data types automatically generates a consecutive number?

Select an option to see the answer and solution.

Which of the following is invalid field name?

Select an option to see the answer and solution.

Press the following keys in Access to Cancel Print Preview or Layout Preview

Select an option to see the answer and solution.

The filter by selection feature allows you to filter:

Select an option to see the answer and solution.

The default and maximum size of text field in Access

Select an option to see the answer and solution.

Which of the following methods CANNOT be used to delete records from a table?

Select an option to see the answer and solution.

How can you display the related records from other tables in datasheet view?

Select an option to see the answer and solution.