MS Access MCQ Questions and Answers – Part 1
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. This data type allows alphanumeric characters and special symbols.
A memo
B text
C char
D string
2. The query design window has two parts. The upper part shows _________
A Field name, type and size
B Sorting checkboxes
C Tables with fields and relationships between tables
D None of the above
3. In a database table, a category of information is called ________
A Record
B tuple
C field
D None of the above
4. Which of the following is not a database object?
A Form
B Tables
C Reports
D Relationships
5. In a one-to-many relationship, the table on the “one” side is called _______ and the one on the “many” side is called _______.
A Parent, child
B Child, parent
C Row, column
D None of the above
6. ____________ is the database design step where we gather and list all the fields needed for the database project.
A Data dictionary
B Data refinement
C Data definition
D None of the above
7. The size of a field with data type “Number” cannot be ______
A 2
B 4
C 8
D 16
8. The size of the Yes/No field is always _______
A 1 bit
B 1 byte
C 1 kilobyte
D 1 megabyte
9. This key uniquely identifies each record.
A Registration key
B Composite key
C Foreign key
D Primary key
10. To create a relationship between two tables
A Drag a field from the parent table and drop it on the child table.
B Drag the foreign key of a table into the primary key of another table.
C Drag the primary key of a table into the foreign key of another table.
D None of the above
Really interesting