MS Access Questions & Answers | Basic Computer Knowledge

1.

In MS-Access press CTRL+O to

   A.) Open a new database
   B.) Open an existing database
   C.) Exit MS-Access
   D.) None of these

Answer: Option 'B'

Open an existing database

2.

In MS-Access to Refresh the contents of a Lookup field (Lookup field: A field, used on a form or report in an Access database, that either displays a list of values retrieved from a table or query, or

   A.) F4 or ALT+DOWN ARROW
   B.) DOWN ARROW
   C.) F9
   D.) PAGE DOWN

Answer: Option 'C'

F9

3.

In MS-Access to open new database press

   A.) CTRL+N
   B.) CTRL+O
   C.) ALT+F4
   D.) None of these

Answer: Option 'A'

CTRL+N

4.

In MS-Access to open an existing database press

   A.) CTRL+N
   B.) CTRL+O
   C.) ALT+F4
   D.) None of these

Answer: Option 'B'

CTRL+O

5.

In MS-Access to Open a combo box

   A.) F9
   B.) PAGE DOWN
   C.) DOWN ARROW
   D.) F4 or ALT+DOWN ARROW

Answer: Option 'D'

F4 or ALT+DOWN ARROW

6.

There are three types of data found in a spreadsheet:

   A.) Equations, data, numbers
   B.) Numbers, formulas, labels
   C.) Data, words, numbers
   D.) Words, numbers, labels

Answer: Option 'B'

Numbers, formulas, labels

7.

Which symbol must all formula begin with:

   A.) @
   B.) =
   C.) +
   D.) %

Answer: Option 'B'

=

8.

To merge the cells which tab do you use from the format, cells menu?

   A.) Alignment tab
   B.) Number tab
   C.) Font tab
   D.) Merge tab

Answer: Option 'A'

Alignment tab

9.

In an excel sheet the active cell is indicated by:

   A.) A blinking border
   B.) A dotted border
   C.) A dark wide boarder
   D.) None of These

Answer: Option 'C'

A dark wide boarder

10.

How do you rearrange the date in ascending or descending order?

   A.) Data, table
   B.) Data, sort
   C.) Data, form
   D.) Data, subtotals

Answer: Option 'B'

Data, sort

MS Access MCQs Download Pdf

Recent Posts