Get documents about "A Field with an Data Type Can Store a Unique Sequential Number That Access Assigns to a Record and I - PDF
W
Description
A Field with an Data Type Can Store a Unique Sequential Number That Access Assigns to a Record and Increments by 1 as Each New Record Is Added. document sample
Document Sample
Name: ________________________ Class: ___________________ Date: __________ ID: A
CTE CBA Review 3
Multiple Choice
Identify the letter of the choice that best completes the statement or answers the question.
____ 1. The term _____ describes a collection of data organized in a manner that allows access, retrieval, and use of
that data.
a. filebox c. database
b. integrated system d. database management system
____ 2. In Access, a form created with columns and rows is called a _____.
a. table c. query
b. worksheets d. form
____ 3. A field that uniquely identifies a particular record in a table is called a _____ key.
a. principal c. secondary
b. primary d. foreign
____ 4. In Access if the value 1395.5 is entered in a field that has been defined as Currency data type, such as the
Amount Paid field in the accompanying figure, then the value will display as _____.
a. $1395.50 c. $1395.5
b. $1,395.50 d. $1,395.5
____ 5. In Access, _____ view displays a single record at a time.
a. Datasheet c. Screen
b. Form d. Record
____ 6. In Access, the arrangement of data into tables and fields is called the .
a. database management system c. form
b. database structure d. query
____ 7. A is a name that identifies a field.
a. field name c. data type
b. data structure d. table
____ 8. To move from Form view to Datasheet view, click the View button arrow on the Form View toolbar and then
click _____ in the list that displays.
a. Table View c. Datasheet View
b. Multirecord View d. Worksheet View
____ 9. To use the Simple Query Wizard to create a query, select the table for the query in the Database window,
click the _____ button arrow on the toolbar, and then click Query in the list that displays.
a. Insert Object c. Add Object
b. New Object d. Create Object
1
Name: ________________________ ID: A
____ 10. Press the _____ key to move from the upper pane, where fields are defined, to the lower pane, where field
properties are defined, in the Table window.
a. F5 c. F7
b. F6 d. F8
____ 11. A field with a(n) _____ data type can store a unique sequential number that Access assigns to a record and
increments by 1 as each new record is added.
a. Sequential c. AutoNumber
b. AutoIncrement d. Automatic
____ 12. In a database, lists information about one person or thing.
a. form c. field
b. query d. record
____ 13. In a database, are objects that use data from tables and/or queries to create a presentation-quality
printout.
a. form c. query
b. report d. database
____ 14. A is a structured way to tell a database to retrieve data from one or more database tables that meet
certain criteria.
a. query c. form
b. record d. report
____ 15. The process of creating groups of records that share some common characteristics is called
.
.
a. Pairing c. Join
b. Grouping d. Sorting
____ 16. The field or fields on which records are sorted is called the .
a. Minor key c. Major key
b. Sort key d. join line
____ 17. When sorting on more than one field, the less important field is called the .
a. Minor key c. Primary sort key
b. Major key d. Sort
____ 18. In Access, a calculates a statistic for data that is grouped by two different types of
information.
a. Query c. OR Criterion
b. AND Criterion d. Crosstab Query
____ 19. When sorting on more than one field, this is the more important field .
a. Major Key c. Secondary Sort Key
b. Minor Key d. Sort
2
Name: ________________________ ID: A
____ 20. In Access, a is a field in which a computation is performed.
a. Aggregate Function c. Join Line
b. Sort Field d. Calculated Field
____ 21. In Access, a condition in which either individual criterion must be true is called .
a. AND Criterion c. Calculated Field
b. OR Criterion d. Comparison Operator
____ 22. To create a parameter query, enter a parameter rather than a specific value as a criterion in the design grid.
The parameter must be enclosed in _____.
a. parentheses ( ) c. braces { }
b. brackets [ ] d. single quotes ‘ ’
____ 23. An is a wildcard character that represents a collection of any characters.
a. Asterisk c. Comma
b. Question Mark d. Criteria
____ 24. In Access, the wildcard that represents an individual character is called a(n) .
a. Asterisk c. Quotation Mark
b. Question Mark d. Comma
____ 25. In Access, the query allows you to quantify the results.
a. Select c. Top Value
b. Crosstab d. Parameter
____ 26. Microsoft PowerPoint is a complete _____ program that allows you to produce professional looking slide
shows.
a. personal information management c. presentation graphics
b. spreadsheet d. database
____ 27. All of the following are PowerPoint features except _____.
a. outlining c. Web support
b. database management d. charting
____ 28. The _____ feature in PowerPoint allows you to create bulleted lists, find and replace text, combine words
and images, and use multiple fonts and type sizes.
a. drawing c. inserting multimedia
b. word processing d. using Wizards
3
Name: ________________________ ID: A
____ 29. In the accompanying figure, the _____, displayed on the right side of the screen, is a separate window that
enables users to carry out some PowerPoint activities more efficiently.
a. presentation window c. outline wizard
b. design template d. task pane
____ 30. Two toolbars display on the same row in the accompanying figure but, to allow for more efficient use of the
buttons, the toolbars should appear _____.
a. on two separate rows instead of on a single row
b. on a single vertical bar instead of on a single horizontal bar
c. in the task pane
d. nowhere; they should be hidden
____ 31. A(n) _____ is a particular value for a variable that PowerPoint assigns initially.
a. default setting c. design template
b. view d. attribute
____ 32. When you start PowerPoint, the default slide layout is _____, where the slide width is greater than its height.
a. portrait orientation c. landscape orientation
b. slide pane d. outline tab
____ 33. _____ fills the entire screen and allows the slide show to be seen just as the audience will view it.
a. Slide show view c. Normal view
b. Slide sorter view d. Outline view
____ 34. A menu is a list of _____.
a. attributes c. HTML terms
b. slide layouts d. commands
4
Name: ________________________ ID: A
____ 35. To push a paragraph down to a lower level, click the _____ button on the Formatting toolbar.
a. Increase Indent c. Move Up
b. Decrease Indent d. Move Down
____ 36. To raise a paragraph from a lower level to a higher level, click the _____ button on the Formatting toolbar.
a. Increase Indent c. Move Up
b. Decrease Indent d. Move Down
____ 37. A(n) _____ is available in PowerPoint to add special words such as proper names, cities, and acronyms to a
presentation, so that they will not be marked as spelling errors.
a. database dictionary c. custom dictionary
b. alternate dictionary d. AutoCorrect dictionary
____ 38. To check a presentation for spelling errors, click the _____ button on the Standard toolbar.
a. Error Checker c. Style Checker
b. AutoCorrect d. Spelling
____ 39. The first printing of a presentation, called a _____, allows you to check the presentation for errors and
readability.
a. hard copy c. task pane
b. printout d. rough draft
____ 40. In the Outline tab, PowerPoint creates a presentation as you type the outline, by evaluating the outline
structure and displaying _____.
a. suggestions as to what to say next c. spelling and grammar corrections
b. a miniature view of the current slide d. all of the above
____ 41. An outline is a summary of thoughts, presented as _____.
a. outlines and sublines c. headers and footers
b. headings and subheadings d. all of the above
____ 42. PowerPoint can produce slides from an outline created in Microsoft Word, if the outline is saved as a(n)
_____.
a. RTF file or plain text file c. BMP file or JPG file
b. template d. wizard
____ 43. When you add a new slide in normal view, PowerPoint defaults to a Text slide layout with _____.
a. a bulleted list
b. placeholders for at least three graphics items
c. room for no more than three lines of text
d. a clip art placeholder
____ 44. One way to add a new slide on the Outline tab is to put a paragraph on the first level by clicking the _____ on
the Outlining toolbar until the paragraph is displayed at the first level.
a. Move Up button c. Promote button
b. Enhance button d. Increase Level button
____ 45. The 7 x 7 rule recommends that each line should have a maximum of seven words, and each slide should
have a maximum of _____ lines.
a. fourteen
b. forty-nine
c. seven
d. there is no maximum; a slide can have as many lines as necessary
5
Name: ________________________ ID: A
____ 46. Professional speakers design the closing slide of a presentation using _____.
a. a memorable illustration or example to make a point
b. an appeal to the emotions
c. a summary of the main point of the presentation
d. any or all of the above
____ 47. It is wise to save a presentation _____.
a. before starting a presentation c. after exiting PowerPoint
b. rarely, so as not to waste time d. frequently
____ 48. _____, which is the current view in the accompanying figure, displays several slides at one time, which is
why it is the best view to use to evaluate a presentation for content, organization, and overall appearance.
a. The Outline tab c. Slide sorter view
b. Normal view d. Slide show view
____ 49. Slide layouts have _____ arranged in various configurations for containing text or visual content.
a. graphs c. placeholders
b. icons d. outlines
____ 50. PowerPoint lets a user put _____ in placeholders.
a. charts c. clip art
b. tables d. all of the above
____ 51. Clip art images have one or more _____, associated with the entities, activities, labels, and emotions
displayed in the image, which help a user locate the desired clip.
a. handles c. keywords
b. indexes d. any or all of the above
6
Name: ________________________ ID: A
____ 52. PowerPoint will provide a placeholder for two clips displayed vertically on the left side of the slide if you
select the _____ slide layout.
a. Title, 2 Content and Text c. Title, Text and 2 Content
b. Title, Text and Content d. Title, Content and Text
____ 53. A printout of the presentation _____ often is used as an audience handout.
a. title c. graphics
b. outline d. references
____ 54. A header or a footer may contain _____.
a. the presenter’s name c. the slide or page number
b. the current date and time d. all of the above
____ 55. PowerPoint groups its preset animation schemes into three categories: _____.
a. Black-and-white, Grey tone, and Colored
b. Subtle, Moderate, and Exciting
c. Beginner, Intermediate, and Advanced
d. Large, Medium, and Small
7
ID: A
CTE CBA Review 3
Answer Section
MULTIPLE CHOICE
1. ANS: C PTS: 1
2. ANS: A PTS: 1
3. ANS: B PTS: 1
4. ANS: B PTS: 1
5. ANS: B PTS: 1
6. ANS: B PTS: 1
7. ANS: A PTS: 1
8. ANS: C PTS: 1
9. ANS: B PTS: 1
10. ANS: B PTS: 1
11. ANS: C PTS: 1
12. ANS: D PTS: 1
13. ANS: B PTS: 1
14. ANS: A PTS: 1
15. ANS: B PTS: 1
16. ANS: B PTS: 1
17. ANS: A PTS: 1
18. ANS: D PTS: 1
19. ANS: A PTS: 1
20. ANS: D PTS: 1
21. ANS: B PTS: 1
22. ANS: B PTS: 1
23. ANS: A PTS: 1
24. ANS: B PTS: 1
25. ANS: C PTS: 1
26. ANS: C PTS: 1 REF: PPT 4
27. ANS: B PTS: 1 REF: PPT 4
28. ANS: B PTS: 1 REF: PPT 4
29. ANS: D PTS: 1 REF: PPT 8
30. ANS: A PTS: 1 REF: PPT 8
31. ANS: A PTS: 1 REF: PPT 11
32. ANS: C PTS: 1 REF: PPT 11
33. ANS: A PTS: 1 REF: PPT 11
34. ANS: D PTS: 1 REF: PPT 13
35. ANS: A PTS: 1 REF: PPT 34
36. ANS: B PTS: 1 REF: PPT 34
37. ANS: C PTS: 1 REF: PPT 53
38. ANS: D PTS: 1 REF: PPT 54
39. ANS: D PTS: 1 REF: PPT 59
1
ID: A
40. ANS: B PTS: 1 REF: PPT 84
41. ANS: B PTS: 1 REF: PPT 85
42. ANS: A PTS: 1 REF: PPT 87
43. ANS: A PTS: 1 REF: PPT 89
44. ANS: C PTS: 1 REF: PPT 89
45. ANS: C PTS: 1 REF: PPT 91
46. ANS: D PTS: 1 REF: PPT 93
47. ANS: D PTS: 1 REF: PPT 94
48. ANS: C PTS: 1 REF: PPT 95
49. ANS: C PTS: 1 REF: PPT 97
50. ANS: D PTS: 1 REF: PPT 97
51. ANS: C PTS: 1 REF: PPT 100
52. ANS: A PTS: 1 REF: PPT 102
53. ANS: B PTS: 1 REF: PPT 112
54. ANS: D PTS: 1 REF: PPT 112
55. ANS: B PTS: 1 REF: PPT 114
2
