In MS Access, a 'Table' object stores data in: MCQ with Answer and Explanation

In MS Access, a 'Table' object stores data in:

A. Reports

B. Pages

C. Rows (records) and columns (fields)

D. Forms

Answer: Option C

Table structure is rows and columns.

This question belongs to: Computer Microsoft Office

No comments yet. Be the first to start the discussion!

Question #1 Report Error

What is the shortcut key to redo an action in MS Office?

A. Ctrl + Y

B. Ctrl + Z

C. Ctrl + Shift + Z

D. Alt + Shift + Backspace

Correct Answer: Option A

Explanation:
Ctrl+Y is redo. Ctrl+Z is undo. Ctrl+Shift+Z sometimes also redo but standard is Ctrl+Y.

This question belongs to: Computer Microsoft Office

Question #2 Report Error

In MS Access, what is a 'composite key'?

A. An index that combines text and numbers

B. A primary key that consists of two or more fields

C. A key used to encrypt the database

D. A foreign key referencing multiple tables

Correct Answer: Option B

Explanation:
A composite key is a primary key made up of multiple columns.

This question belongs to: Computer Microsoft Office

Question #3 Report Error

In MS Access, SQL View is used to:

A. Run a macro

B. Design the table structure

C. View the output of a query in a datasheet

D. Write or edit SQL statements for a query

Correct Answer: Option D

Explanation:
SQL View shows the query's SQL code.

This question belongs to: Computer Microsoft Office