Access/PowerPoint Test 4 Review

The maximum size of a Text data type is ___ characters.

255

The Decimal property setting for Number fields stores positive and negative nuimbers to precisely __ decimal places and uses 12 bytes.

28

It would be wasteful to use the Long Integer setting when defining a field that will only store whole numbers ranging from 0 to 255, because the Long Integer setting will use _ bytes of storage.

4

You can click the _________ button on the Query datasheet toolbar to sort records in ascending alphabetical order by values in a selected field.

Ascending

In PowerPoint, the ___________ feature automatically corrects certain words and typing errors.

AutoCorrect

Access assigns the AutoNumber as the default __ value for the primary key field when a new table is created.

ID

______ tables are separate tables but you can use the data in them as if they were one table.

Joined

In PowerPoint, you can modify the text of a slide in the _______ tab as well as the _____ ____.

Outline, Slide Pane

Queries can be created by using the _____ ______, which prompts you for the information required to build the query.

Query Wizard

In PowerPoint, _______ view displays each slide so that it almost fills the entire screen.

Reading

You can specify a name for a table after you click the ____ button on the Table Design toolbar.

Save

When using PowerPoint the _____ ____ view displays each slide so that it fills the entire screen, with no toolbars or other Windows elements visble on the screen.

Slide Show

PowerPoint allows you to rearrange the slides by using the _____ ______ view which displays all slides in the presentation as thumbnails.

Slide Sorter

PowerPoint _____ ______ are faint blue, dashed lines that appear as you drag an object near a drawn shape.

Smart Guides

____ fields can be unique or non-unique.

Sort

To make the slide show more interesting you can ___ ___________ _______ ___ ______.

add transitions between the slides

Which of the following could you be defined as a field in a database?

all of the above

A field can be described as a(n) _________.

attribute

A ______ is a grid of square colored dots that form picture on a PowerPoint slide.

bitmap

A table can be logically connected to another to another table by defining a ______ _____.

common field

Operators used in selection criteria in a query, such as equal, not equal, or greter than, are known as __________ operators.

comparison

The ____ ____ determines what field values are allowed and what other properties the field will have.

data type

You should carefully design your ________ to meet the needs of those who will use it.

database

When you first open a(n) _________, Access selects the first field value in the first record.

datasheet

When you sort a field with a Yes/No data type in __________ sort order, the no values display first, followed by the yes values.

descending

A database is a convenient way to _____, ________, and ________ related data.

enter, retrieve, maintain

When you use the number data type to define a field, you should set the field's _____ ____ property based on the largest value you except to store in that field.

field size

The content of any given field is the _____ _____.

field value

The first step in organizing data into a database is to define the ______.

fields

The options at the bottom of the AutoFormat dialog box allow you to apply the selected AutoFormat or just its ____, _____, and _____.

font, color, style

When using PowerPoint, a _______ can be a picture, shape, design, graph, chart, or diagram.

graphic

The three basic steps to creating a database, in order, are: ________ ___ __________ ______, _____ ______ __ _ _____, _____ _____ ______ ___ ____ ______.

identify the individual fields, group fields in a table, enter field values for each record

Referential _________ is a feature built in to Access to prevent data inconsistency in related tables.

integrity

In PowerPoint ________ are words or phrases that describe the clip art part of a slide.

keywords

A ____-__-___ relationship exists between two tables when one record in the first table matches zero, one, or many records in the second table.

many-to-one

In Datasheet view, the star symbol that appears in the record selector area always identifies the ____ _________ ___ ___ _ ___ ______ in the database.

next available row for a new record

In PowerPoint, a ___________ is a region of a slide reserved for inserting text or graphics.

placeholder

A field, or a combination of fields, that has a unique value is a _______ ___.

primary key

When using PowerPoint, changing a first-level bulleted item into a slide title, is called _________ the item.

promoting

A _____ is a question you ask about data stored in a database.

query

In Datasheet view, clicking a row selector selects an entire ______.

record

In PowerPoint, _______ notes help the speaker remember what to say when a particular slide appears during a presentation.

speaker

The final step in the creation of a table is to save the table _________ to disk.

structure

In PowerPoint an easy way to apply several formats at once to an object is to apply a _____ to it.

style

A _____ name must be unique within a database.

table

All the fields for a specific individual or place can be grouped together as a(n) _____.

table

A ________ is a PowerPoint file that contains a theme, sample text, and graphics to guide you as you develop your content.

template

A primary key ________ __________ ____ ______ __ _ _____.

uniquely identifies each record in a table

Range of values may be specified as selection criteria by using the _______ ...___ ________.

Between ...And operator

A query can be run at any time during the creation of the query by clicking the ____ button in the Results group on the Query Tools Design tab.

View