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

5/26

Page

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

Cascade delete option

Select an option to see the answer and solution.

Which object is used to create a form?

Select an option to see the answer and solution.

In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.

Select an option to see the answer and solution.

After right click the field selector button, which do you choose to delete a field in design view?

Select an option to see the answer and solution.

Which of the following statements about option group is incorrect?

Select an option to see the answer and solution.

The two form layout types will display multiple records at one time are tabular and___

Select an option to see the answer and solution.

Which of the following queries modifies fields not records?

Select an option to see the answer and solution.

When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.

Select an option to see the answer and solution.

Which leads you through the process of creating a table?

Select an option to see the answer and solution.

To create primary key for a table when in design view

Select an option to see the answer and solution.

Which of the following field properties enforces the use of parentheses when keying an area code?

Select an option to see the answer and solution.

In Access press to Open the Choose Builder dialog box (Design view window of forms and reports)

Select an option to see the answer and solution.

Which of the following is not a type of relationship that can be applied in Access database

Select an option to see the answer and solution.

Which of the following functions CANNOT be used in the Totals row?

Select an option to see the answer and solution.

Which criteria do not return the position "Officer" as a match?

Select an option to see the answer and solution.

To remove all Sorts in a table you can click the ______ command.

Select an option to see the answer and solution.

The expression builder is an access tool that controls an expression___ for entering an expression

Select an option to see the answer and solution.

The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.

Select an option to see the answer and solution.

Which of the following may not be a database?

Select an option to see the answer and solution.

While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into

Select an option to see the answer and solution.