Microsoft Access Objective Questions and Anwsers (MCQs) | Microsoft Access Quiz Questions and Answers
Here you will find a list of common important questions on Microsoft Access (MS Access) in MCQ quiz style with answers for competitive exams and interviews.We will keep adding more questions and provide this question bank in PDF format, so that you can download them instantly in E-book style.
MS-Access Objective Questions and Anwsers (MCQs) 1-20
1. Which of the following database object is created first before any other created?
(A) Table
(B) Form
(C) Report
(D) Query
ANSWER (A) Table
2. This type of database contains multiple tables that are connected to producecombined output from all tables.
(A) Bound
(B) Linked
(C) Relational
(D) Joined
ANSWER (C) Relational
3. The ‘Filter by selection’ allows you to filter those records
(A) That match the selected field
(B) That match the criteria specified
(C) That meet any of several criteria specified
(D) All of above
ANSWER (A) That match the selected field
4. The operation of checking input data against specified criteria is known as?
(A) Data Verification
(B) Data Validation
(C) Cross Check
(D) Data Control
ANSWER (B) Data Validation
5. Some rules are set in databases to check and permit only correct values. What is
this feature called?
(A) Data Verification
(B) Auditing
(C) Data Filtering
(D) Data Validation
ANSWER (D) Data Validation
6. Database access levels are specified so as to define who can access what in a database. It is identified through
(A) User ID
(B) Password
(C) Status
(D) None of above
ANSWER (A) User ID
7. What it is called to present information in a particular order based on numeric or alphabetical value?
(A) Sorting
(B) Searching
(C) Arranging
(D) Cropping
ANSWER (A) Sorting
8. A collection of related records in database is known as a
(A) Table
(B) Database
(C) File
(D) None of above
ANSWER (C) File
9. A part of database that stores complete information about an entity such as employee, sales, orders etc.
(A) File
(B) Record
(C) Field
(D) Query
ANSWER (B) Record
10. To create this, you enter an expression in the design grid that instructs Access to perform a calculation using the current field values.
(A) Formulated field
(B) Numeric field
(C) Formula field
(D) Calculated field
ANSWER (D) Calculated field
11. The ascending order of data hierarchy is?
(A) Bit - Byte - Field - Record - File - Databse
(B) Bit - Byte - Record - Field - File - Database
(C) Byte - Bit - Field - Record - File - Database
(D) Bit - Byte - Field - Record - Database - File
ANSWER (A) Bit - Byte - Field - Record - File - Databse
12. Which of the following database object can be used if you need to mail the invoice to customers?
(A) A form
(B) A Query
(C) A report
(D) A Table
ANSWER (C) A report
13. When creating an input mask this character does not require an entry, but if an entry is made it must be a letter from A-Z
(A) ?
(B) !
(C) #
(D) \
ANSWER (A) ?
14. In Access, this displays the results of a calculation in a query
(A) Lookup field
(B) Calculated field
(C) Source field
(D) Child field
ANSWER (B) Calculated field
15. In Access, this operation copies a backup file from the storage medium back onto the computer
(A) Recreate
(B) Restore
(C) Copy
(D) Structure
ANSWER (B) Restore
16. If you make an invalid entry in the Input Mask Wizard dialog box, this will display to advise you that the entry is not correct
(A) Text error
(B) Validation error
(C) Literal error
(D) Entry error
ANSWER (B) Validation error
17. In the Form Wizard dialog box, the fields from the selected table are displayed in
this list box.
(A) All Fields
(B) All Records
(C) Available Records
(D) Available Fields
ANSWER (D) Available Fields
18. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
(A) Tabular
(B) Justified
(C) Columnar
(D) Datasheet
ANSWER (C) Columnar
19. This form displays data in a table layout with field name labels across the top of the page and the corresponding data in rows and columns under each heading.
(A) Columnar
(B) Justified
(C) Datasheet
(D) Tabular
ANSWER (D) Tabular
20. This form displays multiple records, one per row, in the Form window
(A) Datasheet
(B) Tabular
(C) Columnar
(D) Justified
ANSWER (A) Datasheet
Part 2 >>>>> Click Here
Microsoft Access Quiz Questions and Answers 21-40
21. 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
ANSWER (C) Justified
22. Which of the following is not a Form style available in the Form Wizard dialog box.
(A) Blends
(B) Standard
(C) Stone
(D) Highlights
ANSWER (D) Highlights
23. 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
ANSWER (D) Page Up
24. 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
ANSWER (B) Tables
25. 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
ANSWER (A) Crosstab
26. Which of the following is not one of the methods available in the New Query dialogbox to create queries?
(A) Design View
(B) Crosstab Query Wizard
(C) Simple Query Wizard
(D) Datasheet View
ANSWER (D) Datasheet View
27. This query wizard will create a select query.
(A) Crosstab
(B) Find Duplicates
(C) Simple
(D) Design View
ANSWER (C) Simple
28. The quickest way to add a field to the Selected Fields list is to double-click its fieldname in this list.
(A) Find Fields(B) Searh Fields
(C) Search Record
(D) Available Fields
ANSWER (D) Available Fields
29. The result of a query is displayed in a
(A) Record
(B) Query datasheet
(C) Query table
(D) Form
ANSWER (B) Query datasheet
30. Changing the order of this in the query datasheet does not affect the field order inthe table.
(A) Record
(B) Row
(C) Column
(D) Sort
ANSWER (C) Column
31. In the second Subform Wizard dialog box you specify the table to use as the datasource 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
ANSWER (C) fields from the selected table
32. This is not one of the sections of the Form Design window
(A) Form Footer
(B) Form Content
(C) Form Header
(D) Form Detail
ANSWER (B) Form Content
33. When you select this control, its associated text control is also selected and the twocontrols will act as one when manipulated.
(A) Text
(B) Form
(C) Label
(D) Field
ANSWER (B) Form
34. In Access, this view is used to create and modify the structure of a form.
(A) Normal
(B) Datasheet
(C) Form Design
(D) Control
ANSWER (C) Form Design
35. 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
ANSWER (D) Open Exclusive
36. 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
ANSWER (D) Click on the three dots to the right of the Input Mask entry field
37. 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
ANSWER (A) At the beginning of the database
38. The file extension for an Access 2003 database is
(A) EXE
(B) DOC
(C) EXC
(D) MDB
ANSWER (D) MDB
39. 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
ANSWER (C) A report that displays data grouped by fields you specify
40. 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
ANSWER (C) Both of above
Part 2 >>>>> Click Here
Conclusion:
KEYWORDS:
