Home / Tests / Microsoft Access Test 2 Online MCQs

Microsoft Access Test 2 Online MCQs

Test Name	Microsoft Access Test 2
Subject	Computer
Test Type	MCQs
Total Question	20
Total Marks	40
Total Time	20 Mints
Test Help For	Basic Knowledge about IT IT General Knowledge Quiz Computer History IT & Computer Tests General Ability Competitive Exams.

Microsoft Access Test 2 Online MCQs

Show paginator

Hide paginator

Computer

1. To insert a graphic of your company’s logo on a report

You can’t. Microsoft Access won’t let you insert graphics files.

Select Insert > Picture from the menu

Select Tools > Insert Picture from the menu

Click the image button on the toolbox and drag on the report to draw a place holder for the graphics

Question 1 of 20

2. The filter by selection feature allows you to filter

Those records that match an entity in a field

Records that meet any of several criteria you specify

All of above

Records based on a criterion you specify

Question 2 of 20

3. What is the memo data type field used for?

To add table

For long text entries

For shout text entries of no more than 255 characters

To store objects created in other programs

Question 3 of 20

4. The type of query extract the data and put them into separate table

An update query

A parameter query

A make-table query

A crosstab query

Question 4 of 20

5. The checking operation performed on input data is called the

Cross check

Control of data

Verification of data

Validation of data

Question 5 of 20

6. How can you display Pivot Table report summary data in a currency format?

Modify the field settings

Type in the currency symbol

None of the above

Use custom calculation

Question 6 of 20

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

All aspects of the control

The text in the selected control

The background of the selected control

The border of the selected control

Question 7 of 20

8. A form defines

The width of each field

Both (A) and (B)

Where data is placed on the screen

All of the above

Question 8 of 20

9. The following method you can use to add a new table to your database

Use Design View to create a table

Both of above

Enter data directly by using a datasheet

All of the above

Question 9 of 20

10. The following criterion is NOT written using the proper syntax?

Between #1/1/2000# and #12/31/2000#

“Haris”

NO VALUE

<500

Question 10 of 20

11. What method can you use to add a new table to your database?

Enter data directly by using a datasheet

Both of above

All of the above

Use Design View to create a table

Question 11 of 20

12. What is the purpose of the description column in Table Design View?

None of the above

To enter lookup data that the field should refer to.

To describe the data that should be entered in each field

To define the data type applied to each field within the table

Question 12 of 20

13. Which of the following is not a selection technique ?

To select an entire table click the empty bosx to the left of the field names

To select a word, double click the word

To select a row, click the record selector box to the left of the row

To select a column, double click anywhere in the column

Question 13 of 20

14. What is the propose to a sub datasheet?

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

All of the above

To display summarized data.

To display grouped data in a report

Question 14 of 20

15. The following you can use in a macro to automatically send a report snapshot in an email message

Use mail

Send object

Run macro

All of the above

Question 15 of 20

16. The checking operation performed on input data is called the

Validation of data

Verification of data

Control of data

Cross check

Question 16 of 20

17. In Access press F11 to

Turn on Resize mode for the active window when it is not maximized; press the arrow keys to resize the window

Cycle between open windows

Toggle the Navigation Pane

Restore the selected minimized window when all windows are minimized

Question 17 of 20

18. How can you display sales grouped by country, region, and salesperson, all at the same time?

Use the find command on specified groups

Use the Pivot table view command

Use the Sort Descending command.

All of above

Question 18 of 20

19. Which action do you use in a a macro to automatically send a report snapshot in an email message?

Run macro

All of the above

Use mail

Send object

Question 19 of 20

20. To display sales grouped by country, region, and salesperson, all at the same time

Use the find command on specified groups

Use the Pivot table view command

Use the Sort Descending command.

All of above

Question 20 of 20

Related Post

UPC MET 2023 Preparation Online Test Free Mock Test For…
SSC CGL Exams 2023 Test Preparation Online Practice Mock…
KVPY Exams 2023 Test Preparation Online Mock Test MCQs
CGTET Exams 2023 Test Preparation Online Mock Test MCQs
HTET Exams 2023 Test Preparation Online Mock Test MCQs
SNAP Exams 2023 Test Preparation Mock Test Online MCQs

Test By Subject	Computer Science
Test By Topics	Computer General

Have any Problem or Error please mention in below comments section.

2021-01-16

Test Advisor

Microsoft Access Test 2 Online MCQs

Microsoft Access Test 2 Online MCQs

Computer

Leave a Reply Cancel reply