Microsoft Access MCQs with answers Page - 3

Here, you will find a collection of MCQ questions on Microsoft Access. Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

Q. The task of arranging data in order is called

  • (A) Sorting
  • (B) Ordering
  • (C) Shorting
  • (D) Searching

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

Q. HSAM stands for ________

  • (A) Hierarchic Standard and Method
  • (B) Hierarchic Sequential and Method
  • (C) Hierarchic Standard Access Method
  • (D) Hierarchic Sequential Access Method

A

Admin • 833K Points
Coach

Q. What is an intersection of a row and a column?

  • (A) Record
  • (B) Cell
  • (C) Cursor
  • (D) Form

A

Admin • 833K Points
Coach

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

A

Admin • 833K Points
Coach

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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.