Microsoft Access MCQ – Set 01

Are you guys looking for computer science MCQ Questions with Answers PDF Free Download as per computer science new exam pattern? You came to the right page. This may assist you to understand and check your knowledge about the Subjects. Students also can take a free test of the Multiple Choice Questions of computer science. Each question has four options followed by the right answer. These computer science MCQ Questions are selected supported by the newest exam pattern.


Q1. Which of the following store command to retrieve data from database?

(A) Forms
(B) Reports
(C) Queries
(D) Tables

Answer: (C) Queries


Q2. Which of the following is not an action query?

(A) Add
(B) Delete
(C) Make-table
(D) Update

Answer: (A) Add


Q3. What is an index?

(A) A wizard that creates a functional database structure based on the user\’s selections
(B) A widely recognized naming convention for database objects
(C) A sort order for records, which is identified in the table design
(D) A set of relationship rules that enforce defined database relationships

Answer: (C) A sort order for records, which is identified in the table design


Q4. _ are documents that when filled in create records.

(A) Forms
(B) Reports
(C) Tables
(D) Queries

Answer: (A) Forms


Q5. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.

(A) Datasheet
(B) Tabular
(C) Justified
(D) Columnar

Answer: (C) Justified


Q6. What do you mean by, one-to-many relationship between Student and Class table?

(A) One student can have many classes
(B) One class may have many student
(C) Many classes may have many students
(D) Many students may have many classes

Answer: (A) One student can have many classes


Q7. Which of the following Data Type is used to store picture in MS Access?

(A) Picture
(B) OLE Object
(C) Memo
(D) Picture cannot be stored

Answer: (B) OLE Object


Q8. When you add fields in __, a Field List pane displays.

(A) Design View
(B) Layout View
(C) Print Preview
(D) Report View

Answer:(B) Layout View


Q9. To print information from a table, the _ tool is the best choice.

(A) Form
(B) Report
(C) Query
(D) Macro

Answer: (B) Report


Q10. In a database table, the category of information is called _

(A) Tuple
(B) Field
(C) Record
(D) All of above

Answer: (B) Field


(A) Attributes
(B) Tuples
(C) Relationship
(D) Columns

Answer: (D) Columns


Q12. To create a table in Access

(A) Database should be created before create table
(B) Table can be created using Table Templates
(C) There must be at least one Primary key in a table
(D) All of the above

Answer: (D) All of the above


Q13. Which report section only prints one time at the end of the report?

(A) Report Header
(B) Page Header
(C) Report Footer
(D) Page Footer

Answer: (C) Report Footer


Q14. Which of the following creates a drop down list of values to choose from?

(A) Ole object
(B) Hyperlink
(C) Memo
(D) Lookup wizard

Answer: (D) Lookup wizard


Q15. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?

(A) Home Tab
(B) Create Tab
(C) External Data Tab
(D) Database Tab

Answer: (D) Database Tab


Microsoft Access MCQ – All Set

Microsoft Access MCQ – Set 01
Microsoft access MCQ with Answers – Set 02
Microsoft Access MCQ Questions and Answers – Set 03
MS Access MCQ Questions and Answers – Set 04
MS-Access MCQ – Set 05
Microsoft Access Questions and Answers pdf – Set 06
Microsoft Access Multiple Choice Questions and Answers pdf – Set 07
Questions and Answers on Microsoft Access – Set 08
MS Access Questions and Answers pdf – Set 09
Microsoft Access Quiz Questions and Answers – Set 10
MS Access Quiz Questions and Answers – Set 11
Microsoft Access Quiz Questions and Answers pdf – Set 12
Microsoft Access Objective Quiz Questions & Answers – Set 13
Microsoft Access Practical Questions – Set 14
Microsoft Access Viva Questions – Set 15
Microsoft Access Interview Questions – Set 16
Microsoft Access MCQ Exam Questions – Set 17
Microsoft Access Computer Based Test Questions – Set 18
Computer Science MCQ on Microsoft Access – Set 19
MS Access Computer Science Questions – Set 20
Theory Exam Test Microsoft Access – Set 21
Competitive Exam Questions Microsoft Access – Set 22
Govt. Exam Questions Microsoft Access – Set 23
Microsoft Access Short Questions – Set 24
Microsoft Access 1 Mark Questions & Answers – Set 25
Microsoft Access Computer Science Questions & Answers – Set 26
MS Access – Computer Science Questions & Answers – Set 27
Top MCQ Questions & Answers MS Access – Set 28
Frequently Asked MS Access Questions with Answers – Set 29
MS Access Interview Questions for Fresher – Set 30

We hope the given computer science Engineering on Microsoft Access MCQ Questions with Answers will definitely yield fruitful results. Hope you got enough ideas on the MCQs on Microsoft Access. If you have any queries related to computer science Engineering on Microsoft Access MCQs Multiple Choice Questions with Answers, drop your questions below and will get back to you as soon as possible.

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top