Introduction to MS Access and Database Concepts MCQs

1. MS Access is an example of which type of software?
(A) Word Processor
(B) Spreadsheet Application
(C) Database Management System (DBMS)
(D) Operating System

2. In MS Access, data is primarily stored in:
(A) Queries
(B) Tables
(C) Forms
(D) Reports

3. What is a database?
(A) A collection of related data organized for easy access and management
(B) A random collection of files
(C) A set of unrelated records
(D) A computer virus storage

4. In relational databases, a "primary key" is used to:
(A) Encrypt the database
(B) Sort data alphabetically only
(C) Connect two different applications
(D) Uniquely identify each record in a table

5. In MS Access, which object is used to retrieve and display specific data based on conditions?
(A) Reports
(B) Queries
(C) Tables
(D) Forms

6. Which of the following is NOT an object in MS Access?
(A) Tables
(B) Forms
(C) Charts
(D) Reports

7. What is the main purpose of a form in MS Access?
(A) To enter, edit, and view data easily
(B) To store raw data permanently
(C) To design relationships
(D) To perform calculations only

8. A collection of related fields in a database table is called a:
(A) Report
(B) File
(C) Query
(D) Record

9. What is the main purpose of reports in MS Access?
(A) To secure the database with passwords
(B) To delete unwanted records
(C) To organize and print formatted summaries of data
(D) To create tables automatically

10. Which of the following best describes a relational database?
(A) Stores data in interconnected tables with relationships
(B) Stores data in images
(C) Stores only one type of record
(D) Cannot be queried