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 .

Cascade delete option

A) is used to delete all the records of all tables in a database B) will repeat the recent delete operation to all the records of current table C) is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted D) None of above

Discuss

Answer & Solution

Answer: Option C

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

Which object is used to create a form?

A) Tables and Queries B) Tables only C) Tables and reports D) Queries and reports

Discuss

Answer & Solution

Answer: Option A

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

In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.

A) formula B) format C) layout D) record

Discuss

Answer & Solution

Answer: Option D

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

After right click the field selector button, which do you choose to delete a field in design view?

A) Delete field B) delete rows C) remove field D) remove rows

Discuss

Answer & Solution

Answer: Option B

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

Which of the following statements about option group is incorrect?

A) It is a control object. B) It is bound to two fields. C) It is a control to identify a choice. D) It contains a set of controls representing choices.

Discuss

Answer & Solution

Answer: Option B

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

The two form layout types will display multiple records at one time are tabular and___

A) columnar B) justified C) date sheet D) pivot table

Discuss

Answer & Solution

Answer: Option B

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

Which of the following queries modifies fields not records?

A) Append B) Delete C) Make-Table D) Update

Discuss

Answer & Solution

Answer: Option D

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

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

Discuss

Answer & Solution

Answer: Option B

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

Which leads you through the process of creating a table?

A) wizard B) assistant C) relation D) coach

Discuss

Answer & Solution

Answer: Option A

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

To create primary key for a table when in design view

A) Type PRIMARY in field type box when creating required field B) Mark the Primary check box in field name of required field C) Click the Primary Key button in Design ribbon when the cursor is in required field D) None of the above

Discuss

Answer & Solution

Answer: Option C

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