Microsoft Access MCQs with answers Page - 3

Dear candidates you will find MCQ questions of Microsoft Access here. Learn these questions and prepare yourself for coming examinations and interviews. You can check the right answer of any question by clicking on any option or by clicking view answer button.
Share your questions by clicking Add Question

📊 Microsoft Access
Q. To achieve AND effect when you are entering criteria in a query design window
  • (A) Write criteria values in same field separated with &
  • (B) Write criteria values in same field separated with AND
  • (C) Write criteria values horizontally
  • (D) Write criteria values vertically one in a row
💬 Discuss
✅ Correct Answer: (C) Write criteria values horizontally
📊 Microsoft Access
Q. We can remove a relationship defined between two tables by
  • (A) From Edit menu choose Delete Relationship
  • (B) Select the relationship line and press Delete
  • (C) Choose Delete option from Relationship menu
  • (D) All of the above
💬 Discuss
✅ Correct Answer: (B) Select the relationship line and press Delete
📊 Microsoft Access
Q. Which of the following statement is true?
  • (A) Reports and forms are similar but forms are use to print but reports to display on screen only
  • (B) Queries can include calculated fields that do not exist in table
  • (C) Queries can be printed in well formatted manner and presented as the information
  • (D) Reports can be used to retrieve data from tables and calculate
💬 Discuss
✅ Correct Answer: (B) Queries can include calculated fields that do not exist in table
📊 Microsoft Access
Q. DCL provides commands to perform actions like
  • (A) Change the structure of tables
  • (B) Insert, update or delete records and data values
  • (C) Authorizing access and other control over database
  • (D) None of above
💬 Discuss
✅ Correct Answer: (C) Authorizing access and other control over database
📊 Microsoft Access
Q. The task of arranging data in order is called
  • (A) Sorting
  • (B) Ordering
  • (C) Shorting
  • (D) Searching
💬 Discuss
✅ Correct Answer: (A) Sorting
📊 Microsoft Access
Q. Every table in relational database contain a field or combination of fields that can uniquely identify each records, it is called
  • (A) Foreign key
  • (B) Native key
  • (C) Primary key
  • (D) Composite key
💬 Discuss
✅ Correct Answer: (C) Primary key
📊 Microsoft Access
Q. HSAM stands for ________
  • (A) Hierarchic Standard and Method
  • (B) Hierarchic Sequential and Method
  • (C) Hierarchic Standard Access Method
  • (D) Hierarchic Sequential Access Method
💬 Discuss
✅ Correct Answer: (D) Hierarchic Sequential Access Method
📊 Microsoft Access
Q. What is an intersection of a row and a column?
  • (A) Record
  • (B) Cell
  • (C) Cursor
  • (D) Form
💬 Discuss
✅ Correct Answer: (B) Cell
📊 Microsoft Access
Q. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?
  • (A) Can’t sort by multiple fields
  • (B) zipcode, lastname, firstname
  • (C) firstname, lastname, zipcode
  • (D) zipcode, firstname, lastname
💬 Discuss
✅ Correct Answer: (B) zipcode, lastname, firstname
📊 Microsoft Access
Q. In an application created using the database wizard, the main menu is presented as a:
  • (A) Query, called a menu
  • (B) Table, called a switchboard
  • (C) Report, called a menu
  • (D) Form, called a switchboard
💬 Discuss
✅ Correct Answer: (D) Form, called a switchboard

Programming Categories

📱 Download Our App

Learn MCQs on the go with our easy-to-use Android app

Get it on Google Play