MS Office Access MCQs, Quiz and Practice Questions

Q1. What is the size of yes/no field?

1 Byte

1 Bit

1 KB

1 Character

Q2. Which of these is not a database object in MS Access?

Modules

Forms

Tables

Worksheets

Q3. Which of these cannot be the size of field having number data type?

8

16

4

2

Q4. This query prompts you to enter information before executing through a dialog box:

Dialog query

Crosstab query

Parameter query

Select query

Q5. Which option would you choose to create a drop-down list of values?

Hyperlink

Lookup Wizard

Ole object

Memo

Q6. What is the other name of columns in Microsoft Access?

Rows

Records

Fields

There's no other name

Q7. What is the use of the Cascade Delete option?

To delete all related table records automatically when the parent table is deleted

To repeat deleting operations to existing table records

To delete records only of related table database

To delete all table records in a database

Q8. Which button displays data from a related table?

Relationships

Sub from sub report

More controls

Select objects

Q9. What does the mouse-pointer look like when creating relationships using a mouse?

An outlined rectangle

Arrow with a plus sign

Plus sign (thin)

Plus sign (thick)

Q10. Which field type is used to enter long text in the field?

Text

Hyperlink

Currency

Memo

Your Score

- of - questions are answered correctly

DCA - Diploma in Computer Application

For Support

Office Hours

We are on

Company

Customer Service

Help

Microsoft Office Access

Your Score

- of - questions are answered correctly

Login to view answer sheet

FORGOT PASSWORD

SIGN UP

Email Verification