Access 2013

Quiz

Question 1

Name a characteristic of a relational database.

A. It’s bad at handling non-numerical data

B. It understands how your information is connected

C. It uses a single table to store your data

Question 2

Which of the following is a complete list of the Access objects?

A. Tables, forms, queries

B. Queries, reports, forms

C. Records, queries, reports, forms

D. Tables, forms, queries, reports

E. Records, tables, forms, queries, reports

Question 3

The __________ is a list containing every object in your database.

A. Document Tabs bar

B. Navigation pane

C. Quick Access toolbar

D. Ribbon

Question 4

In Access, rows are referred to as __________, and columns are referred to as __________.

A. records, fields

B. lines, columns

C. fields, records

D. objects, types

Question 5

__________ allow you to enter data without typing records directly into tables.

A. Filters

B. Queries

C. Forms

D. Reports

Question 6

If you want to put a list of last names into alphabetical order, you could ______ them.

A. sort

B. filter

C. report

Question 7

When you build a query, you must write __________ to tell the query which records to retrieve.

A. terms

B. tables

C. functions

D. criteria

Question 8

A __________ query allows you to perform calculations with your data.

A. super

B. sum

C. totals

D. calculator

Question 9

It's possible to build reports with information from __________.

A. tables

B. queries

C. both tables and queries

Question 10

True or False: When you select a new theme, it applies to the entire database.

A. True

B. False

Question 11

Setting the __________ for a field sets a rule about how many letters, numbers, punctuation marks, or spaces can be entered in a field.

A. data rule

B. character limit

C. row height

D. style

Question 12

A __________ is a drop-down list you can add to your form.

A. text box

B. Navigation pane

C. combo box

Question 13

__________ let your users perform common form actions with just one click.

A. Command buttons

B. Themes

C. Queries

D. Footers

Answers:

1) B. It understands how your information is connected
2) D. Tables, forms, queries, reports
3) B. Navigation pane
4) A. records, fields
5) C. Forms
6) A. sort
7) D. criteria
8) C. totals
9) C. both tables and queries
10) A. True
11) B. character limit
12) C. combo box
13) A. Command buttons