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

4/26

Page

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

In access, this displays the results of a calculation in a query

Select an option to see the answer and solution.

If you are creating a cross tab query, what must table you are querying contain?

Select an option to see the answer and solution.

What type of control in a form can display data from database table?

Select an option to see the answer and solution.

Which field type will you select when creating a new table if you require to enter long text in that field?

Select an option to see the answer and solution.

which of the following is not a data type

Select an option to see the answer and solution.

When adding an image, which size mode will change the height or width of the image fit the control?

Select an option to see the answer and solution.

In a module, a(n) _______ is a series of commands and properties that perform a specific task.

Select an option to see the answer and solution.

By default, what is the name of a new module in the Modules folder of the Project pane called?

Select an option to see the answer and solution.

You add a table to the query design window

Select an option to see the answer and solution.

You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?

Select an option to see the answer and solution.

You have a Command button in the Form Footer, you click the Tabular Control Layout; an attached label will be added in what section?

Select an option to see the answer and solution.

In MS Access, Field Value may contain

Select an option to see the answer and solution.

How to make a date field DOB store the dates like "2002/10/17" ?

Select an option to see the answer and solution.

In Access press to Move to the previous page of the wizard

Select an option to see the answer and solution.

The operation of checking input data against specified criteria is known as?

Select an option to see the answer and solution.

A(n)_______ is a major object that can run independent of a control.

Select an option to see the answer and solution.

(IF [Age]>65, "Senior","Adult") This expression is an example of:

Select an option to see the answer and solution.

It is a query that when run displays its own dialog box prompting you for information, such as

Select an option to see the answer and solution.

Which of the following can a Report Wizard NOT do?

Select an option to see the answer and solution.

A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.

Select an option to see the answer and solution.