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

25/26

Page

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

Which major database object stores all data?

Select an option to see the answer and solution.

A __________ enables you to view data from a table based on a specific criterion

Select an option to see the answer and solution.

the executive responsible for the data processing function in an organization is

Select an option to see the answer and solution.

Referential integrity means

Select an option to see the answer and solution.

A database object in MS Access that stores a question about the data in database?

Select an option to see the answer and solution.

Which is NOT a method of creating a table?

Select an option to see the answer and solution.

A small button with three dots usually displayed at the right of field properties box

Select an option to see the answer and solution.

In Access to Open a combo box

Select an option to see the answer and solution.

Primary key is

Select an option to see the answer and solution.

Which of the following store command to retrieve data from database?

Select an option to see the answer and solution.

An application that executes on separate PCs like this is called a(n) __________ application.

Select an option to see the answer and solution.

To enter the input mask wizard

Select an option to see the answer and solution.

Which is the valid data type in Access?

Select an option to see the answer and solution.

How many relations may exist between tables in databases?

Select an option to see the answer and solution.

It is a database object to view, change, and analyze data in different ways

Select an option to see the answer and solution.

Which of the following is the default join between two recordsets?

Select an option to see the answer and solution.

It is a sign or symbol that specifies, operator, and values that produce a result

Select an option to see the answer and solution.

The report footer section is most useful for displaying:

Select an option to see the answer and solution.

Which part of the IIF expression is the action performed if the true condition exists?

Select an option to see the answer and solution.

how do you update pivot table report data after changes are made to the source data?

Select an option to see the answer and solution.