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