MS Access Database Mcqs - Set 1

1)   Which field type will you select if you need to enter long text in that field?

a. Text
b. Memo
c. Currency
d. Hyperlink
Answer  Explanation 

ANSWER: Memo

Explanation:
No explanation is available for this question!


2)   The expression builder is an access tool that controls an expression___ for entering an expression

a. Table
b. Box
c. Cell
d. Palette
Answer  Explanation 

ANSWER: Box

Explanation:
No explanation is available for this question!


3)   Which of the following is not a type of MS Access databaseobject?

a. Table
b. Form
c. Worksheets
d. Modules
Answer  Explanation 

ANSWER: Worksheets

Explanation:
No explanation is available for this question!


4)   In which method we don't need to specify the field type and size while creating a new Table?

a. Design View
b. While using Wizard
c. CreateTable By Entering Data
d. All of Above
Answer  Explanation 

ANSWER: CreateTable By Entering Data

Explanation:
No explanation is available for this question!


5)   The size of yes/no field is always ________

a. 1 Bit
b. 1 Byte
c. 1 Character
d. 1 KB
Answer  Explanation 

ANSWER: 1 Bit

Explanation:
No explanation is available for this question!


6)   The size of a field with number data type can not be _____

a. 2
b. 4
c. 8
d. 16
Answer  Explanation 

ANSWER: 16

Explanation:
No explanation is available for this question!


7)   Ho can you edit a relationship already established between two tables?

a. Right click the relationship line and choose Edit Relationship
b. Double click the relationship line
c. Both of above
d. None of above
Answer  Explanation 

ANSWER: Both of above

Explanation:
No explanation is available for this question!


8)   What does the show check box in query design window indicate ?

a. It indicates whether the field is to be used or not.
b. It indicates whether the field is to be displayed in query result or not
c. It indicates whether the field names to be displayed in query result or not.
d. It indicates whether the field is to be used for grouping result or not.
Answer  Explanation 

ANSWER: It indicates whether the field is to be displayed in query result or not

Explanation:
No explanation is available for this question!


9)   Which of the following option creates a Drop Down List of values ?

a. Ole Object
b. Hyperlink
c. Memo
d. Lookup Wizard
Answer  Explanation 

ANSWER: Lookup Wizard

Explanation:
No explanation is available for this question!


10)   what can be the maximum length of a text field ?

a. 120
b. 255
c. 265
d. 75
Answer  Explanation 

ANSWER: 255

Explanation:
No explanation is available for this question!