CIS 120 Finals

A(n) _____query adds a group of records from one table to the end of another table

append

A field with the ______data type can contain an attached file, such as an image, document, chart or spreadsheet

attachment

A field with the _____data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record as added

auto-number

____ is one color shade gradually progressing to another shade of the same color or to another color.

gradient fill

____ help clarify and emphasize details, so they appeal to audience members with differing backgrounds, reading levels, attention spans, and motivations.

graphics

____ changes picture color into black, white, and shades of gray.

grayscale

By default slides in a new presentation are in______orientation

landscape

A ____ paragraph places the first character of a text line near the left border of a placeholder

left-aligned

A _____data type can store a variable amount of text and numbers where the total number of characters may exceed 255

long text

A ______field allows the user to select from a list of values

lookup

Studies show people remember at least ____ more information when the document they are seeing or reading contains visual elements.

one-third

A(n) ______ field is a field that can be computed from other feilds

calculated

when you assign a ______to a field Access will display the value you assign rather than the field name in datasheet and in forms

caption

Color ____ indicates that one color is dominating a picture.

cast

to define an additional field in datasheet view tap or click _____column heading

click to add

To include calculated fields in queries enter a name for the calculated field a______ and then the expression in one of the columns in the field row

colon (:)

The ____ gallery has a wide variety of preset formatting combinations for coloring pictures

color

Toy need to include_______ in calculations to indicate which calculation should be done first

parentheses ( )

Th box on a slide that has dotted or hatch-marked border and that contains the insertion point is a text____

placeholder

PowerPoint ____should reinforce the speaker's massage and help the audience retain the information presented

slides

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

square brackets [ ]

A ____ is a named group of formatting characteristics.

style

When you add a new slide following the title slide PowerPoint uses the _____slide layout for the new slide

title and content

The ____ introduces the presentation to the audience.

title slide

______help one slide flow gracefully into the next during a slide show

transition

____ allows you to see through the background, so that any text on the slide is visible.

transparency

to omit duplicated form a query use the property sheet and change the unique values property to_______

yes

To display the entire entry for a calculated field, select the column in the field row right-click to display the shortcut menu, and then click______

zoom

To specify that entries in the current due field must be between $0.00 and $30,000.00, enter ____in the Validation Rule property box

>=0 and <=30000

Which of the following keys can you press to run a slide show starting with slide 1

F5

To create a validation rule fro the State field to restrict entries to TN or TX, enter ____ in the validation Rule property box

T?

The_________ operator allows you to search for a range of values in the field

between

____ determines the overall lightness or darkness of an entire image.

brightness

Click ____ to move a stacked object toward the top of the stack.

bring Forward

Click ____ to move a stacked object to the top of the stack

bring to Front

Sepia changes picture colors into ____.

brown, gold, and yellow

____ is the difference between the darkest and lightest areas of an image.

contrast

Access is a__________

database management system

In a multilevel billeted list slide creating a lower-level paragraph is called _____the text

demoting

To order the records in the account table in reversse alphabetical order by City click the ___ button

descending

A___is a specific design with coordinating colors fonts, and special effects

document theme

____ effects modify text and objects displayed on the screen.

emphasis

____ effects determine how slide elements first appear on a slide.

entrance

____ effects determine how slide elements disappear.

exit

____ effects convert colors in a picture to a wide variety of hues.

recolor

A_______ contains information about a given person product or event

record

______________words are words that have special meaning to access and cannot be used for the name of fields

reserved

When a placeholder is selected, the ____ are displayed.

selection handles

The ____ command moves the selected object underneath all objects on the slide.

send to Back

A field whose data type is ______ca contain any characters

short text

To show the navigation pane if it is hidden click the ________button

shutter bar open/close