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!

Visual Basic

Enhance your knowledge of Microsoft's event-driven programming language with our...

Object Oriented Programming Using C++

Enhance your programming skills with our MCQs on Object Oriented Programming using...

R Programming

Unleash the power of statistical computing with our R Programming MCQs. Topics cover...

CompTIA PenTest+ Certification Exam PT0 002

Prepare for the CompTIA PenTest+ PT0-002 exam with our targeted MCQs. Covering...

C Programming

Master one of the most widely used programming languages with our C Programming MCQs....

Digital Logic Design

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

Python

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

Computer Architecture

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

Systems Analysis and Design Methods

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