wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Microsoft Access worksheet questions

Total questions: 78

Worksheet time: 39mins

Name
Class
Date
1.

What is the primary purpose of a Microsoft Access database?

a)

To design graphic layouts

b)

To store, manage, and retrieve structured data

c)

To create multimedia presentations

d)

To write programming code

2.

Which Access object is used to store data permanently?

a)

Query

b)

Form

c)

Table

d)

Report

3.

A field in an Access table represents:

a)

A single record

b)

A column of related data

c)

A complete table

d)

A relationship between tables

4.

Which view allows you to define data types and primary keys?

a)

Datasheet View

b)

Layout View

c)

Design View

d)

Print Preview

5.

What is a primary key used for?

a)

Formatting records

b)

Sorting tables alphabetically

c)

Uniquely identifying each record

d)

Linking queries only

6.

Which data type is MOST suitable for storing currency values?

a)

Text

b)

Number

c)

Currency

d)

AutoNumber

7.

What happens if two records share the same primary key value?

a)

Access automatically merges them

b)

Access allows duplicates

c)

Access displays a validation error

d)

Access converts one to null

8.

Which object is BEST used to enter and edit data easily?

a)

Table

b)

Query

c)

Form

d)

Report

9.

A query is BEST described as:

a)

A printed summary of data

b)

A question asked about data

c)

A data storage structure

d)

A navigation menu

10.

Which query feature allows filtering records based on conditions?

a)

Sort row

b)

Criteria row

c)

Total row

d)

Field row

11.

Which operator retrieves values within a specific range?

a)

=

b)

LIKE

c)

BETWEEN

d)

<>

12.

Which wildcard is used to represent multiple characters in Access?

a)

#

b)

?

c)

*

d)

!

13.

What does the AND operator do in query criteria?

a)

Returns records that meet either condition

b)

Returns records that meet both conditions

c)

Ignores all conditions

d)

Sorts records automatically

14.

Which function allows conditional logic in queries?

a)

SUM

b)

AVG

c)

IIF

d)

COUNT

15.

A calculated field is created using:

a)

Field properties

b)

Expressions

c)

Data types

d)

Relationships

16.

Which expression calculates total cost from quantity and price?

a)

Quantity + Price

b)

Quantity & Price

c)

Quantity * Price

d)

Quantity / Price

17.

What is the purpose of a parameter query?

a)

To delete records automatically

b)

To request input from the user at runtime

c)

To format query output

d)

To join tables permanently

18.

Which object is used to present data in a printable format?

a)

Form

b)

Query

c)

Table

d)

Report

19.

Which report feature groups records logically?

a)

Sorting

b)

Filtering

c)

Grouping

d)

Indexing

20.

Which view allows modifying the structure of a report?

a)

Report View

b)

Print Preview

c)

Layout View

d)

Design View

21.

What is a relationship in Access?

a)

A calculated field

b)

A link between tables using common fields

c)

A form property

d)

A query condition

22.

Which relationship type allows many records in both tables?

a)

One-to-one

b)

One-to-many

c)

Many-to-many

d)

Primary-to-secondary

23.

Which window is used to define table relationships?

a)

Navigation Pane

b)

Datasheet View

c)

Relationships window

d)

Property Sheet

24.

What does referential integrity ensure?

a)

Faster queries

b)

Valid links between related tables

c)

Better formatting

d)

Automatic backups

25.

Which join returns only matching records from both tables?

a)

Left join

b)

Right join

c)

Inner join

d)

Outer join

26.

Which data type automatically generates unique numbers?

a)

Number

b)

Currency

c)

Text

d)

AutoNumber

27.

Which feature restricts data entry to a specific format?

a)

Default Value

b)

Validation Rule

c)

Input Mask

d)

Lookup Wizard

28.

Which property ensures a field cannot be left empty?

a)

Required

b)

Indexed

c)

Default Value

d)

Field Size

29.

What does the LIKE operator do?

a)

Matches exact values

b)

Performs mathematical comparison

