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 a database management system?
(A) Ms word
(B) Ms excel
(C) Oracle
(D) Lotus 1-2-3
Answer:(C) Oracle
Q2. Which is not a command that is selectable from right click menu of a field column?
(A) Hide columns
(B) Rename columns
(C) Freeze columns
(D) Sort descending
Answer: (B) Rename columns
Q3. Which of the following functions CANNOT be used in the Totals row?
(A) Average
(B) Count
(C) Maximum
(D) Round
Answer: (D) Round
Q4. In order to use dbms, it is important to understand
(A) The physical schema
(B) All sub schemas that the system supports
(C) One sub schema
(D) Both ‘a’ and ‘b’
Answer: (C) One sub schema
Q5. In Access 2007, to make changes in the Trust Center, you need to go to the __.
(A) Microsoft Office button
(B) Navigation Pane
(C) Quick Access toolbar
(D) Database Tools command tab
Answer: (A) Microsoft Office button
Q6. To display value from table for a label control
(A) Set the control source and record source prom property panel
(B) Choose the database, table, field and select data value to display
(C) Look at the table and type value in the caption
(D) Set the record source property and then control source
Answer: (D) Set the record source property and then control source
Q7. The appropriate Data Type to store Time in MS Access?
(A) Date/Time
(B) Time Only
(C) Time
(D) Time cannot be stored
Answer: (A) Date/Time
Q8. Which of the following methods CANNOT be used to copy a block of text from one part of a table to another?
(A) Press [Ctrl]+[C] and [Ctrl]+[V]
(B) Right-click, choose from the shortcut menu Copy and Paste
(C) Press [Ctrl]+[+] and [Ctrl]+[-]
(D) From the ribbon, select Copy and Paste
Answer: (C) Press [Ctrl]+[+] and [Ctrl]+[-]
Q9. What is the propose to a sub datasheet?
(A) To provide a hierarchical view of related tables or queries in a single window
(B) To display grouped data in a report
(C) To display summarized data
(D) All of the above
Answer: (A) To provide a hierarchical view of related tables or
Q10. When adding an image, which size mode will change the height or width of the image fit the control?
(A) Clip
(B) Stretch
(C) Zoom
(D) Crop
Answer: (B) Stretch
Q11. What is the name of the visual basic editor utility that allows you to view the Microsoft Access type library’s available objects and members?
(A) Object viewer
(B) Object browser
(C) Type library spy
(D) None of above
Answer: (B) Object browser
Q12. Primary key is
(A) Uniquely identifies each record
(B) Cannot be repeated
(C) AutoNumber is example of Primary key
(D) All of the above
Answer: (D) All of the above
Q13. __ is the clear leader for personal databases.
(A) Microsoft Access
(B) Microsoft FoxProv
(C) Borland dBase
(D) MySQL
Answer: (A) Microsoft Access
Q14. Query design window has two parts. The upper part shows
(A) Name of fields, field type and size
(B) Tables with fields and relationships between tables
(C) Criteria
(D) Sorting check boxes
Answer: (B) Tables with fields and relationships between tables
Q15. Which of the following types of joins displays records with the same value in the common field?
(A) Inner join
(B) Left outer join
(C) Right outer join
(D) Self join
Answer: (A) Inner join
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.