MS Access MCQ Questions and Answers – Part 2
MS Access MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about Access Relational Database Management System. and much more. This systematic learning method will easily prepare anyone to pass their exam.
1. What type of field would you select when creating a new table if you wanted to enter long text in that field?
A Memo
B Text
C Financial
D String
A
The Memo data type has been renamed “Long text”.
2. Which of the following is not a relationship type that can be applied in an Access database?
A One to One
B One to Many
C Many to Many
D All the answers are true
D
There are three types of table relationships in Access.
- One to many relationship.
- Many-to-many relationship.
- One to one relationship.
3. Which field is 8 bytes in length?
A Memo
B Text
C Financial
D Date/Time
D
Access stores dates as a 64-bit (8 byte) double precision floating point number, where the integer part refers to the day and the fraction part to the time.
4. Which of the following is/are one or more views to display a table in Access?
A Datasheet View
B Design View
C Both A and B are true.
D None of the above
C
5. Which of the following database objects contains data?
A Reports
B Tables
C Forms
D All the answers are true
B
A database table is composed of records and fields containing data. Each table in a database contains data, but related. The data is stored in records.
6. A _______ allows you to view the data of a table according to a specific criteria.
A Query
B Report
C Form
D All the answers are true
A
7. Which of the following database objects produces the final result to be presented?
A Query
B Report
C Form
D All the answers are true
B
8. The database language that allows you to access data in a database is _____.
A DML
B DCL
C DDL
D TCL
A
Data Manipulation Language (DML): It is the data manipulation language, and a programming language used to add (insert), delete and modify (update) data in a database.
9. The name of ______ must be unique in a database.
A Table
B Field
C Record
D All the answers are true
A
10. What do you call the columns of an Access table?
A Reports
B Rows
C Records
D Fields
D