c)

Searches using patterns

d)

Sorts records

30.

Which symbol represents a single character wildcard?

a)

*

b)

#

c)

?

d)

$

31.

Which query type updates existing records?

a)

Select query

b)

Crosstab query

c)

Update query

d)

Parameter query

32.

Which query type removes records permanently?

a)

Delete query

b)

Append query

c)

Select query

d)

Make-table query

33.

Which object summarizes data using rows and columns?

a)

Select query

b)

Form

c)

Crosstab query

d)

Report

34.

Which feature sorts data alphabetically or numerically?

a)

Criteria

b)

Sorting

c)

Filtering

d)

Indexing

35.

Which object can be based on both tables and queries?

a)

Table

b)

Query

c)

Form

d)

Macro

36.

What is the Navigation Pane used for?

a)

Editing records

b)

Writing expressions

c)

Managing database objects

d)

Printing reports

37.

Which Access object automates tasks?

a)

Query

b)

Macro

c)

Table

d)

Form

38.

Which object helps users navigate the database easily?

a)

Report

b)

Switchboard

c)

Table

d)

Query

39.

Which view shows live data but prevents structural changes?

a)

Design View

b)

Datasheet View

c)

Print Preview

d)

Relationship View

40.

Which PowerPoint feature ensures consistent layout, fonts, and background across all slides?

a)

Slide Sorter

b)

Slide Master

c)

Notes Page

d)

Animation Pane

41.

A user wants all slides to have the same footer and logo. Where should this be configured?

a)

Normal View

b)

Slide Layout

c)

Slide Master View

d)

Handout Master

42.

What is the MAIN advantage of using Slide Master instead of formatting slides individually?

a)

It increases file size

b)

It allows animations to run faster

c)

It ensures global consistency and saves time

d)

It improves printing quality

43.

Which view is BEST for rearranging the order of slides quickly?

a)

Normal View

b)

Notes Page View

c)

Reading View

d)

Slide Sorter View

44.

When presenting to an audience, which view displays speaker notes only to the presenter?

a)

Slide Show View

b)

Presenter View

c)

Notes Page View

d)

Outline View

45.

Which element controls how slides change from one to another?

a)

Animation

b)

Transition

46.

Applying a transition to one slide only will affect:

a)

All slides automatically

b)

Only slides with the same layout

c)

Only the selected slide

d)

The Slide Master

47.

What happens if “Apply to All” is selected for slide transitions?

a)

Only current slide changes

b)

Transitions are removed

c)

The transition applies to every slide

d)

Animations are disabled

48.

Which feature controls how objects appear, move, or disappear on a slide?

a)

Slide Transition

b)

Slide Layout

c)

Animation

d)

Theme

49.

Which animation setting makes an object appear automatically after another finishes?

a)

On Click

b)

With Previous

c)

After Previous

d)

Trigger

50.

What is the MAIN purpose of using animations carefully in presentations?

a)

To make slides longer

b)

To reduce file size

c)

To enhance clarity and audience focus

d)

To impress examiners only

51.

Which tab is used to insert charts and SmartArt?

a)

Home

b)

Design

c)

Insert

d)

Animations

52.

SmartArt is BEST used for:

a)

Writing long paragraphs

b)

Displaying structured information visually

c)

Editing video content

d)

Applying slide transitions

53.

Which chart type is MOST suitable for showing trends over time?

a)

Pie Chart

b)

Column Chart

c)

Line Chart

d)

Doughnut Chart

54.

Which PowerPoint feature allows reuse of existing slides from another presentation?

a)

Slide Master

b)

Reuse Slides

c)

Duplicate Slide

d)

Slide Library

55.

A theme in PowerPoint controls:

a)

Slide numbering only

b)

Fonts, colors, and background styles

c)

Animation speed

d)

Audio playback

56.

Changing theme colors will affect:

a)

Only the selected slide

b)

Only text boxes

c)

All slides using the theme

d)

Notes pages only

57.

Which file format preserves animations and transitions when sharing?

