MS Access MCQs

Question 1

In Access press . . . . . . . . to Cut the selected control and copy it to the Clipboard

Accepted Answer

CTRL+X

Answer

CTRL+C

Answer

CTRL+V

Answer

None of these

Question 2

Which of the following is not a database object?

Accepted Answer

Relationships

Answer

Tables

Answer

Queries

Answer

Reports

Question 3

In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and Form view only)

Accepted Answer

SHIFT+F4

Answer

CTRL+F

Answer

CTRL+H

Answer

None of these

Question 4

a computer language for informing the dbms regarding the data structure used is

Accepted Answer

Ddl

Answer

Pascal

Answer

Prolog

Answer

Fortran

Question 5

a subset of characters within a data field is known as

Accepted Answer

Data string

Answer

Record

Answer

File

Answer

Byte

Question 6

Macros can recover from _______ in a controlled manner.

Accepted Answer

events

Answer

modules

Answer

arguments

Answer

errors

Question 7

A composite key is

Accepted Answer

Made up of two or more fields to uniquely identify records

Answer

Required when a table does not have any unique fields in it

Answer

The primary key with AutoNumber as the field type

Answer

Is a foreign key that uniquely identifies records

Question 8

According to the Leszynski Naming Conventions, which of the following is the prefix for a text box control?

Accepted Answer

txt

Answer

txb

Answer

tbc

Answer

tex

Question 9

Which setting you must modify to print a report using letterhead?

Accepted Answer

Margin

Answer

Group

Answer

Section

Answer

Orientation