BCIS II Fall Review - Word, Acccess, Powerpoint and Publisher

Name:

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

More than one person can be entering, updating, and using an Access database at the same time.

Tables contain all of the data in the database.

Field names appear in the top row of a datasheet.

You can move datasheet columns by dragging the field name left or right.

Once you have created and named a field, you cannot resize the width of the field in a datasheet.

Forms can be used to enter and edit data.

In the figure above, item 4 points to option button controls.

PowerPoint presentations can be displayed over the Internet.

PowerPoint accepts information in the form of files from a variety of sources, such as Microsoft Access.

10.

Once you create a slide show, its not that easy to rearrange things so you should plan your presentation ahead of time.

11.

To place the item marked 1 in the above figure, you need to right-click the image, and then click Insert.

12.

Clicking item 2 in the above figure opens the Microsoft Clip Organizer.

13.

A connector tool connects shapes with a line or arrow.

14.

To add placeholders to a custom slide layout, you must draw the placeholders on the slide where you want them.

15.

An organizational chart graphically illustrates the management structure of an organization.

16.

The Microsoft Clip Organizer includes sounds that you can insert into a presentation.

17.

An action button can link you to an Internet address on the Web.

18.

A text box must be selected before you can modify it.

19.

Spelling Checker is only available if a text box is selected.

20.

Creative deletion is the skill of removing or replacing distracting elements from a publication.

21.

Item 3 in the above figure is used to insert a Design Gallery object.

22.

Use item 2 in the above figure to insert a frame for text.

Case

Mrs. Boudreau teaches kindergarten and wants to set up a newsletter to send home to her students’ parents. She wants to make sure the newsletter is balanced and professional.

23.

Mrs. Boudreau should use bullets to format the list of school supplies each student will need.

24.

The Copy and Paste buttons are located on the Objects toolbar.

25.

When you crop an image, the trimmed parts of the image are permanently deleted.

26.

You can browse and download clip art online if you are connected to the Internet.

27.

To select multiple objects, press and hold [Shift] while you click them.

28.

In the above figure, the difference between the objects labeled 1 is that the second image has been resized.

29.

In the above figure, the difference between the objects labeled 3 is that the second image has been filled.

30.

When you place the pointer over a style name in the Pick formatting to apply list, the attributes of the style display.

31.

Styles are difficult to modify; it is easier to create a new style and define it.

32.

When text is justified, it appears balanced between the left and right margins.

33.

You can apply different column settings to different pages in a publication.

34.

The default font for a drop cap is the same as the font in the story.

35.

In the above figure, the text is reversed.

36.

In the above figure, item 4 appears when a text box is connected.

37.

A publication cannot have too many graphics, since this is what makes a publication interesting.

38.

Elements that do not support a publications message should be altered or deleted.

39.

Mastheads appear on every page of a publication.

40.

When designing publications, art work and text are considered independently of each other.

41.

It should be easy for the reader to connect the text elements with the artwork in a publication.

42.

The types of elements used are more important than the way the elements are arranged on the page.

43.

In the above figure, item 2 is used to align objects.

44.

In the above figure, item 3 is used to align text.

45.

When you copy text, you retype it in a new location.

46.

Mail Merge can be used to create form letters and mailing labels.

47.

The insertion point is the blinking vertical line in the document window.

48.

The Quick Access toolbar can be modified to display the commands you use most frequently.

49.

Before deleting, editing, or formatting text, you must select the text.

50.

As you type in Word, the insertion point automatically moves to the next line of the document when you reach the right margin.

51.

You can select text and then drag it to a new location using the mouse.

52.

The last item copied from a document is stored on the system Clipboard.

53.

The last item you cut or copy from a document is added to both the Office Clipboard and the system Clipboard.

54.

The Word picture editing features give you the power to enhance the color of photographs and clip art and create interesting visual effects.

55.

In the above figure, item 2 indicates a picture that cannot be altered.

56.

In the above figure, the object indicated by item 3 has been sent behind surrounding objects.

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

57.

Microsoft Office Access can best be described as ____ software.

a.	Spreadsheet	c.	Database
b.	Presentation	d.	Systems

58.

Which is NOT a feature of Access reports?

a.	Multiple headers
b.	Multiple footers
c.	Calculations on groups of records
d.	The ability to enter data through a data entry screen

59.

Which of the following is NOT a way to open Access?

a.	From the Start menu	c.	From My Computer
b.	From Internet Explorer	d.	From a shortcut on the desktop

60.

A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.

a.	Object	c.	Field
b.	Record	d.	Table

61.

A group of related fields, such as all the demographic information for one customer, is called a(n) ____.

