In MS Access, what is the default data type for a field when you create a new table in Datasheet View? MCQ with Answer and Explanation

Question

Share Report Error

In MS Access, what is the default data type for a field when you create a new table in Datasheet View?

A. Number

B. AutoNumber

C. Long Text

D. Short Text

Answer: Option D

Solution (By JKSSB Mock Tests)

When you enter data directly, Access assigns Short Text by default.

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 PowerPoint, pressing 'B' during a slide show will:

A. Go back to the previous slide

B. Turn the screen black

C. Show all slides as thumbnails

D. End the show

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Pressing B blacks out the screen, W whites it out.

This question belongs to: Computer Microsoft Office

Question #2

In MS Access, which data type automatically generates a unique number for each new record?

A. AutoNumber

B. Yes/No

C. Number

D. Currency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
AutoNumber is used for sequential unique IDs. Number stores numeric values, Currency for monetary data, Yes/No for boolean.

This question belongs to: Computer Microsoft Office

Question #3

In MS Access, which object is used to define a custom task that runs automatically?

A. Report

B. Query

C. Macro

D. Module

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Macros automate tasks.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs