Create an account
_____ words are words that have a special meaning to Access and cannot be used for the names of fields.
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
When you create a table in Datasheet view, Access automatically adds a field called ___ as the first field in the table.
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 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 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 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.
The person or persons requesting the worksheet should supply their requirements in a ____ document.
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.
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
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)
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.
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.
____ 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.
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.
A ___ is a duplicate of a file, program, or disk that you can use in case the original is lost, damaged, or destroyed.
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.
The lightest notebook computers, which weigh less than 3 pounds, are equipped with a(n) ___-inch display.
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.
Microsoft Office programs use ___ dialog boxes for performing actions such as opening and saving files.
___ is a full-featured word processing program that allows you to create many types of personal and business documents.
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.
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.
___ 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.
PowerPoint ___ should reinforce the speaker's message and help the audience retain the information presented.
All of the following are general project guidelines for a new presentation except
add clip to every slide
The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text
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.
Which of the following is not a design guideline for formatting text?
Avoid text with a font size greater than 30 point
When you add a new slide folowing the title slide, PowerPoint uses the ___ slide layout for the new slide.
Title and Content
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.
To change the font size of selected text, click the Decrease Font Size or Increase Font Size buttons located
on the Mini toolbar
You can type comments to yourself in the ___ for a specific slide while working in Normal view.
___ is a collection of drawings, photographs, sounds, videos, and other media files shared among Microsoft Office applications.
The Microsoft Clip Organizer
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.
Which of the following is not a standard document property?
date the presentation file was created or changed
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.
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.
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.
With more than ___ predefined color schemes, Word provides a simple way to select colors that work well together.
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.
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.
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 and try again
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