a.	Record	c.	Database
b.	Table	d.	Object

62.

A collection of records for a single subject, such as all of the customer records, is called a(n) ____.

a.	Table	c.	Element
b.	Control	d.	Object

63.

The term ____ database comes from the fact that two or more tables are linked by a common field.

a.	Hierarchical	c.	Schematic
b.	Network	d.	Relational

64.

This Access object provides an easy-to-use data entry screen.

a.	Macro	c.	Table
b.	Form	d.	Module

65.

Which of the following is not a Data Type?

a.	Number	c.	Date/Time
b.	Formula	d.	Text

66.

This control is used to display "yes" or "no" answers for a field.

a.	Check box	c.	Combo box
b.	List box	d.	Option box

67.

This control displays a list of possible data entries from which the user can choose.

a.	Label	c.	List box
b.	Text box	d.	Tab control

68.

In the figure above, item 2 points to ____.

a.	option buttons	c.	combo boxes
b.	labels	d.	list boxes

69.

In the figure above, item 4 points to a(n) ____.

a.	option button	c.	command button
b.	option group	d.	New record button

70.

In the figure above, item 5 points to a(n) ____.

a.	combo box	c.	option button
b.	record navigation button	d.	text box

71.

In the figure above, item 8 points to the ____.

a.	field names	c.	selections
b.	properties	d.	toolboxes

72.

In the figure above, item 7 points to the ____.

a.	Field List button	c.	vertical ruler
b.	Ascending button	d.	Descending button

73.

Which of the following would most likely be used to display a Yes/No field on a form?

a.	Check box	c.	Combo box
b.	Command button	d.	Label

74.

Which of the following items can you import into a presentation?

a.	digital images	c.	text
b.	numerical data	d.	All of the above

75.

Which of the following is an exception to copyright protection?

a.	copyright infringement	c.	fair use
b.	cyberlaw	d.	intellectual property

76.

Each set of primary commands is organized by a(n) ____?

a.	ribbon	c.	tab
b.	group	d.	toolbar

77.

With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as ____.

a.	Microsoft Word	c.	Microsoft Access
b.	Microsoft Excel	d.	All of the above

Figure A-1

78.

Item 1 in the figure above is a(n)____.

a.	a first level bullet	c.	second-level bullet
b.	top-level bullet	d.	none of the above

79.

Item 2 in the above figure ____.

a.	could be changed to a first-level bullet	c.	is a second-level bullet
b.	could be further indented	d.	all of the above

80.

Item 3 in the figure above is a(n) ____.

a.	thumbnail of slide 2	c.	is applied to slide 2
b.	design theme	d.	Both b and c are correct

81.

The elements shown as item 4 in the above figure are ____.

a.	types of charts that can be created
b.	content placeholder icons
c.	graphics placeholder icons
d.	animation effects that can be added to bulleted items in the text box

82.

The presentation shown in the figure above is in ____ view.

a.	Slides	c.	Normal
b.	Slide Show	d.	Layout

83.

You can preview the look of a design theme before committing to it using ____.

a.	preview	c.	live preview
b.	theme preview	d.	slide preview

Case-Based Critical Thinking Question

Tom has just started working as an intern for a local radio station. He is responsible for managing the request line and presenting request trends to management each month. He uses Microsoft PowerPoint 2007 to create his presentations.

84.

Tom is ready to create his first presentation. He starts PowerPoint and sees ____.

a.	the Slide Layout dialog box
b.	a blank slide with the Title Slide layout
c.	a blank slide with the Two Content layout
d.	a blank slide with the Title Only layout

85.

Tom wants to change the look of the slides, so he chooses a new ____.

a.	design	c.	style
b.	theme	d.	color scheme

86.

As he hovers over each choice, Tom sees his slide change automatically. What Tom is experiencing is called ____.

a.	Preview	c.	Design Preview
b.	Live Preview	d.	Effects Preview

87.

The __________ command pulls objects so that they align with a ruler, guide, or other object.

a.	Arrange	c.	Magnetize
b.	Snap To	d.	White space

88.

To add a border or change the line color and width of a text box, you can use the buttons on the ________ toolbar.

a.	Formatting	c.	Text Box
b.	Objects	d.	Standard

89.

Spelling errors are indicated as you type by showing a ____ wavy line underneath misspelled words.

a.	green	c.	red
b.	blue	d.	black

90.

To make the words in a text box fill the space, use the ________ feature.

a.	Arrange	c.	AutoFit
b.	Justify	d.	Font size

91.

Using the keyboard arrow keys to move an object is called ____________.

a.	nudging	c.	justifying
b.	scooching	d.	positioning

