In Access, what is the purpose of the 'AutoNumber' data type? MCQ with Answer and Explanation

Question

Share Report Error

In Access, what is the purpose of the 'AutoNumber' data type?

A. To copy numbers from another table

B. To automatically generate a unique number for each record

C. To auto-increment a field based on a formula

D. To store random numbers

Answer: Option B

Solution (By JKSSB Mock Tests)

AutoNumber is a data type that automatically generates a unique sequential number when a record is added, often used as a primary key.

This question belongs to: Computer Microsoft Office

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

In Excel, to name a range, you can:

A. Select range, type name in Name Box and press Enter

B. Both A and B

C. Formulas -> Define Name

D. Insert -> Name

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Both methods work.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which SQL statement query mode is used to permanently remove specified records from an underlying data table row range?

A. Remove Rows Macro

B. Drop Table Query

C. Delete Query

D. Truncate Action

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Delete Query matches target row entries using defined criteria limits and permanently removes those records from the table database.

This question belongs to: Computer Microsoft Office

Question #3

To quickly minimize the ribbon in MS Office, press:

A. F1

B. Alt + F1

C. Ctrl + F1

D. Shift + F1

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ctrl+F1 collapses/expands the ribbon.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs