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

21/26

Page

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

What are the different views to display a table

Select an option to see the answer and solution.

Validation Rule in a field will

Select an option to see the answer and solution.

which of the following terms does not describe a database structure used by a dbms to link data from several files?

Select an option to see the answer and solution.

What is the purpose of indexing?

Select an option to see the answer and solution.

data items groped together for storage purposes are called a

Select an option to see the answer and solution.

It is an association established between common fields of two tables.

Select an option to see the answer and solution.

In a query, which row do you need to place wildcards to affect a parameter?

Select an option to see the answer and solution.

To create a new table, in which method you don't need to specify the field type and size?

Select an option to see the answer and solution.

To assign a macro to an event, users need to open the form in Design View.

Select an option to see the answer and solution.

A DBMS that runs on many different operating systems is said to be __________.

Select an option to see the answer and solution.

HSAM stands for ________

Select an option to see the answer and solution.

What it is called to present information in a particular order based on numeric or alphabetical value?

Select an option to see the answer and solution.

A query summarizes information in a grid, organized by regions and months. Which type of query is this?

Select an option to see the answer and solution.

To create a table in Access

Select an option to see the answer and solution.

The size of Yes No field is always

Select an option to see the answer and solution.

The Input Mask wizard does NOT include the ability to do which of the following?

Select an option to see the answer and solution.

The_______ operator will cause a record to be selected only if two or more conditions are satisfied

Select an option to see the answer and solution.

Which control does access use to link data access page components to Access data?

Select an option to see the answer and solution.

The Fill/Back Color button on the formatting toolbar applies color to:

Select an option to see the answer and solution.

Unlike text data type, this can store up to maximum of 65, 535 characters.

Select an option to see the answer and solution.