92.

To change selected adjacent cells into one cell, click __________ Cells from the Table menu.

a.	Merge	c.	Combine
b.	Split	d.	Format

93.

Item 1 in the above figure is an example of a(n) _______________.

a.	bulleted list	c.	pull quote
b.	table	d.	AutoFormat

94.

Item 2 in the above figure is an example of a(n) _______________.

a.	numbered list	c.	bulleted list
b.	table	d.	grid

Case

Oscar has been asked by his friend Emma to create a flyer for an upcoming sale for her bike shop. She has given him the text he needs to use, and Oscar needs to format the text appropriately in order to present the information in a logical way.

95.

To display the brands, colors, and product numbers of the bikes that will be included in the sale, Oscar should use a __________.

a.	Design Gallery object	c.	table
b.	bulleted list	d.	numbered list

96.

For a list of door prizes that will be given away at the sale, Oscar should use a __________.

a.	Design Gallery object	c.	table
b.	bulleted list	d.	numbered list

97.

To create a logo that includes the word “Sale” and a graphic, Oscar should use a __________.

a.	Design Gallery object	c.	layout guide
b.	Format Painter	d.	text box

Case

Mrs. Boudreau teaches kindergarten and wants to set up a newsletter to send home to her students’ parents. She wants to make sure the newsletter is balanced and professional.

98.

Mrs. Boudreau notices that her students’ names have red, wavy lines under them. Which of the following is NOT true?

a.	She can add her students’ names to the Publisher dictionary.
b.	Publisher will automatically correct them when she runs the Spelling Checker.
c.	She can click Ignore in the Spelling Checker to skip each name.
d.	She can click a name, press [F7], and check the spelling of that word individually.

99.

Mrs. Boudreau likes the way she has styled the text in a text box on page 2. Which tool can she use to apply that formatting to other text?

a.	Design Gallery	c.	Format Painter
b.	Copy button	d.	Snap To

100.

To keep the proportions of an object while resizing it, press and hold ________ while dragging.

a.	[Ctrl]	c.	[Tab]
b.	[Shift]	d.	[Alt]

101.

When you copy an image, the copy is held temporarily in the Windows ___________.

a.	Clip Organizer	c.	Clipboard
b.	Office Online	d.	Design Gallery

102.

When you have design elements you plan on using but are not ready to insert in your publication, you can store them on the ___________.

a.	Clipboard	c.	background
b.	Design Gallery	d.	scratch area

103.

A ___________ can convert an image on paper into an electronic format.

a.	digital printer	c.	desktop publishing program
b.	digital camera	d.	scanner

104.

Which of the following Order commands would you use to move a selected object forward one level in a stack?

a.	Send Forward	c.	Bring to Front
b.	Send Backward	d.	Send to Back

105.

Which of the following Order commands would you use to move a selected object back one level in a stack?

a.	Send Forward	c.	Bring to Front
b.	Send Backward	d.	Send to Back

106.

Which of the following Order commands would you use to move a selected object to the topmost level in a stack?

a.	Send Forward	c.	Bring to Front
b.	Send Backward	d.	Send to Back

107.

Which of the following Order commands would you use to move a selected object to the backmost level in a stack?

a.	Send Forward	c.	Bring to Front
b.	Send Backward	d.	Send to Back

108.

Arial is an example of a(n) ___________ font.

a.	serif	c.	bolded
b.	sans serif	d.	styled

109.

Before text from one text box can be continued to another text box, you must use the ________.

a.	Autoflow feature	c.	Text in Overflow button
b.	Create Text Box Link button	d.	Page Options task pane.

110.

Which of the following is true about drop caps?

a.	It is standard to apply it to all paragraphs in a publication.
b.	When you choose a drop cap, you must specify custom features such as font.
c.	You can apply a drop cap to the first word of a paragraph.
d.	The font size in the text box adjusts to accommodate the drop cap.

111.

To change the background of a text box, use the ____________ list arrow.

a.	Background	c.	Font Color
b.	Format Text box	d.	Fill Color

112.

In the above figure, item _______ appears at the bottom of a text box when there is overflow text to be placed.

a.	1	c.	3
b.	2	d.	4

113.

In the above figure, item _______ appears at the bottom of a text box into which overflow text has been placed.

a.	1	c.	3
b.	2	d.	4

114.

In the above figure, item _______ appears when the pointer is placed over a connected text box when there is overflow text.

a.	1	c.	3
b.	2	d.	4

115.

In the above figure, item _______ is used to connect text boxes.

a.	1	c.	3
b.	2	d.	4

116.

The formatting and placements of elements are part of a publication’s ________.

