Microsoft Access MCQ Solved Paper for NMAT
Thursday 9th of March 2023
1. The___ operator will cause a record to be selected only if two or more conditions are satisfied
A. Or
B. If or
C. Range
D. And
Answer : D
2. 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
3. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
A. a doctors sign
B. thin + sign
C. outline rectangle
D. None of above
Answer : C
4. 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
5. Following is not a database model
A. network database model
B. relational database model
C. Object Oriented database model
D. None
Answer : D
6. Which of the following is not a database object in MS Access?
A. Tables
B. Query
C. Report
D. Relationship
Answer : D
7. Collection of related records in a database is known as
A. File
B. Bench
C. Table
D. Relationship
Answer : C
8. If I create Student field in Fees table to store student_id of Students table, then this Student field in Fees table is called:
A. Foreign key
B. Native key
C. Composite key
D. Primary key
Answer : A
9. This key uniquely identifies each record
A. primary key
B. key record
C. unique key
D. field name
Answer : A
10. Which of the following is not a field type in Access
A. Memo
B. Hyperlink
C. OLE Object
D. Lookup Wizard
Answer : D
11. When entering field name, how many characters you can type in maximum?
A. 60
B. 64
C. 68
D. Any number of character
Answer : B
12. The__ button on the tool box display data from a related table
A. Sub form sub report
B. Relationships
C. Select objects
D. More controls
Answer : A
13. Microsoft Access is a
A. RDBMS
B. OODBMS
C. ORDBMS
D. Network database model
Answer : A
14. It is a query that when run displays its own dialog box prompting you for information, such as
A. Select
B. crosstab
C. Parameter
D. Append
Answer : C
15. Which field type will you select when creating a new table if you require to enter long text in that field?
A. Text
B. Memo
C. Currency
D. Hyperlink
Answer : B
16. The expression builder is an access tool that controls an expression___ for entering an expression
A. Table
B. Box
C. Cell
D. Palette
Answer : B
17. Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
A. Foreign key
B. Native key
C. Composite key
D. Primary key
Answer : D
18. An Access database object that is used to enter, view or edit records
A. Table
B. Form
C. Query
D. Report
Answer : B
19. Which of the following can be an example of a database?
A. Address book of all the suppliers of a company
B. Salary sheet of all the employees of a company
C. Records of daily sales transactions of a company
D. All of above
Answer : D
20. A __ name must be unique within a database
A. Table
B. Field
C. Record
D. Character
Answer : A
21. You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
A. Clicking
B. Right clicking
C. Double clicking
D. None of the above
Answer : C
22. 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
Answer : A
23. 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
24. 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