1000+ Microsoft Access Multiple Choice Question Answer [Solved]

1. Which of the following expresses correct order?
A. Characters, Fields, Records, Tables, Files, Databases
B. Characters, Fields, Records, Tables, Database, Files
C. Databases, Tables, Files, Records, Field, Character
D. Files, Databases, Tables, Records, Fields, Characters
Answer : A

2. After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
A. You need to delete the whole tablThere is no method to remove a particular field only.
B. Delete all the fields from third downwards and reenter the required fields again.
C. Select the third column in datasheet view then Delete
D. Select the third row in table design view then Delete
Answer : D

3. In table design view what are the first column of buttons used for
A. Indicate Primary Key
B. Indicate Current Row
C. Both of above
D. None of above
Answer : C

4. Which of the following database object produces the final result to present?
A. Forms
B. Reports
C. Queries
D. Tables
Answer : B

5. Which of the following statement is true
A. Reports can be used to retrieve data from tables and calculate
B. Queries can be printed in well formatted manner and presented as the information
C. Queries can include calculated fields that do not exist in table
D. Reports and forms are similar but forms are use to print but reports to display on screen only
Answer : C

6. Which of the following is not a database object?
A. Tables
B. Queries
C. Relationships
D. Reports
Answer : C

7. Following is not a database model
A. network database model
B. relational database model
C. Object Oriented database model
D. None
Answer : D

8. This data type allows alphanumeric characters and special symbols.
A. text
B. memo
C. auto number
D. None of the above
Answer : A

9. 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
Answer : D

10. A primary key in any table has the properties
A. Not Null
B. No Duplicates
C. Both of above
D. None of above
Answer : C

11. What happens when you release mouse pointer after you drop the primary key of a table into foreign key of another table?
A. A relationship is created
B. Edit relationship dialog box appears
C. Error occurs
D. Nothing happens
Answer : B

12. The command center of access file that appears when you create or open the MS Access database file.
A. Database Window
B. Query Window
C. Design View Window
D. Switchboard
Answer : A

13. The size of Yes No field is always
A. 1 bit
B. 1 byte
C. 1 character
D. 1 GB
Answer : A

14. In a database table, the category of information is called ____________
A. tuple
B. field
C. record
D. All of above
Answer : B

15. To create primary key for a table when in design view
A. Type PRIMARY in field type box when creating required field
B. Mark the Primary check box in field name of required field
C. Click the Primary Key button in Design ribbon when the cursor is in required field
D. None of the above
Answer : C

16. A search value can be an exact value or it can be
A. Logical Operator
B. Relationship
C. Wild card character
D. Comparison operation
Answer : C

17. Which of the following is a method to create a new table in MS Access?
A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
D. All of above
Answer : D

18. 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
Answer : A

19. Which of the following statement is true?
A. Foreign key fields dont allow duplicate values
B. In primary key field you can enter duplicate value
C. In an indexed field you may or may not enter duplicate value depending upon setting
D. All statements are true
Answer : C

20. To duplicate a controls formatting you can use___
A. Manager
B. Wizard
C. Painter
D. Control
Answer : C

21. What do you mean by one to many relationship between Student and Class table?
A. One student can have many classes
B. One class may have many student
C. Many classes may have many students
D. Many students may have many classes
Answer : A

22. This key uniquely identifies each record
A. primary key
B. key record
C. unique key
D. field name
Answer : A