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 do you call a primary key field included in another table?

A) Foreign key B) Parent key C) Child key D) Index

Discuss

Answer & Solution

Answer: Option A

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

In access, the best types of queries to use for data analysis are:

A) Select queries B) Parameter queries C) Action queries D) All of the above

Discuss

Answer & Solution

Answer: Option A

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

What does the show check box in query design window indicate

A) It indicates whether the field is to be used or not B) It indicates whether the field is to be displayed in query result or not C) It indicates whether the field names to be displayed in query result or not D) None of above

Discuss

Answer & Solution

Answer: Option B

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

What field type is used to store picture in a table?

A) Memo B) OLE C) Hyperlink D) None

Discuss

Answer & Solution

Answer: Option B

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

In databases, Locking level is also called as

A) Granularity B) S lock C) X lock D) Dead lock

Discuss

Answer & Solution

Answer: Option A

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

To achieve AND effect when you are entering criteria in a query design window

A) write criteria values vertically one in a row B) write criteria values horizontally C) Write criteria values in same field separated with AND D) Write criteria values in same field separated with &

Discuss

Answer & Solution

Answer: Option B

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

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

Discuss

Answer & Solution

Answer: Option B

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

The command center of access file that appears when you create or open the MS Access database file.

A) Database Window B) Query Window C) Design View Window D) Switchboard

Discuss

Answer & Solution

Answer: Option A

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

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

Discuss

Answer & Solution

Answer: Option B

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

100

A(n) _______ is major object that completes an action or a set of actions.

A) event B) property C) procedure D) macro

Discuss

Answer & Solution

Answer: Option D

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