Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. In MS Access, Text Data type may contain maximum character of
a. 255 Character
b. 256 Character
c. 1064 Character
d. No Limit
Q. Which of the following is not a valid Data Type in MS Access?
a. Memo
b. Picture
c. Currency
d. AutoNumber
Q. In MS Access "Hyperlink" Data Type can store
a. Web Address
b. email Address
c. Path of a File
d. All of Above
Q. Which of the following data type is used to store logical value in MS Access?
a. True/False
b. On/Off
c. Yes/No
d. All of Above
Q. The appropriate Data Type to store Time in MS Access?
a. Date/Time
b. Time Only
c. Time
d. Time cannot be stored
Q. In MS Access "Lookup Wizard" is used to
a. to select from previous values
b. to select values from Excel Sheet
c. to select value from another table
d. Not a valid Data Type
Q. Which of the following Data Type is used to store picture in MS Access
a. Picture
b. OLE Object
c. Memo
d. Picture cannot be stored
Q. in MS Access, which data type is appropriate to store large text and numbers?
a. Text
b. Memo
c. OLE
d. Large Text
Q. in MS Access, OLE Object Data type can store
a. Microsoft Word documents
b. Microsoft Excel spreadsheets
c. Sounds
d. All of the Above
Q. in MS Access, AutoNumber Data Type
a. Can be Sequential
b. Can be Random
c. Can be Edited
d. Only A & B
Q. Which of the following is invalid field name?
a. Student.Address
b. Student\'sAddress
c. Student_Address
d. Student Address
Q. Primary key is
a. Uniquely identifies each record
b. Cannot be repeated
c. AutoNumber is example of Primary key
d. All of the above
Q. To create a table in Access
a. Database should be created before create table
b. Table can be created using Table Templates
c. There must be at least one Primary key in a table
d. All of the above