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 invalid field name?
(A) Student.Address
(B) Student\’sAddress
(C) Student_Address
(D) Student Address
Answer: (A) Student.Address
Q2. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
(A) Match Case
(B) Match: Whole Field
(C) Match: Start of Field
(D) Match: Any Part of Field
Answer: (C) Match: Start of Field
Q3. What is the use of description field in table design window?
(A) The description will be displayed on status bar when entering data in datasheet view
(B) The description will be displayed on status bar when entering data in form
(C) Both of above
(D) None of a the above
Answer: (C) Both of above
Q4. The_______ operator will cause a record to be selected only if two or more conditions are satisfied
(A) Or
(B) If or
(C) Range
(D) And
Answer: (D) And
Q5. Which of the following queries can create a table?
(A) Append
(B) Delete
(C) Make-Table
(D) Update
Answer:(C) Make-Table
Q6. What is the use of Referential Integrity in MS Access?
(A) It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
(B) It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
(C) It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
(D) None of above
Answer: (A) It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
Q7. What happens when a user selects a record in a form and presses [Delete]?
(A) The record is deleted in the form and from its source table
(B) The record is deleted in the form, but not from its source table
(C) The record is neither deleted in the form, nor from its source table
(D) The record is not deleted in the form, but is deleted from its source table
Answer:(A) The record is deleted in the form and from its source table
Q8. Which of the following is not a section in report design window?
(A) Report header section
(B) Page header section
(C) Summary section
(D) Report footer section
Answer: (C) Summary section
Q9. It is a query that when run displays its own dialog box prompting you for information, such as
(A) Select
(B) Crosstab
(C) Parameter
(D) Append
Answer: (C) Parameter
Q10. Any report, including a basic report, can be modified in _.
(A) Form View
(B) Layout View
(C) Print Preview
(D) Report View
Answer: (B) Layout View
Q11. Relationship can be establish between two tables by
(A) Drag Primary key of a table into Foreign key of another table
(B) Drag Foreign key of a table into Primary key of another table
(C) Drag any key of a table into any key of another table
(D) All of the above
Answer:(A) Drag Primary key of a table into Foreign key of another table
Q12. The most popular commercial DBMS.
(A) Microsoft SQL Server
(B) Microsoft Access
(C) MySQL
(D) Oracle
Answer: (D) Oracle
Q13. Which of the following is not a data type?
(A) Picture/graphic
(B) Data/time
(C) Text
(D) Number
Answer: (A) Picture/graphic
Q14. A part of database that stores only one type of data is
(A) Report
(B) Field
(C) Query
(D) Record
Answer: (B) Field
Q15. Which Form tool creates a new form that show both a form and datasheet views?
(A) Form
(B) Form Wizard
(C) Multiple Item Form
(D) Split Form
Answer: (D) Split Form
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.