MS Access MCQs
1) It’s a collection of facts and figures
a) Data
b) Information
c) News
d) Record
2) It is a database software package
a) MS Excel
b) MS PowerPoint
c) MS Word
d) MS Access
3) An organized collection of records.
a) File
b) Database
c) Information
d) Data
4) It is a collection of data that is organized in rows and columns.
a) Tables
b) Graph
c) Information
d) None of these
5) It’s the single unit of information in a table
a) Fields
b) Data
c) File
d) Record
6) …………………. is the set of all data fields for one row of the table.
a) Data
b) Record
c) Fields
d) None of these
7) Each record (row) within a table must be …………………………………….
a) Same
b) Correct
c) Wrong
d) Unique
8) The abbreviation of DBMS is :
(a) Direct and Better Management System
b) Database Management System
c) Don’t Bother in Managing System
d) All of these
9) It is a collection of computer based application programs that helps users to create and maintain a database.
a) MS Access
b) MS PowerPoint
c) MS Excel
d) DBMS
10) RDBMS stands for
a) Relational Database Management System
b) Really Don’t Bother in Managing System
c) Related Database Managing System
d) Both A and c
11) It is a database query language that is mostly used by RDBMS
a) PHP
b) Java
c) SQL
d) CSS
12) It is a way of reducing the number of records in a list which does not matches as per the given criteria
a) Deletion
b) Removal of Records
c) Access Filter
d) None of these
13) The feature that allows use to reorder (in Ascending and Descending order) a list of data in our table.
a) Sequence
b) Sort
c) Arrange
d) Chronological Order
14) The way of displaying or printing information from your database.
a) Preview
b) Display
c) Reports
d) All of these
15) A key that refers to one or more fields in a table and uniquely identifies the each records in the table.
a) Primary Key
b) Master Key
c) Duplicate key
d) Keywords
Answer Keys :
|
1 |
A |
| 2 |
D |
|
3 |
B |
| 4 |
A |
|
5 |
A |
| 6 |
B |
|
7 |
D |
| 8 |
B |
|
9 |
D |
| 10 |
A |
|
11 |
C |
| 12 |
C |
|
13 |
B |
| 14 |
C |
|
15 |
A |
