Computer Literacy Final Flashcards
You can copy ____ and numbers between Word and Excel.
Text
Microsoft Office programs are designed to work together through a process called ____.
Integration
Microsoft Office provides ____ integration methods.
Three
When you want to copy an object without a data connection to the source file, you should use the ____ integration method.
Pasting
If a text value in a Word document is automatically updated after a corresponding text value is updated in an Excel source document, you can determine that the text value in Word is ____ the source document.
Linked to
If a text value in a Word document is automatically updated after a corresponding text value is updated in an Excel source document, you can determine that the text value in Word is ____ the source document.
Embed
If you need to remove all items appearing in the Clipboard task pane, click ____.
Clear All
When you use the Copy and Paste commands, by default an object copied from one program to another program retains the ____ of the original object.
Formatting
Suppose you have placed the following items to the Clipboard in the following order: a photograph, a text value, a column chart, and a table. If the items were copied in the order listed, the ____ would be at the bottom of the list.
Photograph
In Excel, the Clipboard task pane opens ____ the worksheet window.
To the left of
Microsoft Access can best be described as ____ software
Database
Which is NOT true about Access?
Reporting is limited to 20 saved reports
Tables, queries, and forms are examples of Access ____.
Objects
Which of the following is NOT available to you as you start Access?
recalibrating an existing database
Which Access object provides an easy-to-use data entry screen?
form
Which is NOT a feature of Access reports?
easy-to-use data entry screen
Which Access object contains all of the raw data within the database?
table
____ View provides the most options for defining fields.
table design
Which of the following is NOT a data type?
Formula
Which data type stores only one of two values?
Yes/No
SQL stands for ____.
Structured Query Language
A query datasheet is sometimes called a ____ of the data.
logical view
In large datasheets, you may want to ____ certain fields so that they remain on the screen at all times.
freeze
You use Query Design View to add ____ to limit the number of records shown in the resulting datasheet.
criteria
Query Design View presents the fields you can use for a query in small windows called field ____.
lists
Access saves ____ automatically as you move from record to record.
data
Use the ____ command to save the current object with a new name.
Save As
To move a field in the query design grid, click its ____, and then drag it left or right.
field selector
A(n) ____ is a temporary view of the data that is removed when you close the datasheet.
filter
The wildcard character that stands for any group of characters is the ____.
asterisk (*)
The Form Wizard prompts you for information it needs to create a form, such as the ____ for the form.
All of the above
Which of the following is NOT a form view?
Data
Which form creation tool can you use to create a form from scratch in Form Design View?
Form Design
Which form creation tool can you use to create a form by answering a series of questions provided by dialog boxes?
Form Wizard
Referential integrity prevents the creation of ____ records.
orphan
____ records are those on the many side of a relationship that do not have a match on the one side.
orphan
____ View lets you make some design changes to a form while you are browsing the data
layout
The Align button in the Sizing & Ordering group is available on the ____ tab
Arrange
Which control displays a list of possible data entries from which the user can choose?
List Box
Which control is used to create a three-dimensional aspect to a form?
tab control
Which of the following is NOT a common report embellishment?
command buttons
Which report view’s primary purpose is to quickly review the report without page breaks?
Report View
Which report view’s primary purpose is to review each page of the entire report as it will appear if printed?
Print Preview
Which report view’s primary purpose is to allow you to modify report controls while reviewing live data?
Layout View