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 .

A list consists of last names, first names, address and pin codes if all people in the list have the same last and the same pin code, a useful key would be

A) The pin code B) The last name C) A compound key consisting of the first name and the last name D) All of the above

Discuss

Answer & Solution

Answer: Option C

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

__________ is used to build 'intuitive' queries.

A) SQL B) Xbase C) QBE D) XML

Discuss

Answer & Solution

Answer: Option C

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

What is the type of query that extracts data from a table and puts them into separate table?

A) Parameter query B) Make table query C) Update query D) Put table query

Discuss

Answer & Solution

Answer: Option B

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

Which of the following data types automatically generates a consecutive number?

A) Autonumber B) Memo C) Number D) Text

Discuss

Answer & Solution

Answer: Option A

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

Which of the following is invalid field name?

A) Student.Address B) Student'sAddress C) Student_Address D) Student Address

Discuss

Answer & Solution

Answer: Option A

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

Press the following keys in Access to Cancel Print Preview or Layout Preview

A) CTRL+P B) P or CTRL+P C) S D) C or ESC

Discuss

Answer & Solution

Answer: Option D

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

The filter by selection feature allows you to filter:

A) Those records that match an entity in a field B) Records based on a criterion you specify C) Records that meet any of several criteria you specify D) All of above

Discuss

Answer & Solution

Answer: Option A

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

The default and maximum size of text field in Access

A) 50 and 255 Characters B) 8 and 1 GB C) 266 characters & 64000 characters D) None of above

Discuss

Answer & Solution

Answer: Option A

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

Which of the following methods CANNOT be used to delete records from a table?

A) Selecting records and pressing [Delete] B) Pressing [Ctrl]+['] C) Clicking the Delete Record button D) From the ribbon, selecting Delete Record

Discuss

Answer & Solution

Answer: Option B

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

How can you display the related records from other tables in datasheet view?

A) Click on the expand indicator next to the record B) Double click on the record to expand it C) Apply filter by command to display related records D) All of above

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