Name: 
 

CIS 110 Test 3 (Units J-O)



True/False
Indicate whether the statement is true or false.
 

 1. 

In an Access database, the column headings in the table are called records.
 

 2. 

By using a template, you can focus on entering data instead of designing appropriate database objects.
 

 3. 

When you start working in a new database, a blank table opens in Datasheet view.
 

 4. 

To enter data in Datasheet view, you click where you want to enter a value and start typing.
 

 5. 

Just as you can apply a filter to an Excel worksheet to display only the information that you want to see, you can also apply a filter to an Access table to display only those records that meet criteria that you specify.
 

 6. 

You can use Design view instead of a Query Wizard to create a query.
 

 7. 

One advantage to setting up relationships between tables is that you can create a query that pulls fields from two or more related tables.
 

 8. 

Spotting statistical trends in a large database is usually easy.
 

 9. 

You can save reports as objects in a database, so you can open or print them anytime.
 

 10. 

You may need to resize or move controls so that all the information in the report is visible.
 

 11. 

Summaries can include statistics for the sum, average, minimum, or maximum value in any numerical field.
 

 12. 

PowerPoint includes a dedicated Notes Page view, plus two Master views for working with recurring elements within a presentation.
 

 13. 

When you create a new presentation, you need to consider how the slideshow will communicate your content.
 

 14. 

PowerPoint provides only a few themes that apply a distinctive look to the text, bullets, background colors, and graphics in a presentation.
 

 15. 

PowerPoint has dozens of built-in shapes you can use to present, highlight, or connect information, or to simply add visual interest to a slide show.
 

 16. 

You can use the Media task pane to insert media, such as photographs, sound, and movies.
 

 17. 

You can modify any picture by resizing and aligning it on the slide.
 

 18. 

You can direct PowerPoint to play a song from a CD and record your own narration for the slide show.
 

 19. 

When you want to run a presentation automatically, without manually controlling the slide progression, you can set slide calibrators and transitions in PowerPoint.
 

 20. 

The nice thing about working with linked files is the ability to update the destination file and have every linked object update automatically in the duplicated file.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 21. 

____ help database users understand what data should be entered into a particular field.
a.
Field descriptions
c.
Field properties
b.
Field names
d.
Field descriptors
 

 22. 

You can set up a ____ between two tables so that you can use the fields from both tables in a query.
a.
link
c.
relationship
b.
bridge
d.
bar
 

 23. 

When sorting more than one field, the field that is the secondary sort field, is called the ____ sort field.
a.
outside
c.
innermost
b.
outermost
d.
inside
 

 24. 

When you relate two tables, in the second table, the common field shared with the first table is called the ____ key.
a.
foreign
c.
database
b.
primary
d.
table
 

 25. 

The statistic that calculates the number of records in the database is ____.
a.
COUNT
c.
SUM
b.
AVG
d.
MIN
 

 26. 

PowerPoint contains ____ features that convert ordinary text into stunning images.
a.
graphics
c.
electronic
b.
text
d.
data
 

 27. 

You can search the Clip Organizer for clip art using ____.
a.
search objects
c.
agents
b.
keywords
d.
patterns
 

 28. 

You can open the Microsoft Clip Organizer by clicking ____ at the bottom of the Clip Art task pane.
a.
Manage Clips
c.
Organize Clip Art
b.
Organize
d.
Organize clips
 
 
nar001-1.jpg
 

 29. 

In the accompanying figure, item 3 points to the____.
a.
Insert Picture from File button
c.
Clip Art task pane
b.
Insert Media Clip button
d.
Clip Art Graphic button
 

 30. 

In the accompanying figure, item 4 points to the____ button.
a.
Insert Picture from File
c.
Insert Table
b.
Insert Media Clip
d.
Insert SmartArt Graphic
 
 
nar002-1.jpg
 

 31. 

In the accompanying figure, item 3 points to the____.
a.
crop handles
c.
picture tool
b.
editing handles
d.
inserted picture
 

 32. 

A ____ is a special effect that determines how a slide appears as it enters or leaves the screen.
a.
movement
c.
tick
b.
transition
d.
timing
 
 
nar003-1.jpg
 

 33. 

In the accompanying figure, item 8 points to the____.
a.
Effect list
c.
Entrance effect icon
b.
Mouse Icon
d.
Move Down button
 

 34. 

To create an outline, start a new document in Word, click the ____ tab on the Ribbon, then click the Outline button in the Document Views group.
a.
View
c.
Object
b.
Document
d.
Item
 
 
nar004-1.jpg
 

 35. 

In the accompanying figure, item 1 points to the____.
a.
Web page path
c.
Outline frame
b.
Web page title
d.
Full Screen frame
 

Matching
 
 
Match each item with a statement below.
a.
Module
d.
Macro
b.
Form
e.
Query
c.
Report
 

 36. 

A set of criteria (conditions) you specify to retrieve data from a database
 

 37. 

A window that lets you enter and edit information in a database one record at a time
 

 38. 

A summary of database information designed specifically for printing
 

 39. 

A named set of actions for performing a repetitive task
 

 40. 

A set of procedures programmed in Visual Basic that is stored as a unit and which adds functionality to a database
 



 
Check Your Work     Start Over