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

Question
In Access, what is the purpose of the 'AutoNumber' data type?
A. To store random numbers
B. To automatically generate a unique number for each record
C. To auto-increment a field based on a formula
D. To copy numbers from another table
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 MS Excel, what does the error code '#NULL!' indicate?
A. A required lookup key value cannot be located inside a range array.
B. A function name contains a typographical misspelling mistake.
C. A formula attempts to divide a numeric value by an empty cell row.
D. A formula specifies an intersection of two cell ranges that do not intersect.
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The #NULL! error occurs when a space operator is used between two ranges that do not intersect, such as evaluating =SUM(A1:A2 B1:B2) instead of using a comma operator.
This question belongs to: Computer Microsoft Office
Question #2
Which presentation view displays an adjustable multi-level textual list of slide contents for quick editing in MS PowerPoint?
A. Slide Sorter View
B. Reading Layout Mode
C. Notes Page Layout
D. Outline View
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Outline View isolates the text hierarchy from layout graphics, enabling rapid edits to presentation titles and bullet points.
This question belongs to: Computer Microsoft Office
Question #3
In MS Access, the 'AutoExec' macro:
A. Runs automatically when the database is opened
B. Executes a series of queries
C. Is a reserved name for export
D. Creates an executable file
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A macro named AutoExec runs on database open.
This question belongs to: Computer Microsoft Office
Explore All Microsoft Office MCQs
Today's Top Topics
Computer Networking 325 Microsoft Office 1199 CPU (Central Processing Unit) 327 Cyber Security 269 Memory and Storage Devices 438
Explore Subjects
Geography GK 6121 Current Affairs 575 History GK 3374 Accountancy and Statistics 3179 Maths 5575
Practice Mix
Select the most appropriate meaning of the idiom: 'Make a mountain out of a molehill'.
What does the 'GUI' acronym stand for in computer interface terminology?
A trader marks his goods 80% above cost price and gives a discount of 40%. Find his gain percent.
Which type of memory is used to store the firmware that boots the computer?
The average of 8 numbers is 30. If one number is 40, find the average of the remaining 7.