a)

.ppt

b)

.pptx

c)

.pdf

d)

.jpg

58.

Which feature allows adding explanations visible only to the presenter?

a)

Comments

b)

Notes Pane

c)

Slide Footer

d)

Outline View

59.

Which view is BEST for preparing printed handouts?

a)

Slide Sorter View

b)

Reading View

c)

Handout Master View

d)

Slide Master View

60.

What happens when a video is set to “Start Automatically”?

a)

It plays after clicking the slide

b)

It plays when the slide appears

c)

It plays only in edit mode

d)

It does not play during slideshow

61.

Which option ensures media files work on another computer?

a)

Compress Media

b)

Package Presentation

c)

Save As PDF

d)

Reduce File Size

62.

Which feature groups related slides visually?

a)

Sections

b)

Layouts

c)

Transitions

d)

Themes

63.

Why are sections useful in large presentations?

a)

They reduce file size

b)

They improve animation timing

c)

They help organize and manage slides

d)

They change slide orientation

64.

Which alignment option centers text vertically and horizontally?

a)

Center

b)

Middle Align

c)

Align Text

d)

Center & Middle Align

65.

Which tool helps maintain consistent spacing and alignment?

a)

Ruler

b)

Zoom

c)

Gridlines

d)

Slide Sorter

66.

Which feature highlights spelling and grammar errors?

a)

Translate

b)

Thesaurus

c)

Proofing

d)

Review Pane

67.

What is the purpose of Outline View?

a)

Viewing animations

b)

Editing slide backgrounds

c)

Focusing on slide text structure

68.

Which view is BEST for checking slide timing?

a)

Normal View

b)

Slide Sorter View

c)

Reading View

d)

Notes View

69.

Which object can be animated individually?

a)

Slide background

b)

Entire theme

c)

Text boxes, images, and shapes

d)

Notes section

70.

What does "With Previous" animation mean?

a)

It starts after the previous animation

b)

It starts at the same time as the previous animation

c)

It requires a mouse click

d)

It loops continuously

71.

Which feature allows importing data directly from Excel?

a)

Paste Special

b)

Chart Tools

c)

Insert Chart

d)

Data Link

72.

Which option is BEST to reduce presentation file size?

a)

Increase resolution

b)

Compress media

c)

Duplicate slides

d)

Add animations

73.

What happens if Slide Master formatting is changed after slides are created?

a)

Only new slides update

b)

Existing slides remain unchanged

c)

All linked slides update automatically

d)

Presentation becomes read-only

74.

Which view displays one slide at a time for delivery?

a)

Slide Sorter View

b)

Normal View

c)

Slide Show View

d)

Outline View

75.

Which feature allows adding narration?

a)

Record Slide Show

b)

Notes Pane

c)

Animation Pane

d)

Comment Tool

76.

Why should excessive animations be avoided?

a)

They increase printing cost

b)

They distract the audience

c)

They disable Slide Master

d)

They remove transitions

77.

Which command duplicates the current slide?

a)

New Slide

b)

Reuse Slides

c)

Duplicate Slide

d)

Copy Theme

78.

Which PowerPoint feature controls slide dimensions?

a)

Page Setup

b)

Slide Size

c)

Layout

d)

Orientation

Similar Resources on Wayground

WCA Stocks, Soups, and Sauces

75 questions

WCA Stocks, Soups, and Sauces

quiz

Worksheet

•

9th Grade - University

DIT Unit 4 Study Guide

76 questions

DIT Unit 4 Study Guide

quiz

Worksheet

•

6th Grade - University

True gamer

80 questions

True gamer

quiz

Worksheet

•

KG - Professional Dev...

Topic1: Green Engineering Design (ECH5955)

73 questions

Topic1: Green Engineering Design (ECH5955)

quiz

Worksheet

•

University

IT26210_MODULES 1-3

81 questions

IT26210_MODULES 1-3

quiz

Worksheet

•

University

120152151521

81 questions

120152151521

quiz

Worksheet

•

University