Top 550+ Solved Microsoft Access (MS Access) MCQ Questions Answer
Q. Database Management Systems are featured with:
a. The facility to easy editing, spelling check, auto pagination, lay out and printing reports
b. The ability to store large amount of data to facilitate easy update, sort and retrieval
c. The ability to calculate efficiently with the help of built-in functions and analyze
d. All of above
Q. 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
Q. An Access database object that is used to enter, view or edit records
a. Table
b. Form
c. Query
d. Report
Q. 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
Q. 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
Q. 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
Q. A composite key is
a. Required when a table does not have any unique fields in it
b. The primary key with AutoNumber as the field type
c. Made up of two or more fields to uniquely identify records
d. Is a foreign key that uniquely identifies records
Q. A primary key in any table has the properties
a. Not Null
b. No Duplicates
c. Both of above
d. None of above
Q. 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
Q. How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:
a. Query Wizard
b. Look up Wizard
c. Form Wizard
d. Report Wizard
Q. An organized collection of logically related data is known as
a. Data
b. Meta data
c. Database
d. Information
Q. HSAM stands for ________
a. Hierarchic Sequential Access Method
b. Hierarchic Standard Access Method
c. Hierarchic Sequential and Method
d. Hierarchic Standard and Method
Q. Which of the following is not a logical database structure?
a. Chain
b. Network
c. Tree
d. Relational