MCQ Qusestions for MS Access
1. This data type allows alphanumeric characters and special symbols.
a. text
b. memo
c. auto number
d. None of the above
2. In a database table, the category of information is called
a. tuple
b. field
c. record
d. All of above
3. Which of the following is not a database object?
a. Tables
b. Queries
c. Relationships
d. Reports
4. In one-to-many relationship the table in ‘one’ side is called………and on ‘many’ side is called………
a. Child , Parent
b. Parent , Child
c. Brother , Sister
d. Father , Son
5. The size of a field with Number data type can not be
a. 2
b. 4
c. 8
d. 16
6. The size of Yes No field is always
a) 1 bit
b) 1 byte
c) 1 character
d) 1 GB
7. This key uniquely identifies each record
a) primary key
b) key record
c) unique key
d) field name
8. Which field type will you select to enter long text in that field?
a) Text
b) Memo
c) Currency
d) Hyperlink
9. Which of the following is not a type of relationship that can be applied in Access database
a. One to One
b. One to Many
c. Many to Many
d. All of above can be applied
10. Which of the field has width 8 bytes?
a) Memo
b) Number
c) Date/Time
d) Hyperlink
11. Which of the following database object hold data?
a) Forms
b) Reports
c) Queries
d) Tables
12. A …………….enables you to view data from a table based on a specific criterion
a) Form
b) Query
c) Macro
d) Report
13. Which of the following database object produces the final result to present?
a) Forms
b) Reports
c) Queries
d) Tables
14. The default and maximum size of text field in Access
a) 50 and 255 Characters
b) 8 and 1 GB
c) 266 characters & 64000 characters
d) None of above
15. A……………. name must be unique within a database
a) Table
b) Field
c) Record
d) Character
16. It is an association established between common fields of two tables.
a) line
b) relationship
c) primary key
d) records
17. Which of the following is not a field type in Access
a) Memo
b) Hyperlink
c) OLE Object
d) Lookup Wizard
18. When entering field name, how many characters you can type in maximum?
a) 60
b) 64
c) 68
d) Any number of character
19. It is a database object to view, change, and analyze data in different ways
a) query
b) form
c) report
d) None of the above
20. Which of the following creates a drop down list of values to choose from a list?
a) OLE Object
b) Hyperlink
c) Memo
d) Lookup Wizard
21. What are the columns in a Microsoft Access table called?
a) Rows
b) Records
c) Fields
d) Columns
22. Unlike text data type, this can store up to maximum of 65, 535 characters.
a) memo
b) data/time
c) number
d) All of above
23. What is the maximum length a text field can be?
a) 120
b) 255
c) 265
d) 75
24. Microsoft Access is a
a) RDBMS
b) OODBMS
c) ORDBMS
d) Network database model
25. Which of the following store command to retrieve data from database?
a) Forms
b) Reports
c) Queries
d) Tables