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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

Q. The task of arranging data in order is called

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K Points
Coach 

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

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

R

Ram Sharma • 193.86K 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

R

Ram Sharma • 193.86K 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

Download our easy to use, user friendly Android App from Play Store. And learn MCQs with one click.

Image

Login

Forgot username? click here

Forgot password? Click here

Don't have account? Register here.