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. A(n) __ is a control that, when clicked, executes an action or series of actions.
(A) Combo box control
(B) AutoFormat
(C) Conditional Format
(D) Command button
Answer: (D) Command button
Q2. Queries in access can be used as
(A) View, change and analyze data in different ways
(B) A source of records for forms and reports
(C) Only ‘a’
(D) Both ‘a’ and ‘b’
Answer: (D) Both ‘a’ and ‘b’
Q3. What data type should you choose for a zip code field in a table?
(A) Text
(B) Number
(C) Memo
(D) All of above
Answer: (A) Text
Q4. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
(A) By setting required to ‘Yes’
(B) By using default value
(C) By defining validation rule
(D) By using format
Answer: (C) By defining validation rule
Q5. The Search tool CANNOT be used on which major Access object?
(A) Forms
(B) Queries
(C) Reports
(D) Tables
Answer: (C) Reports
Q6. A(n) __ query locates data from one or more tables.
(A) Select
(B) Summary
(C) Parameter
(D) Action
Answer: (A) Select
Q7. Cascade delete option
(A) Is used to delete all the records of all tables in a database
(B) Will repeat the recent delete operation to all the records of current table
(C) Is available in edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record parent table is deleted
(D) None of above
Answer: (C) Is available in edit relationship dialog box which makes sure that all the related records will be deleted
Q8. What is the purpose of the description column in table design view?
(A) To define the data type applied to each field within the table
(B) To describe the data that should be entered in each field
(C) To enter lookup data that the field should refer to
(D) None of the above
Answer: (B) To describe the data that should be entered in each field
Q9. Which function cannot be used for calculated controls in a report?
(A) SUM
(B) AVG
(C) MPT
(D) COUNT
Answer: (C) MPT
Q10. Before printing a datasheet, you can use __ to determine whether to change the page orientation from portrait to vertical orientation.
(A) Design View
(B) Datasheet View
(C) Office View
(D) Print Preview
Answer: (D) Print Preview
Q11. Which of the following is the default join between two recordsets?
(A) Inner join
(B) Left outer join
(C) Right outer join
(D) Self join
Answer: (A) Inner join
Q12. Both conditions display on the same row in the design grid when ________operator is in use
(A) Or
(B) In
(C) And
(D) Like
Answer: (C) And
Q13. Cascade delete option
(A) Is used to delete all the records of all tables in a database
(B) Will repeat the recent delete operation to all the records of current table
(C) Is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record parent table is deleted
(D) None of above
Answer: (C) Is available in Edit relationship dialog box which makes sure that all the related records will be deleted
Q14. In MS Access “Lookup Wizard” is used to
(A) To select from previous values
(B) To select values from Excel Sheet
(C) To select value from another table
(D) Not a valid Data Type
Answer: (C) To select value from another table
Q15. What is one of the advantages for using a form over other Access objects?
(A) Utilizes field placement to improve the efficiency of data entry
(B) Forms store information more efficiently
(C) Forms show the summary of all the records
(D) Forms cannot be edited
Answer: (A) Utilizes field placement to improve the efficiency of data entry
Microsoft Access MCQ – All Set
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.