Microsoft Access MCQ Questions and Answers – Set 03

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 is not a logical database structure?

(A) Chain
(B) Network
(C) Tree
(D) Relational

Answer: (A) Chain


Q2. Which of the following statements about a tab control in a form is incorrect?

(A) It can contain only one object
(B) It defines a layered space
(C) It is a control object
(D) It is created in multipage forms

Answer: (A) It can contain only one object


Q3. Which of the following statements about PivotChart View is NOT true?

(A) It is used to graphically summarize and analyze data in a table, query, or form
(B) It can be used to view different levels of detail or to specify custom layout
(C) It displays field values that can be switched for different views of data
(D) It displays the same information as a crosstab query, except for the counts and sums of numeric fields

Answer:(D) It displays the same information as a crosstab query, except for the counts and sums of numeric fields


Q4. Which field type can store photos?

(A) Hyperlink
(B) Ole
(C) Both of these can be used
(D) Access tables can’t store photos

Answer: (B) Ole


Q5. This option allows you to build a new table by entering data directly into the datasheet.

(A) Datasheet view
(B) Design view
(C) Link table
(D) None of the above

Answer: (A) Datasheet view


Q6. Which type of field is incremented automatically?

(A) Auto Elevate
(B) AutoNumber
(C) Auto Increment
(D) Auto Value

Answer: (B) AutoNumber


Q7. Which of the following statements regarding charts is incorrect?

(A) It can be inserted into a form only
(B) It can be designed as a standalone-object
(C) It can be linked to the object in which it is placed
(D) It is a control linked to a data source

Answer: (A) It can be inserted into a form only


Q8. In the Field List of a table, the primary key appears __.

(A) Bold
(B) Italicized
(C) Underlined
(D) With key icon

Answer: (D) With key icon


Q9. To create queries in access

(A) You can drag and drop fields on query builders
(B) You can type the sql command in sql view
(C) You can use query wizard or design view
(D) All of above

Answer: (D) All of above


Q10. Which is not a view to display a table in Access?

(A) Datasheet View
(B) Design View
(C) Pivot Table & Pivot Chart View
(D) None of above

Answer: (D) None of above


Q11. Which tool do you use to create a query object?

(A) Database wizard
(B) Simple filter wizard
(C) Simple query wizard
(D) Table query wizard

Answer: (C) Simple query wizard


Q12. Which of the following is the file extension for an Extensible Markup Language?

(A) EML
(B) HTML
(C) XML
(D) XSD

Answer: (C) XML


Q13. Which is NOT a method of creating a table?

(A) Datasheet View
(B) Design View
(C) Layout View
(D) Template

Answer: (C) Layout View


Q14. 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 students
(C) Many classes may have many students
(D) Many students may have many classes

Answer: (A) One student can have many classes


Q15. Which of the following database object produces the final result to present?

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

Answer: (B) Reports


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