adplus-dvertising

Welcome to the MS Access MCQs Page

Dive deep into the fascinating world of MS Access with our comprehensive set of Multiple-Choice Questions (MCQs). This page is dedicated to exploring the fundamental concepts and intricacies of MS Access, a crucial aspect of MS Office. In this section, you will encounter a diverse range of MCQs that cover various aspects of MS Access, from the basic principles to advanced topics. Each question is thoughtfully crafted to challenge your knowledge and deepen your understanding of this critical subcategory within MS Office.

frame-decoration

Check out the MCQs below to embark on an enriching journey through MS Access. Test your knowledge, expand your horizons, and solidify your grasp on this vital area of MS Office.

Note: Each MCQ comes with multiple answer choices. Select the most appropriate option and test your understanding of MS Access. You can click on an option to test your knowledge before viewing the solution for a MCQ. Happy learning!

MS Access MCQs | Page 17 of 17

Explore more Topics under MS Office

Q161.
Which of the following Data Type is used to store picture in MS Access

a.

Picture

b.

OLE Object

c.

Memo

d.

Picture cannot be stored

Discuss
Answer: (b).OLE Object
Q162.
In MS Access, which data type is appropriate to store large text and numbers?

a.

Text

b.

Memo

c.

OLE

d.

Large Text

Discuss
Answer: (b).Memo
Q163.
In MS Access, OLE Object Data type can store

a.

Microsoft Word documents

b.

Microsoft Excel spreadsheets

c.

Sounds

d.

All of the Above

Discuss
Answer: (d).All of the Above
Q164.
In MS Access, AutoNumber Data Type

a.

Can be Sequential

b.

Can be Random

c.

Can be Edited

d.

Only a and b

Discuss
Answer: (d).Only a and b
Q165.
Which of the following is use to get data from user?

a.

Query

b.

Pages

c.

Form

d.

Report

Discuss
Answer: (c).Form
Q166.
Which of the following is invalid field name?

a.

Student.Address

b.

Student’sAddress

c.

Student_Address

d.

Student Address

Discuss
Answer: (a).Student.Address
Q167.
Primary key is

a.

Uniquely identifies each record

b.

Cannot be repeated

c.

AutoNumber is example of Primary key

d.

All of the above

Discuss
Answer: (d).All of the above
Q168.
To create a table in Access

a.

Database should be created before create table

b.

Table can be created using Table Templates

c.

There must be at least one Primary key in a table

d.

All of the above

Discuss
Answer: (d).All of the above
Q169.
Which of the following is use to view or print the data in organized manner?

a.

Query

b.

Report

c.

Table

d.

Form

Discuss
Answer: (b).Report
Q170.
In a table to insert User’s Voice, Data field should be

a.

OLE Object

b.

SoundField

c.

VoiceField

d.

Memo

Discuss
Answer: (a).OLE Object
Page 17 of 17

Suggested Topics

Are you eager to expand your knowledge beyond MS Office? We've curated a selection of related categories that you might find intriguing.

Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!

Systems Analysis and Design Methods

Get familiar with the process of designing and improving business systems with our...

Software Architecture and Design

Get a strong hold on the blueprint of software systems with our Software Architecture...

Microprocessor

Understand the heart of your computer with our Microprocessor MCQs. Topics include...

Digital Logic Design

Understand the foundation of digital computers with our Digital Logic Design MCQs....

DBMS

Get a firm grasp on database systems with our DBMS MCQs. Explore relational...

Embedded Systems

Dive into the world of specialized computing systems with our Embedded Systems MCQs....

MySQL Database

Enhance your knowledge of relational databases with our MySQL MCQs. Understand...

Data Science

Discover the fascinating world of extracting insights from data with our Data Science...

Java Spring Framework

Enhance your Java development skills with our Spring Framework MCQs. Learn about...