Microsoft Access 2016 Quiz

Daniel Kevins

0 comments

From the Access opening screen, you can do any of the following EXCEPT:

Question 1 options:

a)

open an existing database.

b)

create a custom web app.

c)

import a data base from Excel.

d)

create a new database from a template.

Question 2 (5 points)

On the _____________tab, in the Reports group, clicking Report allows you to easily create a report.

Question 2 options:

a)

Design

b)

Create

c)

Data

d)

Format

Question 3 (5 points)

You can group or organize ___________ using the Tables and Related Views category.

Question 3 options:

a)

fields

b)

tables

c)

information

d)

objects

Question 4 (5 points)

__________ view is the Access view in which you can view records, but you cannot change the layout or design of the form.

Question 4 options:

a)

Datasheet

b)

Form

c)

Table

d)

Datatype

Question 5 (5 points)

In the Print dialog box, under Print Range, to the right of Pages, click in the From box, type 1 and then click in the To box and type 1 and then click OK to:

Question 5 options:

a)

print the file.

b)

print the active page.

c)

print only the first page.

d)

make one copy of the page.

Question 6 (5 points)

Access formats the date and time and displays a ___________as you are entering the date.

Question 6 options:

a)

list of format choices

b)

small calendar

c)

clock

d)

table

Question 7 (5 points)

You can press either Enter or __________ to move between fields in a table.

Question 7 options:

a)

Tab

b)

Space Bar

c)

F4

d)

Ctrl+M

Question 8 (5 points)

Apply Best Fit to __________by double-clicking the right edge of any of the selected columns.

Question 8 options:

a)

one column

b)

one of the selected columns

c)

two of the selected columns

d)

all of the selected columns

Question 9 (5 points)

When data becomes___________, it is usually an indication that you need a new table to contain that information.

Question 9 options:

a)

corrupt

b)

outdated

c)

redundant

d)

cumbersome

Question 10 (5 points)

An advantage of using a __________ to create a database is that many objects, such as reports, are already designed for you.

Question 10 options:

a)

template

b)

worksheet

c)

text file

d)

document

Question 11 (5 points)

__________ view is the Access view that displays data organized in columns and rows similar to an Excel worksheet.

Question 11 options:

a)

Datasheet

b)

Datatype

c)

Layout

d)

Design

Question 12 (5 points)

When a table is__________, the table name and page number display automatically.

Question 12 options:

a)

created

b)

modified

c)

copied

d)

printed

Question 13 (5 points)

The ___________view enables you to make changes to an object, such as a report.

Question 13 options:

a)

Related

b)

Datasheet

c)

Datatype

d)

Layout

Question 14 (5 points)

One purpose of a _________is to simplify data entry.

Question 14 options:

a)

database

b)

template

c)

table

d)

form

Question 15 (5 points)

You can enter data in a newly created table using the ____________ view.

Question 15 options:

a)

Datasheet

b)

Datatype

c)

Layout

d)

Table

Question 16 (5 points)

The External Data tab allows you to import a/an ________________ to create a new table.

Question 16 options:

a)

Excel spreadsheet

b)

Word document

c)

PDF file

d)

text file

Question 17 (5 points)

You must be in _____________view to enter, view, edit, or delete a record.

Question 17 options:

a)

Form

b)

Design

c)

Records

d)

Display

Question 18 (5 points)

The ____________data type describes numbers that represent a quantity and may be used in calculations.

Question 18 options:

a)

AutoNumber

b)

Number

c)

Calculated

d)

Numerical

Question 19 (5 points)

In Microsoft Access 2016, you can create a complete ____________ from a template as provided, or that you can modify to meet your needs.

Question 19 options:

a)

database

b)

worksheet

c)

table

d)

report

Question 20 (5 points)

In the Print dialog box, under____________, clicking the Selected Record(s) option button allows you to print a single record.

Question 20 options:

a)

Select

b)

Print Record

c)

Print Range

d)

Capture
Author Image

About the Author

Daniel Kevins

Follow me

{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}