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 .

You view the properties of a form

A) Select View>Form properties form the menu B) Right click anywhere on the form and select properties from the shortcut menu C) Double click the form selector box in the upper left corner of the form D) All of the above

Discuss

Answer & Solution

Answer: Option B

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

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

Discuss

Answer & Solution

Answer: Option C

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

What is one of the advantages for using a form over other Access objects?

A) Utilizes field placement to improve the efficiency of data entry. B) Forms store information more efficiently. C) Forms show the summary of all the records. D) Forms cannot be edited.

Discuss

Answer & Solution

Answer: Option A

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

In a database table, the category of information is called __________

A) Tuple B) Field C) Record D) All of above

Discuss

Answer & Solution

Answer: Option B

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

The __________ field is used to hold a yes or no answer.

A) object B) number C) text D) logical

Discuss

Answer & Solution

Answer: Option D

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

If you write criteria values vertically (one in a row) it will mean

A) OR conditions B) AND conditions C) NOT condition D) None of above

Discuss

Answer & Solution

Answer: Option A

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

What is the process of eliminating redundant fields by separating data into tables called?

A) Renormalizations B) Filtering C) Normalization D) Sorting

Discuss

Answer & Solution

Answer: Option C

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

What is an intersection of a row and a column?

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

Discuss

Answer & Solution

Answer: Option C

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

In MS Access "Lookup Wizard" is used to

A) to select from previous values B) to select values from Excel Sheet C) to select value from another table D) Not a valid Data Type

Discuss

Answer & Solution

Answer: Option C

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

The Allow ________ property controls whether new records can be added through the form.

A) Additions B) Edits C) Deletions D) Data Entry

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