MS-Access MCQ – Set 05

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 leads you through the process of creating a table?

(A) Wizard
(B) Assistant
(C) Relation
(D) Coach

Answer: (A) Wizard


Q2. Which of the following is NOT true about background images?

(A) They are similar to watermarks in Word
(B) They are displayed behind the controls in a form
(C) They do not print when a form or a report is printed
(D) They can be inserted on a form or a report

Answer: (C) They do not print when a form or a report is printed


Q3. A __ is a major database object used to display information in a printable page format.

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

Answer: (C) Report


Q4. The operation of checking input data against specified criteria is known as?

(A) Data verification
(B) Data validation
(C) Cross check
(D) Data control

Answer: (B) Data validation


Q5. 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


Q6. Which control types is most often associated with a bound control?

(A) Command button
(B) Label
(C) Text box
(D) List box

Answer: (C) Text box


Q7. A(n) _ query makes changes to or moves records in a dynaset, in a single operation.

(A) Select
(B) Summary
(C) Parameter
(D) Action

Answer: (D) Action


Q8. All attachment fields display as a(n) __ in Datasheet View.

(A) Icon
(B) Button
(C) Thumb tack
(D) Paperclip

Answer: (D) Paperclip


Q9. The ascending order of data hierarchy is?

(A) Bit – byte – field – record – file – database
(B) Bit – byte – record – field – file – database
(C) Byte – bit – field – record – file – database
(D) Bit – byte – field – record – database – file

Answer: (A) Bit – byte – field – record – file – database


Q10. What is the difference between ‘Open’ and ‘Open Exclusively’?

(A) Open statement opens access database files and Open Exclusively opens database files of other program like Oracle
(B) Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed
(C) Both Open and Open Exclusively are same
(D) Open Exclusive command does not exist in MS Access

Answer: (B) Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed


Q11. Which is not an option for customizing a datasheet window?

(A) Change one row\’s height
(B) Hide one column
(C) Change one column\’s width
(D) Freeze one column

Answer: (A) Change one row\’s height


Q12. In a query, which row do you need to place wildcards to affect a parameter?

(A) Arguments
(B) Criteria
(C) Fields
(D) Tables

Answer: (B) Criteriat


Q13. A DBMS that runs on many different operating systems is said to be _.

(A) Scalable
(B) Robust
(C) Platform independent
(D) Distributed

Answer: (C) Platform independent


Q14. In the form wizard dialog box, the fields from the selected table are displayed in this list box.

(A) All fields
(B) All records
(C) Available records
(D) Available fields

Answer:(D) Available fields


Q15. Which of the following statement is true?

(A) Foreign key fields don’t allow duplicate values
(B) In primary key field you can enter duplicate value
(C) In an indexed field you may or may not enter duplicate value depending upon setting
(D) All statements are true

Answer:(C) In an indexed field you may or may not enter duplicate value depending upon setting


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