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!

Cyber Security

Understand the fundamentals of safeguarding digital assets with our Cyber Security...

JavaScript

Strengthen your web development skills with our JavaScript MCQs. Understand core...

Computer Architecture

Unveil the science behind computer design with our Computer Architecture MCQs. Topics...

Cryptography and Network Security

Secure your knowledge of information security with our Cryptography and Network...

Discrete Mathematics

Refine your mathematical skills essential for computer science with our Discrete...

Python

Dive into one of the most popular languages with our Python MCQs. Understand...

DBMS

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

C# programming

Hone your skills in the C# language with our MCQs. Understand data types, operators,...

MS Office

Master the suite of productivity tools with our MS Office MCQs. From Word and Excel...