MCIS FINAL EXAM :D

Created by Person299 

Upgrade to
remove ads

Stuff for school :3 :D

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

See More

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set