Access is a
database management system.
A _____ contains information about a given person, product, or event.
Database _____ refers to the arrangement of data into tables and fields
_____ words are words that have a special meaning to Access and cannot be used for the names of fields.
In Access, table and field names can be up to ____ characters in length.
A field whose data type is ____ characters in length.
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.
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.
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.
A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.
In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a
One way to create a table, is to click ___ on the Ribbon and then click the Table button.
When you create a table in Datasheet view, Access automatically adds a field called ___ as the first field in the table.
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.
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.
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.
To show the symbol for the Euro instead of the dollra sign, change the ___ property for the field whose data type is Currency.
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.
To open a table in Design view, right-click the table in the Navigation Pane and then click ___ on the shortcut menu.
To add a record to a table, click the ___ record button.
You can place an insertion point by clicking in the field or by pressing
To delete a record, click the record selector for the record, and then press the ___ key(s).
To change the print orientation from portrait to landscape, click the ___ button on the Print Preview tab.
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.
To import data to a table, click the ___ tab on the Ribbon.
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.
To view the results of a saved query, right-click the query in the Navigation Pane and click ___ on the shortcut menu.
To change the design of a query, right-click the query in the Navigation Pane and then click ___ on the shortcut menu.
To create an initial report that can be modified in Layout view, click ___ on the Create tab.
To quit Access, click the ___ button on the right side of the title bar.
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.
To rename a database object, right-click the object in the Navigation Pane and then click ___ on the shortcut menu.
An Excel ___ allows data easily to be summarized and charted.
The person or persons requesting the worksheet should supply their requirements in a ____ document.
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
____ is/are used to add worksheet, column, and row titles on a worksheet.
To cancel an entire entry before entering it into the cell, press the ____ key.
Clicking the ___ box completes an entry.
The ____ is a blinking vertical line that indicates where the next typed character will appear.
The ___ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
Pressing the ___ key to complete an entry activates the adjacent cell to the right.
By default, text is ___ in a cell.
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
You can enter the correct range in a function by typing the beginning and ending cell references seperated by a
To enter a number as text, precede it with a(n)
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.
The ___ is the small black square located in the lower-right corner of the heavy border around the active cell.
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.
In general, use no more than ___ font types in a worksheet.
You can apply the Bold font style by pressing the ___ keyboard shortcut keys.
Combining two or more selected cells into one cell is called ____ cells.
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.
How many chart types does Excel offer?
A(n) ___ chart is drawn on the same worksheet as the data.
____ properties are associated with all Microsoft Office documents and include author, title, and subject.
The ___ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
Which of the following keys is an alternative to double-clicking the cell to edit it?
Which of the following keys toggles between Insert mod and Overtype mode?
Which of the following keys moves the inertion point to the beginning of data in a cell?
Which of the following keys moves the insertion point to the end of data in a cell?
Excel remembers the last ___ actions you have completed.
To remove an embedded chart, you should ____ it and press the DELETE key.
___ conveys meaning and is useful to one or more people.
The processor, memory, and storage devices are housed in a box-like case called the
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.
One kilobye (K or KB) equals approximately ___ memory locations.
Which kind of monitor uses a liquid crystal display to produce images on the screen?
A ___ is a duplicate of a file, program, or disk that you can use in case the original is lost, damaged, or destroyed.
A ___ is an erasable optical disc you can write on multiple times.
CD-RW (compact disc-reqriteable)
A(n) ___ is system software.
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.
A ___ is a program that hides in a computer and allows someone from a remote locations to take full control of the computer.
___ computers are a good option if you work mostly in one place and have plenty of space in your work area.
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.
If you spend a lot of time attending lectures or meetings, then then slate ___ is ideal.
Windows 7 is used to run ___ software.
To display the Start menu, press
If you are required to log on to the computer, the ___ screen is displayed, which shows the user names on the computer.
The ___ command waits for Windows 7 to save your work and then turns off the computer fans and hard disk.
A(n) ___ is a named unit of storage.
Microsoft Office programs use ___ dialog boxes for performing actions such as opening and saving files.
Which of the following applications is included with Microsoft Office Standard 2010?
Which of the following applications is included with Microsoft Office Home and Student 2010?
___ is a full-featured word processing program that allows you to create many types of personal and business documents.
A(n) ___ is an area of a window that displays related content.
A ___ is a list of related items, including folers, programs, and commands.
A(n) ___ on a menu performs a specific action, such as saving a file.
___ view shows the document on a mock sheet of paper in the document window.
One method of displaying the entire contents of a window is to ___ it.
When you ___ a scroll bar, a shortcut menu appears with commands related to the scroll bar.
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.
Which of the following is a valid folder name?
Which of the following is a valid folder name?
A ___ is an icon on the desktop that provides a user with immediate access to a program or file.
The ___ bar contains five buttons used to accomplish various tasks on the computer related to organizing and managing the contents of the open window.
A ___ helps you manage multiple folders and files stored in various locations on a computer.
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.
Screen resolution indicates the number of ___ that the computer uses to display the letters, numbers, graphics, and background you see on the screen.
A ___ is an object that allows users to choose from multiple predetermined options.
A ___ in Excel is like a notebook.
A cell is referred to by its cell
The ___ cell on the worksheet is the one into which you can enter data.
As you type, Excel displays the entry in the ___ bar.
___ is a powerful communications and scheduling program that helps you communicate with others, amon other things.
___ is a powerful DTP program that assists you in designing and producing professional-quality documents that combine text, graphics, illustrations, and photos.
A PowerPoints ____ can help you deliver a dynamic, professional-looking message to an audience.
All of the following are PowerPoint content used to customize slides except
PowerPoint ___ should reinforce the speaker's message and help the audience retain the information presented.
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.
The default document theme is the
The Themes gallery is located on the ___ Ribbon tab.
The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text
When you open a new presentation, a slide with the default ____ layout appears.
By deafult, slides in a new presentation are in ___ orientation.
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.
Pressing the ___ key when entering title text in a placeholder creates a new paragraph.
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.
A point is ___ of an inch in height.
___ text has slanted appearance.
The Italic button is located on the
When selecting text color, try to limit using
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.
PowerPoint assumes every new slide, except for a blank slide, has
You can move the insertion point into the next text placeholder by pressing the ___ keyboard shortcut keys.
In a multi-level bulleted list slide, creating a lower-level paragraph is called ___ the text.
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.
You can type comments to yourself in the ___ for a specific slide while working in Normal view.
The default PowerPoint view is ___ view.
___ 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.
Document ___ are the details about a file.
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?
Sending electronic documents is a way to contribute to ___ computing.
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.
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
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.
To move left one word with the keyboard, press the ___ key(s).
To move to the beginning of a line with the keyboard, press the ___ key(s).
To move to the end of the document, press the ___ key(s).
To move to the right one word, press the ____ key(s).
To move up one paragraph, press the ___ key(s).
To move down one paragraph, press the ___ key(s).
To move to the bottom of a document window, press the ____ key(s).
To move to the top of a document window, press the ___ key(s).
When you use the keyboard to scroll to a different position in the document, the ___ automatically moves when your press the desired keys.
Word includes a variety of document ___ to assist you with coordinating these visual elements in a document.
___ formatting is the proccess of changing the way letters, numbers, punctuation marks, and symbols appear on the screen in print.
The ___, or typeface, defines the appearance and shape of letters, numbers, and special characters.
On most computers, the default font size in Word is
A(n) ___ paragraph is a paragraph that begins with a dot or other symbol.
The file type ___ is a Word 2010 document.
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.
Which of the following colors suggests neutrality?
With more than ___ predefined color schemes, Word provides a simple way to select colors that work well together.
You can select characters by using the ___ key(s).
You can select a document by using the ___ key(s).
You can select a paragraph by using the ___ key(s).
You can select multiple paragraphs by using the ___ key(s) repeatedly.
You can select a word by using the ___ key(s).
You can select multiple words by using the ___ key(s) repeatedly.
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.
___ are types of changes that occur when text has been ommited from a document and must be inserted later.
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.
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.
___ are words or phrases that describe a document.
___ is another term for document properties.
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.