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
