MS Access MCQ Questions and solutions with explanations

Home

Competitive Exams MCQs

Aptitude English Verbal Reasoning Non Verbal Reasoning General Knowledge(GK) General Science(GS) Data Interpretation(DI) Banking Awareness Current Affairs

Computer Fundatmental MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Python AI(Artificial Intelligence)

Engineering Subjects MCQs

Computer Science Electronics & Communication Mechanical Engineering Civil Engineering Electrical Engineering

More Engineering MCQs

Chemical Engineering Automobile Engineering Biotechnology Mining Engineering Geological Engineering Metallurgical Engineering

Engineering Core

Engineering Mathematics Engineering Physics Engineering Chemistry

Computer Fundamentals MCQs

Computer Fundamentals Microsoft Word Microsoft Excel MS Power Point Tally Operating System Networking Database SQL MySQL

Programming MCQs

C Programming C++ Programming Java Python PHP JavaScript

Advanced Programming MCQs

Artificial Intelligence Machine Learning Data Science Cloud Computing Hadoop IoT

Graduation & PG

Commerce Management Law Agriculture Sociology Psychology Home Science Mass Communication Political Science Psychology

Resources

Current Affairs Interview Blog

Exam Categories

SSC Exams Railway Exams All Exams

SSC Exams

SSC CGL SSC CHSL SSC MTS SSC CPO SSC GD SSC JHT SSC Selection Post SSC Stenographer SSC JE

Railway Exams

RRB ALP RRB Technician RRB Section Controller RRB JE RRB Paramedical RRB Group D

Popular Exams

SSC CGL SSC CHSL SSC MTS RRB NTPC (Graduate) RRB Group D RRB ALP RRB Technician RRB Section Controller

Each section contains 100 MCQs on MS Access .

What happens when a user double-clicks an object in the Project pane of the Visual Basic Editor?

A) The associated code is displayed in the Code pane. B) The associated code is displayed in a new window. C) The object is deleted from the Project pane. D) The object's property sheet opens.

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?

A) Match Case B) Match: Whole Field C) Match: Start of Field D) Match: Any Part of Field

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

Which of the following database objects can have more than one Group Header/Footer section?

A) Forms B) Queries C) Reports D) Tables

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

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

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

The ______ is a wild card that represents one or more characters.

A) question mark B) asterisk C) exclamation mark D) dollar sign

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

Which control lets a user create multiple pages in a form?

A) Check box control B) Combo box control C) Option group control D) Tab control

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

In Access press to Toggle the focus forward between controls in the wizard

A) TAB B) ALT+N C) ALT+B D) ALT+F

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.

A) Design View B) Layout View C) Print Preview D) Report View

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

In Access 2007, to set a table to open as a document tab, you need to go to the ____.

A) Microsoft Office button B) Navigation Pane C) Quick Access toolbar D) Database Tools command tab

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

100

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

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

1 2 3 4 5 6 7 8 9 10

MS Access MCQ Questions and solutions with explanations | MS Office