wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Access Mod 1 Q2

Total questions: 40

Worksheet time: 20mins

Name
Class
Date
1.

To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.

a)

Change Column

b)

Rename Column

c)

Change Field

d)

Rename Field

2.

To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency.

a)

Field Size

b)

Format

c)

Caption

d)

Description

3.

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu

a)

Insert Column

b)

Insert Field

c)

Add Column

d)

Add Field

4.

To add a record to a table, tap or click the ____ record button.

a)

Add New

b)

New (Blank)

c)

Last

d)

Insert (New)

5.

You can place an insertion point by tapping or clicking in the field or by pressing ____.

a)

F2

b)

F3

c)

F4

d)

F5

6.

To delete a record, tap or click the record selector for the record, and then press the ____ key(s).

a)

CTRL+DELETE

b)

CTRL + Y

c)

DELETE

d)

CTRL + K

7.

To specify AutoCorrect rules and exceptions to the rules, tap or click FILE to open the Backstage view, tap or click ____ , and then tap or click Proofing in the dialog box that displays.

a)

Customize

b)

Manage

c)

Options

d)

Grammar

8.

To save the changes to the layout of a table, tap or click the Save button on the ____.

a)

status bar

b)

TABLE TOOLS tab

c)

Navigation Pane

d)

Quick Access Toolbar

9.

To import data to a table, tap or click the ____ tab on the ribbon.

a)

Database tools

b)

File

c)

External data

d)

Import

10.

To open the Navigation Pane, tap or click the ____ Button.

a)

Open Navigation Pane

b)

Open Pane

c)

Shutter Bar Open/Close

d)

Navigation Bar Show/Hide

11.

To view the results of a saved query, press and hold or right-click the query in the Navigation Pane and tap or click ____ on the shortcut menu.

a)

Datasheet View

b)

Open

c)

Results View

d)

Run

12.

To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.

a)

Open

b)

SQL

c)

Query Window

d)

Design View

13.

To back up the database that is currently open, use the ____ command on the Save As tab in the Backstage view.

a)

Close and Back Up

b)

Back Up Current

c)

Save As Back Up

d)

Back Up Database

14.

To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.

a)

Restore

b)

Fix

c)

Compaction

d)

Compact & Repair

15.

To delete a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

a)

Erase

b)

Trash

c)

Delete

d)

Remove

16.

To rename a database object, press and hold or right-click the object in the Navigation Pane and then tap or click ____ on the shortcut menu.

a)

New Name

b)

Redefine

c)

Rename

d)

Save Name

17.

A(n)____________________ is software that can be used to create a database; add, change, and delete data in the database; ask and answer questions concerning the data in the database; and create forms and reports using the data.

a)

database management system

b)

human resource management system

c)

learning management system

d)

word processing

18.

The rows in the tables are called ____________________.

a)

fields

b)

files

c)

records

d)

views

19.

A(n) ____________________ contains a specific piece of information within a record.

a)

file

b)

field

c)

column

d)

row

20.

The ____________________ data type in Access is referred to as Money in SQL Server.

a)

Short Text

b)

Long Text

c)

Currency

d)

Primary Key

21.

____________________ view has more functionality for creating a table than Datasheet view.

a)

Layout

b)

Normal

c)

Report

d)

Design

22.

To define an additional field in Datasheet view, tap or click the ____________________ column heading, select the data type, and then type the field name.

a)

Click To Add

b)

INSERT

c)

HOME

d)

Design Query

23.

To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____________________ on the shortcut menu.

a)

Insert Field

b)

Delete Field

c)

Hide Fields

d)

Freeze Fields

24.

Society encourages users to contribute to ____________________ computing, which involves reducing the electricity consumed and environmental waste generated when using computers, mobile devices, and related technologies.

a)

digital

b)

green

c)

personal

d)

recycle

25.

A hard copy or ____________________ is information that exists on a physical medium such as paper.

a)

printout

b)

documented

c)

formatted

d)

webpage

26.

____________________ refers to the process of determining the tables and fields that make up the database.

a)

File, New

b)

Pre-Planning

c)

Database design

d)

Formatting

27.

The determination of database requirements is part of a process known as ____________________.

a)

data mining

b)

programming

c)

requirements gathering

d)

system analysis

28.

Designing to omit ____________________ will help to produce good and valid database designs.

a)

redundancy

b)

primary keys

c)

errors

d)

size

29.

To create a new query in Design view, click CREATE on the ribbon to display the CREATE tab and then click the ____ button to create a new query

a)

Query

b)

Design View

c)

Query Design

d)

Select Query

30.

To save a query, click the Save button on the ____.

a)

Status Bar

b)

Quick Access Toolbar

c)

CREATE tab on the ribbon

d)

HOME tab on the ribbon

31.

To view the results of a query, open it by right-clicking the query in the Navigation Pane and clicking ____ on the shortcut menu.

a)

Datasheet View

b)

Design View

c)

Open

d)

Run

32.

To change the design of a query that is not currently open, right-click the query and then click ____ on the shortcut menu.

a)

Datasheet View

b)

Layout View

c)

Change View

d)

Design View

33.

To print the results of a query that is open, click FILE on the ribbon, click the ____ tab in the Backstage view, and then click Quick Print.

a)

Preview

b)

Print

c)

Query

d)

Print Query

34.

To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid. The parameter must be enclosed in ____.

a)

curly braces { }

b)

square brackets [ ]

c)

parentheses ( )

d)

single quotes ‘’

35.

To view the results of a query, right-click the query in the Navigation Pane and then click ____ on the shortcut menu.

a)

Use Parameter

b)

Enter Values

c)

Open

d)

Run

36.

Less than (<), greater than (>), and NOT (not equal to) are examples of ____.

a)

compound conditions

b)

comparison operators

c)

compound values

d)

conditions

37.

The ____ operator allows you to search for a range of values in one field.

a)

BETWEEN

b)

RANGE

c)

IN

d)

SEARCH

38.

To order the records in the answer to a query in a particular way, you ____ the records.

a)

index

b)

sort

c)

arrange

d)

list

39.

To sort records in a query, specify the sort order in the ____ row of the design grid below the field that is the sort key.

a)

Show

b)

List

c)

Sort

d)

Order

40.

To omit duplicates from a query, use the property sheet and change the Unique Values property to ____.

a)

No

b)

Yes

c)

Off

d)

On