Microsoft Access Quiz Questions and Answers – Set 10

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 valid Data Type in MS Access?

(A) Memo
(B) Picture
(C) Currency
(D) AutoNumber

Answer: (B) Picture


Q2. The page count of a report can be determined by clicking the __ button.

(A) First Page
(B) Previous
(C) Next
(D) Last Page

Answer: (D) Last Page


Q3. A __ enables you to view data from a table based on a specific criterion

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

Answer: (B) Query


Q4. Which program do you use to edit code for data access pages?

(A) Microsoft script editor
(B) Microsoft code editor
(C) Microsoft data access pages editor
(D) None of above

Answer: (A) Microsoft script editor


Q5. What is an intersection of a row and a column?

(A) Form
(B) Cursor
(C) Cell
(D) Record

Answer: (C) Cell


Q6. In MS Access, which data type is appropriate to store large text and numbers?

(A) Text
(B) Memo
(C) OLE
(D) Large Text

Answer: (B) Memo


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

Answer: (C) Reports


Q8. Which of the following is a method to create a new table in MS Access?

(A) Create table in design view
(B) Create table using wizard
(C) Create table by entering data
(D) All of above

Answer: (D) All of above


Q9. When a picture or other graphic image is placed in the report header section it will appear_________

(A) Once in the beginning of the report
(B) At the top of every page
(C) Every after record break
(D) On the 1st and last pages of the report

Answer: (A) Once in the beginning of the report


Q10. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

(A) zipcode, firstname, lastname
(B) firstname, lastname, zipcode
(C) zipcode, lastname, firstname
(D) Can’t sort by multiple fields

Answer: (C) zipcode, lastname, firstname


Q11. Which of the following is use to view or print the data in organized manner?

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

Answer: (B) Report


Q12. Which of the following is NOT possible when printing Forms?

(A) Print page 1, 3, and 5
(B) Print pages 1 through 5
(C) Print selected records
(D) Print only the third record

Answer: (A) Print page 1, 3, and 5


Q13. What is a form in MS Access?

(A) It is a printed page where users will write their data to fill it up
(B) It is an input screen designed to make the viewing and entering data easier
(C) This is an important part of database used by analysts to draw conclusions
(D) All of above

Answer: (B) It is an input screen designed to make the viewing and entering data easier


Q14. To create a new table, in which method you don’t need to specify the field type and size?

(A) Create table in Design View
(B) Create Table using wizard
(C) Create Table by Entering data
(D) All of above

Answer: (C) Create Table by Entering data


Q15. In an application created using the database wizard, the main menu is presented as a:

(A) Form, called a switchboard
(B) Report, called a menu
(C) Table, called a switchboard
(D) Query, called a menu

Answer: (A) Form, called a switchboard


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