MS Access MCQs

Question 1

In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

Accepted Answer

Justified

Answer

Datasheet

Answer

Tabular

Answer

Columnar

Question 2

Which of the following components has a property sheet that includes settings for the frame and the option group?

Accepted Answer

Option group frame

Answer

Option group label

Answer

Option button

Answer

Option button labels

Question 3

In Access press UP ARROW or CTRL+UP ARROW

Accepted Answer

Move the selected control up

Answer

Move the selected control to the right (except controls that are part of a layout)

Answer

Move the selected control to the left (except controls that are part of a layout)

Answer

None of these

Question 4

In the Relationship window, related fields from each table are connected by a(n) _______________.

Accepted Answer

join line

Answer

default field

Answer

linking tables

Answer

index

Question 5

Which of the following queries prompts users for input data by displaying dialog boxes?

Accepted Answer

Parameter

Answer

Append

Answer

Delete

Answer

Update

Question 6

Which of the following is not a valid Data Type in MS Access?

Accepted Answer

Picture

Answer

Memo

Answer

Currency

Answer

AutoNumber

Question 7

Which of the following is use to view or print the data in organized manner?

Accepted Answer

Report

Answer

Query

Answer

Table

Answer

Form

Question 8

What type of controls are text boxes when data from the recordset is visible?

Accepted Answer

Bound

Answer

Align

Answer

Calculated

Answer

Unbound

Question 9

If I create 'Student' field in 'Fees' table to store 'student_id' of 'Students' table, then this 'Student' field in 'Fees' table is called:

Accepted Answer

Foreign key

Answer

Native key

Answer

Composite key

Answer

Primary key