How can we help?

You can also find more resources in our Help Center.

194 terms

MCIS FINAL EXAM :D

Stuff for school :3 :D
STUDY
PLAY
Access is a
database management system.
A _____ contains information about a given person, product, or event.
record
Database _____ refers to the arrangement of data into tables and fields
design
_____ words are words that have a special meaning to Access and cannot be used for the names of fields.
reserved
In Access, table and field names can be up to ____ characters in length.
64
A field whose data type is ____ characters in length.
text
A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.
Memo
A field with the ____ data type can store a unique sequential number that Access assigns to a recored. Access will increment the number by 1 as each new record is added.
AutoNumber
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 is added.
Attachment
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.
OLE Object
In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a
database
One way to create a table, is to click ___ on the Ribbon and then click the Table button.
Create
When you create a table in Datasheet view, Access automatically adds a field called ___ as the first field in the table.
ID
To define an additional field in Datasheet view, click the ___ column heading.
Click to Add
To undo the most recent change to a table structure, click the ___ button on the Quick Access Toolbar.
Undo
To delete a field in a table, right-click the column heading for the field, and then click ___ on the shortcut menu, and then type the desired field name.
Delete Field
To change the name of a field, right-click the column heading for the field, click ___ on the shortcut menu, and then type the desired field name.
Rename Field
To show the symbol for the Euro instead of the dollra sign, change the ___ property for the field whose data type is Currency.
Format
To insert a field between existing fields, right-click the column heading for the field that will follow the field, and then click ___ on the shortcut menu.
Insert Field
To open a table in Design view, right-click the table in the Navigation Pane and then click ___ on the shortcut menu.
Design View
To add a record to a table, click the ___ record button.
New (blank)
You can place an insertion point by clicking in the field or by pressing
F2
To delete a record, click the record selector for the record, and then press the ___ key(s).
DELETE
To change the print orientation from portrait to landscape, click the ___ button on the Print Preview tab.
Landscape
To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click ___, and then click Proofing in the dialog box that displays.
Options
To import data to a table, click the ___ tab on the Ribbon.
External Data
To save the changes to the layout of a table, click the Save button on the
Quick Access Toolbar
To open the Navigation Pane, click the ___ Button.
Shutter Bar Open/Close
To create a query using the Query Wizard, click ___ on the Ribbon and then click the Query Wizard button.
Create
To view the results of a saved query, right-click the query in the Navigation Pane and click ___ on the shortcut menu.
Open
To change the design of a query, right-click the query in the Navigation Pane and then click ___ on the shortcut menu.
Design View
To create an initial report that can be modified in Layout view, click ___ on the Create tab.
Report
To quit Access, click the ___ button on the right side of the title bar.
Close
To compact and repair a database, click the ___ button in the Information gallery in the Backstage view.
Compact and Repair
To back up a database, use the Back Up Database command on the ___ tab in the Backstage view.
Save & Publish
To delete a a database object, right-click the object in the Navigation Pane and then click ___ on the shortcut menu.
Delete
To rename a database object, right-click the object in the Navigation Pane and then click ___ on the shortcut menu.
Rename
An Excel ___ allows data easily to be summarized and charted.
worksheet
The person or persons requesting the worksheet should supply their requirements in a ____ document.
requirements
The first step in creating an effective worksheet is to make sure you
understand what is required
To enter data in a cell, you must first select or activate the
Cell
____ is/are used to add worksheet, column, and row titles on a worksheet.
Text
To cancel an entire entry before entering it into the cell, press the ____ key.
ESC
Clicking the ___ box completes an entry.
Enter
The ____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
The ___ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
AutoCorrect
Pressing the ___ key to complete an entry activates the adjacent cell to the right.
RIGHT ARROW
By default, text is ___ in a cell.
left-aligned
In Excell, a number can contain the characters
0 1 2 3 4 5 6 7 8 9; . $ % E e; + - ( ) , / (all of the above)
To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type
6E15
You can enter the correct range in a function by typing the beginning and ending cell references seperated by a
colon (:)
To enter a number as text, precede it with a(n)
apostrophe (')
The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the
destination area (or paste area)
A ___ reference is an adjusted cell reference in a copied and pasted formula.
relative
The ___ is the small black square located in the lower-right corner of the heavy border around the active cell.
fill handle
The ___ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.
Auto Fill Options
You ___ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
format
In general, use no more than ___ font types in a worksheet.
two
You can apply the Bold font style by pressing the ___ keyboard shortcut keys.
CTRL+B
Combining two or more selected cells into one cell is called ____ cells.
merging
Which of the following is the Ribbon path to the Cell Styles button?
(Home tab | Styles group)
What effect does the Accounting Numbe Fomat have on the selected cells?
Displays cell contents with two decimal places that align vertically
What effect does the Comma Style fomat have on the selected cells?
Displays cell contents with two decimal places and commas as thousands separators.
Pressing the ____ keyboard shortcut key(s) selects cell A1.
CTRL+HOME
How many chart types does Excel offer?
11
A(n) ___ chart is drawn on the same worksheet as the data.
embedded
____ properties are associated with all Microsoft Office documents and include author, title, and subject.
Standard
The ___ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
AutoCalculate
Which of the following keys is an alternative to double-clicking the cell to edit it?
F2
Which of the following keys toggles between Insert mod and Overtype mode?
INSERT
Which of the following keys moves the inertion point to the beginning of data in a cell?
HOME
Which of the following keys moves the insertion point to the end of data in a cell?
END
Excel remembers the last ___ actions you have completed.
100
To remove an embedded chart, you should ____ it and press the DELETE key.
click
___ conveys meaning and is useful to one or more people.
Information
The processor, memory, and storage devices are housed in a box-like case called the
system unit
A ___ is a small metal or plastic device that looks like a ballpoint pen, but uses pressure instead of ink to write, draw, or make selections.
Stylus
One kilobye (K or KB) equals approximately ___ memory locations.
1,000
Which kind of monitor uses a liquid crystal display to produce images on the screen?
LCD
A ___ is a duplicate of a file, program, or disk that you can use in case the original is lost, damaged, or destroyed.
backup
A ___ is an erasable optical disc you can write on multiple times.
CD-RW (compact disc-reqriteable)
A(n) ___ is system software.
operating system
A URL consists of a ___, a domain name, sometimes the path to a specific Web page or location in a Web page, and the Web page name.
protocol
A ___ is a program that hides in a computer and allows someone from a remote locations to take full control of the computer.
rootkit
___ computers are a good option if you work mostly in one place and have plenty of space in your work area.
Desktop
Plan to buy a computer that will last you for ___ year(s)
two to three
The lightest notebook computers, which weigh less than 3 pounds, are equipped with a(n) ___-inch display.
12.1
If you spend a lot of time attending lectures or meetings, then then slate ___ is ideal.
Tablet PC
Windows 7 is used to run ___ software.
application
To display the Start menu, press
CTRL+ESC
If you are required to log on to the computer, the ___ screen is displayed, which shows the user names on the computer.
Welcome
The ___ command waits for Windows 7 to save your work and then turns off the computer fans and hard disk.
Sleep
A(n) ___ is a named unit of storage.
file
Microsoft Office programs use ___ dialog boxes for performing actions such as opening and saving files.
common
Which of the following applications is included with Microsoft Office Standard 2010?
OneNote
Which of the following applications is included with Microsoft Office Home and Student 2010?
Excel
___ is a full-featured word processing program that allows you to create many types of personal and business documents.
Word
A(n) ___ is an area of a window that displays related content.
pane
A ___ is a list of related items, including folers, programs, and commands.
menu
A(n) ___ on a menu performs a specific action, such as saving a file.
command
___ view shows the document on a mock sheet of paper in the document window.
Print Layout
One method of displaying the entire contents of a window is to ___ it.
maximize
When you ___ a scroll bar, a shortcut menu appears with commands related to the scroll bar.
right-click
Which of the following buttons are contained on the Quick Access Toolbar by default?
Save, Redo, Undo (All of the above)
A ___ consists of a drive letter and colon, to identify the storage device, and one or more foler names.
path
Which of the following is a valid folder name?
folder!
Which of the following is a valid folder name?
COM
A ___ is an icon on the desktop that provides a user with immediate access to a program or file.
shortcut
The ___ bar contains five buttons used to accomplish various tasks on the computer related to organizing and managing the contents of the open window.
Command
A ___ helps you manage multiple folders and files stored in various locations on a computer.
library
A(n) ___ window is an open window hidden from view but that can be displayed quickly by clicking the window's program button on the taskbar.
minimized
Screen resolution indicates the number of ___ that the computer uses to display the letters, numbers, graphics, and background you see on the screen.
pixels
A ___ is an object that allows users to choose from multiple predetermined options.
slider
A ___ in Excel is like a notebook.
workbook
A cell is referred to by its cell
reference
The ___ cell on the worksheet is the one into which you can enter data.
active
As you type, Excel displays the entry in the ___ bar.
formula
___ is a powerful communications and scheduling program that helps you communicate with others, amon other things.
Outlook
___ is a powerful DTP program that assists you in designing and producing professional-quality documents that combine text, graphics, illustrations, and photos.
Publisher
A PowerPoints ____ can help you deliver a dynamic, professional-looking message to an audience.
presentation
All of the following are PowerPoint content used to customize slides except
databases
PowerPoint ___ should reinforce the speaker's message and help the audience retain the information presented.
slides
The best starting point to developing a presentation is to
establish why the presentation is needed
All of the following are general project guidelines for a new presentation except
add clip to every slide
A ___ provides consistency in design and color throughout the entire presentation.
document theme
The default document theme is the
Office Theme
The Themes gallery is located on the ___ Ribbon tab.
Design
The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text
placeholder
When you open a new presentation, a slide with the default ____ layout appears.
Title Slide
By deafult, slides in a new presentation are in ___ orientation.
landscape
The Undo button is located on the
Quick Access Toolbar
When you type the wrong character, you can press the ____ key to erase all the characters back to and including the one that is incorrect.
BACKSPACE
Pressing the ___ key when entering title text in a placeholder creates a new paragraph.
ENTER
Which of the following is not a design guideline for formatting text?
Avoid text with a font size greater than 30 point
Text ___ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.
font
A point is ___ of an inch in height.
1/72
___ text has slanted appearance.
Italicized
The Italic button is located on the
Mini toolbar
When selecting text color, try to limit using
red
When you add a new slide folowing the title slide, PowerPoint uses the ___ slide layout for the new slide.
Title and Content
You can insert a new slide by pressing the ___ keyboard shortcut keys.
CTRL+M
PowerPoint assumes every new slide, except for a blank slide, has
a title
You can move the insertion point into the next text placeholder by pressing the ___ keyboard shortcut keys.
CTRL+ENTER
In a multi-level bulleted list slide, creating a lower-level paragraph is called ___ the text.
demoting
What is the correct path to the Bold button?
(Home tab | Font group)
To change the font size of selected text, click the Decrease Font Size or Increase Font Size buttons located
on the Mini toolbar
Using the ___, you can choose the arrangement of placeholders on a new slide.
Layout gallery
You can type comments to yourself in the ___ for a specific slide while working in Normal view.
Notes pane
The default PowerPoint view is ___ view.
Normal
___ is a collection of drawings, photographs, sounds, videos, and other media files shared among Microsoft Office applications.
The Microsoft Clip Organizer
You can search for media clips using the
Clip Art task pane
The process of moving a slide object to a new locations using the mouse pointer is called
drag and drop
A slide ___ is a special animation effect used to progress from one slide to the next slide in a slide show.
transition
Document ___ are the details about a file.
properties
Which of the following is not a standard document property?
date the presentation file was created or changed
Which of the following keys can you press to run a slide show starting with slide 1?
F5
Sending electronic documents is a way to contribute to ___ computing.
green
The default view in Word is
Print Layout view
To enter a blank line into a document,m press the ___ key without typing any text on the line.
ENTER
Press the ENTER key in all of the following circumstances EXCEPT
when the insertion point reaches the right margin
When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a
red X
If a flagged word is spelled correctly, right-click it and then click ___ on the shortcut menu to instruct Word not to flag future occurences of the same word in this document.
Ignore All
To move left one word with the keyboard, press the ___ key(s).
CTRL+LEFT ARROW
To move to the beginning of a line with the keyboard, press the ___ key(s).
HOME
To move to the end of the document, press the ___ key(s).
CTRL+END
To move to the right one word, press the ____ key(s).
CTRL+RIGHT ARROW
To move up one paragraph, press the ___ key(s).
CTRL+UP ARROW
To move down one paragraph, press the ___ key(s).
CTRL+DOWN ARROW
To move to the bottom of a document window, press the ____ key(s).
ALT+CTRL+PAGE DOWN
To move to the top of a document window, press the ___ key(s).
ALT+CTRL+PAGE UP
When you use the keyboard to scroll to a different position in the document, the ___ automatically moves when your press the desired keys.
insertion point
Word includes a variety of document ___ to assist you with coordinating these visual elements in a document.
themes
___ formatting is the proccess of changing the way letters, numbers, punctuation marks, and symbols appear on the screen in print.
Character
The ___, or typeface, defines the appearance and shape of letters, numbers, and special characters.
font
On most computers, the default font size in Word is
11
A(n) ___ paragraph is a paragraph that begins with a dot or other symbol.
bulleted
The file type ___ is a Word 2010 document.
.docx
To select nonadjacent items, select the first item as usual, press and hold down the ___ key, and then while holdinmg down the key select the additional items.
CTRL
Which of the following colors suggests neutrality?
gray
With more than ___ predefined color schemes, Word provides a simple way to select colors that work well together.
20
You can select characters by using the ___ key(s).
SHIFT+RIGHT ARROW
You can select a document by using the ___ key(s).
CTRL+A
You can select a paragraph by using the ___ key(s).
SHIFT+END
You can select multiple paragraphs by using the ___ key(s) repeatedly.
CTRL+SHIFT+DOWN ARROW
You can select a word by using the ___ key(s).
CTRL+SHIFT+LEFT ARROW
You can select multiple words by using the ___ key(s) repeatedly.
CTRL+SHIFT+RIGHT ARROW
To center a page's contents vertically between the top and bottom margins, click the Page Setup Dialog Box Launcher, click the ___ tab, click the vertical alignment box arrow, click Center in the list, and then click the OK button.
Layout
___ are types of changes that occur when text has been ommited from a document and must be inserted later.
Additions
To delete an incorrect character in a document, simply click next to the incorrect character and then press the ___ key(s) to erase to the left of the insertion point.
BACKSPACE
To delete an incorrect character in a document, simply click next to the incorrect character and then press the ___ key(s) to erase to the right of the insertion point.
DELETE
___ are words or phrases that describe a document.
Keywords
___ is another term for document properties.
Metadata
To close the ___ view, click File on the Ribbon or click the preview of the document in the Info gallery to return to the document window.
Backstage
In Word, you can create electronic image files through the ___ tab in the Backstage view.
Print