PS Exam

  • Full Screen
  • Wide Screen
  • Narrow Screen
  • Increase font size
  • Default font size
  • Decrease font size

MS-Access : Objective Questions (MCQs) Set 6

E-mail Print PDF

Set 6

Collection of Multiple Choice Questions (MCQs) or Objective Questions from Microsoft Access (MS-Access)for Compute Jobs Exams like Computer Operator, Computer Engineer, Computer Officer and so on. 



1. In this form, a single record may appear in multiple rows in the Form window in order to fully display the field name label and data.

 A) Datasheet
 B) Tabular
 C) Justified
 D) Columnar

2. Which of the following is not a Form style available in the Form Wizard dialog box.

 A) Blends
 B) Standard
 C) Stone
 D) Highlights

3. You can move between fields in a form by using any of these keys except

 A) Tab
 B) Enter
 C) Shift+Tab
 D) Page Up

4. Queries are based on this, allowing you to use a query as the source for forms and reports

 A) Filters
 B) Tables
 C) Records
 D) Fields

5. This type of query summarizes large amounts of data in easy-to-read, row-and-column format.

 A) Crosstab
 B) Columnar
 C) Select
 D) Action

6. Which of the following is not one of the methods available in the New Query dialog box to create queries?

 A) Design View
 B) Crosstab Query Wizard
 C) Simple Query Wizard
 D) Datasheet View

7. This query wizard will create a select query.

 A) Crosstab
 B) Find Duplicates
 C) Simple
 D) Design View

8. The quickest way to add a field to the Selected Fields list is to double-click its field name in this list.

 A) Find Fields
 B) Search Fields
 C) Search Record
 D) Available Fields

9. The result of a query is displayed in a

 A) Record
 B) Query datasheet
 C) Query table
 D) Form

10. Changing the order of this in the query datasheet does not affect the field order in the table.

 A) Record
 B) Row
 C) Column
 D) Sort

11. In the second Subform Wizard dialog box you specify the table to use as the data source and the

 A) records from the selected form
 B) form from the selected table
 C) fields from the selected table
 D) content from the selected form

12. This is not one of the sections of the Form Design window

 A) Form Footer
 B) Form Content
 C) Form Header
 D) Form Detail

13. When you select this control, its associated text control is also selected and the two controls will act as one when manipulated.

 A) Text
 B) Form
 C) Label
 D) Field

14. In Access, this view is used to create and modify the structure of a form.

 A) Normal
 B) Datasheet
 C) Form Design
 D) Control

15. To set a password for the database, select ____________ in the Microsoft Access Open window.

 A) Open Read Only
 B) Open Write Only
 C) Open Explicit
 D) Open Exclusive

16. To enter the Input Mask Wizard

 A) Click on the three dots to the right of the Caption entry field
 B) Click on the three dots to the right of the Format entry field
 C) Click on the Input Mask toolbar
 D) Click on the three dots to the right of the Input Mask entry field


17. Saving a database in Access is done

 A) At the beginning of the database
 B) The first time you save data
 C) When closing the application
 D) During auto save

18. The file extension for an Access 2003 database is


19. Which of the following best describes the Grouped Report?

 A) A part of report that can be generated by the report wizard
 B) A report that displays data that has been sorted in ascending or descending order
 C) A report that displays data grouped by fields you specify
 D) None of a the above

20. 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


1-C, 2-D, 3-D, 4-B, 5-A, 6-D, 7-C, 8-D, 9-B, 10-C, 11-C, 12-B, 13-B, 14-C, 15-D, 16-D, 17-A, 18-D, 19-C, 20-C


Microsoft Access Multiple Choice Questions (MCQs) published on



Wish to get contents in your Email?

Enter your email address:

Who's Online

We have 87 guests online

Sharing Enriches!

You are here: MCQ Bank MS-Access MS-Access : Objective Questions (MCQs) Set 6