a.	design	c.	master page
b.	foreground	d.	template

Case

James Lim asks his colleague, Georgia Morris, to evaluate a publication he is working on for a client. He is hoping that by asking for feedback they can make improvements to the publication.

117.

James is not terribly sensitive, but would still prefer if the critique is given __________.

a.	with friction
b.	diplomatically
c.	offensively
d.	after the changes have been made by his colleague

118.

In the above figure, item 2 is a ___________.

a.	WordArt	c.	matte
b.	masthead	d.	header

119.

A good first step in critiquing a publication is to ___________.

a.	share the message with the reader	c.	decide what is important
b.	keep it simple	d.	take in all the elements

120.

When done constructively, the critiquing process can be a positive learning experience for __________.

a.	everyone involved	c.	the designer
b.	the reader	d.	those making the critique

121.

Which would be a good question to ask when critiquing a publication?

a.	To what elements are your eyes drawn?
b.	Is the text legible?
c.	Are all the elements on the page necessary?
d.	All of the above

122.

Before a good design can be created, you must know the ____ of the publication.

a.	format	c.	goals
b.	images	d.	length

123.

How do you tell people that their work could use improvement without offending them?

a.	Give the work to someone else or change it yourself.
b.	Involve them in making improvements.
c.	Do not tell them, they will always be offended.
d.	Hold a meeting in which to share your critique with the person and others.

124.

When designing a masthead, you should consider ____.

a.	the style and appearance of the table of contents
b.	changing the title of the publication
c.	the size, appearance, and placement of the title
d.	the number of stories

125.

Which information should be most prominent on a publication’s masthead?

a.	Issue number	c.	Issue date
b.	Volume number	d.	The title

126.

In the above figure, item 1 is used to _____.

a.	arrange the order of items	c.	ungroup objects
b.	group multiple objects	d.	create rectangles

127.

In the above figure, item 2 is used to _____.

a.	delete objects	c.	ungroup objects
b.	align objects	d.	conceal portions of an image

128.

In the above figure, item 3 is used to _____.

a.	create a text box	c.	center text
b.	justify text	d.	create baseline guides

129.

Which task does Word not give you the ability to accomplish?

a.	Add a photograph to a document.
b.	Create slides for a presentation.
c.	Copy and move text between documents.
d.	Control the layout of text and graphics on each page.

130.

Which element of the Word program window indicates where text will appear when you type?

a.	ScreenTip	c.	Zoom list arrow
b.	Click and Type pointer	d.	Insertion point

131.

What appears when you place the mouse over a button on the Ribbon?

a.	Click and type pointer	c.	Toolbar Options button
b.	ScreenTip	d.	I-beam pointer

132.

What is the default file format for Word 2007 documents?

a.	.docx	c.	.dotx
b.	.doc	d.	.wd

133.

Which element of the Word program window contains buttons for performing operating commands?

a.	Status bar	c.	Zoom slider
b.	Ribbon	d.	Vertical scroll bar

134.

What is the temporary filename Word assigns a new blank document?

a.	File1	c.	New File
b.	Document1	d.	New Document

135.

Which command is used to create a new file that is a copy of the original?

a.	Save	c.	More Documents
b.	Save As	d.	New From Existing

136.

"Cut and paste" describes what operation?

a.	Copying text	c.	Replacing text
b.	Deleting text	d.	Moving text

137.

What happens when text is dragged to a new location in the document?

a.	The text is stored on the Clipboard.	c.	The text is deleted from the document.
b.	The formatting of the text changes.	d.	The text is moved to the new location.

138.

When a graphic is selected, ____ circles and squares, called sizing handles, appear on the sides and corners of the graphic.

a.	white	c.	green
b.	red	d.	blue

139.

When a graphic is selected, a ____ rotate handle appears.

a.	white	c.	green
b.	red	d.	blue

140.

Item 1, shown in the accompanying figure, is a(n) ____.

a.	adjustment handle	c.	sizing handle
b.	anchor symbol	d.	rotate handle

141.

Item 2, shown in the accompanying figure, points to ____.

a.	adjustment handles	c.	rotation handles
b.	sizing handles	d.	anchor symbols

142.

How do you edit the objects that make up a clip art picture?

a.	Double-click the picture.
b.	Right-click the picture, then click Edit Picture.
c.	Right-click the picture, then click Format Picture.
d.	Click Edit on the Format tab, then click Picture.

143.

How do you select all objects in a drawing?

a.	Click the Select Objects button on the Drawing tab.
b.	Click the Objects button on the Drawing Tools tab.
c.	Click the Select button on the Drawing Tools tab.
d.	Drag the mouse over all the objects.