Treasure of MCQS

Which of the following pane is NOT available in Task pane?

Slide Design

Master Slide

Slide Layout

Slide Transition

It is the most common type of query. It retrieves records from one or more tables and then displays the

Parameter

Select

Crosstab

All of the above

Which of the following is a method to create a new table in MS Access?

Create table in Design View

Create Table using wizard

Create Table by Entering data

All of the above

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

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

a doctor's sign

thin + sign

outline rectangle

None of above

Queries in Access can be used as

view, change, and analyze data in different ways

a source of records for forms and reports

Only option a

Both option a and b

Which field type can store photos?

Hyperlink

Both of these can be used

Access tables can't store photos

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

If or

Range

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

Memo

data/time

Number

All of the above

We can remove a relationship defined between two tables by

From Edit menu choose Delete Relationship

Select the relationship line and press Delete

Choose Delete option from the Relationship menu

All of the above

What is the purpose of a sub datasheet?

To provide a hierarchical view of related tables or queries in a single window

To display grouped data in a report

To display summarized data

All of the above

For Viewers

I am working hard on daily basis to add correct and important multiple question answer (Mcqs) but still mistake can happen because no one is 100% perfect. Also, I am getting these info from both online and offline sources So, It will be nice to fix me if I did any mistake in answering or Asking a question. Your explanation will be review by author and will be added to post. Contributors will be rewarded by mentioning their name and with social profile link if some one willing to. You can also submit Mcqs by clicking Here but before submitting make sure that question isn't available on our blog. For that do a quick search to confirm it. Thanks