Top MCQ Questions & Answers MS Access – Set 28

Are you guys looking for Computer science Engineering MCQ Questions with Answers PDF Free Download as per Computer science Engineering 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 Engineering. Each question has four options followed by the right answer. These Computer science Engineering MCQ Questions are selected supported by the newest exam pattern.


Q1. If a color property contains “#336699”, how many blue units are in the color?

(A) 33
(B) 66
(C) 99
(D) 255

Answer: (C) 99


(A) Data
(B) Meta data
(C) Database
(D) Information

Answer: (C) Database


Q3. If a piece of data is stored in two places in the database, then a

(A) Storage space is wasted
(B) Changing the data is one spot will cause data inconsistency
(C) It can be more easily accessed
(D) Both ‘a’ and ‘b’

Answer: (D) Both ‘a’ and ‘b’


(A) Default field
(B) Linking tables
(C) Index
(D) Join line

Answer: (D) Join line


Q5. You created a query with two tables that did NOT have a join line. The first table has 12 records and the second has 5. The resulting would have how many records?

(A) 7
(B) 17
(C) 60
(D) Not enough information to tell

Answer: (C) 60


Q6. Which function extracts the name of the month from a date/time value?

(A) Month
(B) MonthName
(C) MonthLabel
(D) MonthValue

Answer:(B) MonthName


(A) Grand totals
(B) Column headings
(C) Subtotals
(D) Page numbers

Answer: (A) Grand totals


Q8. The filter by selection feature allows you to filter:

(A) Those records that match an entity in a field
(B) Records based on a criterion you specify
(C) Records that meet any of several criteria you specify
(D) All of above

Answer:(A) Those records that match an entity in a field


Q9. The __ is a wild card that represents one or more characters.

(A) Question mark
(B) Asterisk
(C) Exclamation mark
(D) Dollar sign

Answer: (B) Asterisk


Q10. Which is NOT an option of the Picture Size Mode property?

(A) Clip
(B) Fit
(C) Stretch
(D) Zoom

Answer: (B) Fit


Q11. In a junction table, the __ field consists of the foreign key from both the linked tables.

(A) First defined
(B) Last defined
(C) Foreign key
(D) Primary key

Answer: (C) Foreign key


Q12. Which of the following relationship is not valid in MS Access?

(A) Many to Many
(B) Many to Null
(C) One to One
(D) One to Many

Answer: (B) Many to Null


Q13. A small button with three dots usually displayed at the right of field properties box

(A) Make button
(B) Expression button
(C) Build button
(D) None of above

Answer: (C) Build button


Q14. Which of the following methods CANNOT be used to delete records from a table?

(A) Selecting records and pressing [Delete]
(B) Pressing [Ctrl]+[\’]
(C) Clicking the Delete Record button
(D) From the ribbon, selecting Delete Record

Answer: (B) Pressing [Ctrl]+[\’]


Q15. Which of the following field properties is an expression that specifies criteria or requirements for entering data?

(A) Field Size
(B) Format
(C) Input Mask
(D) Validation Rule

Answer: (D) Validation Rule


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