To store values that will only be either True or False, use the $\_\_\_\_\_\_\_\_$ data type.

$(1$ Point$)$

Yes$/$No

Attachment

AutoNumber

OLE Object

$2.$Which of the following query types requires two tables?

$(1$ Point$)$

find duplicates

crosstab

select

find unmatched

$3.$When a field in a query contains two criteria statements, either of which can be met to return results, this is referred to as a$($n$)\_\_\_\_\_\_\_\_$ statement.

$(1$ Point$)$

Boolean

Combination

Or

And

$4.$To display a table in Print Preview, begin by clicking

$(1$ Point$)$

the File tab.

anywhere on the table.

the Quick Print button.

the Open button.

$5.$In creating a calculated field, what symbol do you use for division?

$(1$ Point$)$

forward slash $(/)$

back slash $(\backslash )$

em dash $()$

tilde $($~$)$

$6.$When creating a calculated field, use $\_\_\_\_\_\_\_\_$ to surround the field names.

$(1$ Point$)$

back slashes $(\backslash \backslash )$

brackets $([])$

pound signs $($##$)$

braces $(\{\})$

$7.$What is the first step in creating a table?

$(1$ Point$)$

Determine the fields.

Define a primary key.

Assign a data type to each field.

Name the table.

$8.$ A database is comprised of a series of $\_\_\_\_\_\_\_\_$ used to enter, manage, view, and print data.

$(1$ Point$)$

folders

objects

files

programs

$9.$A query field that uses a mathematical equation to determine the contents that display is called a $\_\_\_\_\_\_\_\_$ field.

$(1$ Point$)$

calculated

criterion

sort

operator

$10.$In what order should the fields in your query design grid appear?

$(1$ Point$)$

text fields first, the fields with other data types

in the same order as they appear in the table from which they are drawn

in the order in which you want the to display in the query results datasheet

with all the fields containing criteria statements appearing first

$11.$Which of the following data types is automatically filled when a new record is added?

$(1$ Point$)$

AutoNumber

Hyperlink

Attachment

Lookup Wizard

$12.$When you choose Ascending in the query design grid's Sort row fields for a numeric data field, the results will be sorted

$(1$ Point$)$

lowest to highest

alphabetically, Z to A$.$

highest to lowest.

alphabetically, A to Z$.$

$13.$When a table is opened, it is sorted by

$(1$ Point$)$

the foreign key field.

the first field.

whichever field was active when the table was last closed.

the primary key field.

$14.$A database table can contain these two different types of keys.

$(1$ Point$)$

main and external

beginning and strange

primary and foreign

first and last

$15.$Up to how many characters can a field name contain?

$(1$ Point$)$

$10$

$64$

$255$

$128$

$16.$This feature contains the tabs with commands and buttons divided into groups.

$(1$ Point$)$

tabs

message bar

Quick Access Toolbar

ribbon

$17.$What data type should you use for a field that will store telephone numbers?

$(1$ Point$)$

Short Text

Yes$/$No

Number

Date & Time

$18.$When using the Find and Replace dialog box, by default Access will search in

$(1$ Point$)$

the column where the insertion point is positioned.

the entire active table.

all tables in teh database.

the first column in the table.

$19.$This object is the base upon which other objects are created.

$(1$ Point$)$

database

file

form

table

$20.$Adjust column widths in a table by $\_\_\_\_\_\_\_\_$ on one of the selected column boundaries.

$(1$ Point$)$

right$-$clicking

pressing Ctrl $+$ W

double$-$clicking

pressing the right arrow button

$21.$When creating a table, you can switch from Datasheet view to Design view by

$(1$ Point$)$

clicking the View button.

double$-$clicking the table tab.

clicking the table tab and then choosing Design view from the shortcut menu.

clicking the Property Sheet button.

$22.$What is the keyboard shortcut to display the Find and Replace dialog box with the Find Tab selected?

$(1$ Point$)$

Ctrl $+$ H

Ctrl $+$ X

Ctrl $+$ F

Ctrl $+$ C

$23.$When you delete a field in a table, what happens to the data stored in that field?

$(1$ Point$)$

It is stored in a temporary field.

It is permanently deleted.

It is stored as a separate table.

It is deleted but can be restored from the Recycle Bin

$24.$Which object displays data from a table or related tables that meets a conditional statement and$/$or performs calculations?

$(1$ Point$)$

query

report

table

form

$25.$You can extract specific information from a table or multiple tables by running $1($n$)$

$(1$ Point$)$

form.

module.

inquiry.

query.

$26.$Data in a database is organized into tables, which

$(1$ Point$)$

are used to build charts.

integrate data from other Office files.

calculate numbers between objects.

contain information for related items

$27.$Multiple criteria all entered in the same row in the query design grid is considered a$($n$)\_\_\_\_\_\_\_\_$ statement.

$(1$ Point$)$

And

Combination

Or

Mixed

$28.$What function is inserted by default when you add a total row to your table?

$(1$ Point$)$

None, you must choose one from the drop$-$down list.

Avg

Count

Sum

$29.$When creating a calculated field in a query, the field name should be separated from the equation by a$($n$)$

$(1$ Point$)$

Hyphen $(-).$

colon $($:$)$

comma $(,).$

exclamation point $(!).$