Solved Microsoft Access (Office Applications) MCQs:

Microsoft Access MCQs for Competitive Exams

Practice with answers, explanations, and exam-focused revision notes.

226 MCQs Page 22

Topic Notes: Microsoft Access

These notes summarize the key preparation context before you attempt the MCQs. Review the topic focus, then practice the questions below with answers and explanations.

Quick Overview

Microsoft Access MCQs in Computer Science - IT are useful for candidates who need targeted practice for CSS, PMS, FPSC, PPSC, NTS, entry tests, and other competitive exams in Pakistan. This topic page is designed for quick revision, repeated practice, and exam-focused preparation.

Attempt the questions page by page, check the correct answers, read the explanations where available, and compare your weak areas with past papers and mock test performance. Consistent MCQ practice improves speed, confidence, and retention for objective exam sections.

Want adaptive tracking for this topic?

Session Progress 0 / 0 Solved

Reveal answers to start tracking your session progress!

211

Which of the following is NOT one of the four main types of database objects in Access?

Tables

Queries

Modules

Spreadsheets

Report

212

The "Property Sheet" is a pane that allows you to:

View and modify the detailed settings and characteristics of an object or a control

Change your Access user password

See a list of all tables in the database

Check the spelling of the data

Report

213

A "Subform" or "Subreport" is an object that is:

A smaller copy of a main form or report

A form or report that is inserted into another "main" form or report to show related data

A form or report that has been deleted

A form or report that can only be viewed in Design View

Report

214

What is the purpose of setting a "Data Type" for a field in a table?

To specify the color of the text in that field

To determine what kind of data can be stored in the field (e.g., text, number, date)

To create a report based on that field

To set the width of the column in Datasheet View

Report

215

To create a new table, query, form, or report, you would primarily use the commands on which tab of the Ribbon?

Home

Create

External Data

Database Tools

Report

216

The Ribbon in Access is the:

Panel on the left that shows all database objects

Toolbar at the top of the window containing tabs like "Home," "Create," and "External Data"

Area at the bottom of the window showing the current record number

The main workspace where you see your data

Report

217

Which view displays the data in a table in a row-and-column format similar to a spreadsheet?

Datasheet View

Design View

Form View

Print Preview

Report

218

Which view is used to define the structure of a table, including field names, data types, and properties?

Datasheet View

Layout View

Design View

Report View

Report

219

In Access, a row in a table represents a __________, and a column represents a __________.

Field, Record

Record, Field

Query, Form

Table, Report

Report

220

The main panel on the left side of the Access window that lists all your database objects is called the:

Ribbon

Property Sheet

Navigation Pane

Status Bar

Report

Microsoft Access MCQs for Competitive Exams

Microsoft Access MCQs for Competitive Exams

Topic Notes: Microsoft Access

Quick Overview

Browse categories

Mock Test

Latest Menu

Popular Categories