AL1 C7 C8 Flashcards
Which two text boxes appear in the Set Database Password dialog box?
Password and Verify
The drop-down list that displays when you click the Filter button will contain a Text Filters option when you filter which of the following?
a text field
Clicking the _____ next to an object in the Object Dependencies task pane shows the other objects that depend on it.
expand button
Switch back and forth between data and filtered data by clicking the
Toggle Filter button.
What information must you supply at the Unset Database Password dialog box?
the database password
The _____ file format was developed by Adobe Systems.
Chapter 7 identifies how to filter data by selection and by
form
If you save an Access object as an XPS file, you can open it in which of the following?
Internet Explorer
Which of the following pieces of information cannot be recorded in fields on the Summary tab at the Properties dialog box?
date created
After a table has been filtered, the message Filtered appears in the
Record Navigation bar.
The Export - RTF File dialog box displays after you click _____ at the More button drop-down list.
Word
The Export group is on the _____ tab.
External Data
When you import Excel data into a new Access table and then make changes to the data in the Access table, these changes are reflected in
the Access table but not the original Excel spreadsheet.
Which of the following is one of the options at the Get External Data - Excel Spreadsheet dialog box?
(?)
NOT Choose my own primary key.
Link to the data source by creating a linked table.
To export an Access table to Excel, begin by
clicking the table in the Navigation pane.
The Clipboard group is on the _____ tab.
Home
What type(s) of Access object(s) can be merged with a Word document?
tables and queries
PDF is a file format that captures all the elements of a file as
an electronic image.
When Excel is closed, Access displays with a dialog box that asks if you want to save the
export step.
What does RTF stand for?
rich-text format
To encrypt a database with a password, you must first open the database by clicking the _____ option at the Open button arrow drop-down list.
Open Exclusive
You will use a password when you _____ an Access database.
encrypt
Which of the following fields does not appear on the Summary tab at the Properties dialog box?
Location
Access _____ and earlier versions save a database with a different file extension.
2003
Which filters are available depends on
the type of data selected in the column.
What caution is given in Chapter 7 about compacting and repairing a database in a multi-user environment?
Make sure no other user has the database open before compacting or repairing it.
Suppose that you save an object as a PDF file. To specify that the object should open in _____, insert a check mark in the Open file after publishing check box at the Publish as PDF or XPS dialog box.
Adobe Acrobat Reader
Chapter 8 discusses methods for exporting Access data to which two Microsoft Office programs?
Word and Excel
Access cannot be used to do which of the following?
store objects from other programs
How are text items displayed in the Clipboard task pane?
The first 50 characters are displayed.
When merging an Access table with a Word document, the Access table is considered the _____ and the Word document is considered the _____.
data source; main document
What two buttons appear at the top of the Clipboard task pane?
Paste All and Clear All
Which of the following is not one of the export options in the Export - Excel Spreadsheet dialog box?
Export only the selected fields
Chapter 8 suggests that you store data in _____ and analyze it using _____.
Access; Excel
What happens when you click the Clipboard task pane launcher?
The Clipboard task pane displays.
If you encrypt a database with a password and then lose the password,
you will not be able to open the database.
With an object open in a database, display options for saving the object by clicking the Save Object As option in the _____ section of the Save As backstage area.
File Types
A set of restrictions placed on records in a table or query to isolate temporarily these records is called a
filter
Click the _____ tab to view information such as the dates the database was created, modified, accessed, and printed.
(?)
NOT Custom
NOT Summary
A database with a large number of interdependent objects is _____ to work with than a simpler database.
more complex
View the structure of a database at the
Object Dependencies task pane.
What does saving a file in rich-text format do when exporting Access data to Word?
It preserves formatting such as fonts and styles.
At the Export - Excel Spreadsheet dialog box, Access uses _____ as the Excel workbook name.
the name of the object
When you double-click the name of the file to be imported into Access at the Import dialog box, the _____ is activated.
Import Wizard
When deciding whether to link or import data into Access, follow this advice: If you plan to _____, import it, and if you plan to _____, link it.
use the data only in Access; update the data in the source program
When exporting data to Word, what happens after you click OK at the Export - RTF dialog box?
Word automatically opens and the data displays in a Word document that is saved automatically with the same name as the database object.
To save an Access database in an earlier version of the program, begin by clicking the
File tab and then the Save As option.
When you open the Object Dependencies task pane, _____ is selected by default.
Objects that depend on me
The Object Dependencies button is in the Relationships group on the _____ tab.
Database Tools
To use the Filter button to filter data, you should first
open the object and click in the field to be filtered.
Two options control what will be displayed in the Object Dependencies task pane: _____ and _____.
Objects that depend on me; Objects that I depend on
Backing up a database is especially important in which of these situations?
Several people manage and update the database.
What is the last button to click when saving an Access object as a PDF file?
Publish
What does PDF stand for?
portable document format
What opens when you click the Excel button in the Export group on the External Data tab?
the Export - Excel Spreadsheet dialog box
Clicking the PDF or XPS button displays the Publish as PDF or XPS dialog box with the _____ option selected in the Save as type option box.
What two pieces of information are required in the text boxes at the Export - Excel Spreadsheet dialog box?
the file name and file format of the exported object
The Selection button is in the _____ group on the Home tab.
Sort & Filter
Which of the following is not one of the headings under which objects are grouped in the Object Dependencies task pane?
Modules
To remove a filter from a table, begin by clicking in the field column containing the filter and then
clicking the Filter button.
What happens when you click on an object name in the Object Dependencies task pane?
The object opens in Design view.
The _____ of a database includes tables, queries, forms, and reports, as well as relationships.
structure
In a table that has been filtered, what happens when you click the Toggle Filter button?
Records are redisplayed but the filter is not removed.
As you work with a database, data in it can become _____, causing the amount of space the database takes on a storage medium to be larger than necessary.
fragmented
Data exported from Access to Word is saved with the _____ file extension.
.rtf
When merging Access data with Word, you can either merge the data with an existing Word document or
type the text into the main document.
Up to _____ items can be collected and pasted on the Office Clipboard.
24
The «AddressBlock» field used when merging data with a Word document is an example of a(n) _____ field.
composite
When filtering on a specific field, you can display a list of _____ for that field.
unique values
The filtering shortcut menu also contains options for
sorting data.
Where are options provided for compacting a database?
at the Info backstage area
Which of the following steps is not part of linking data to an Excel worksheet?
Click the Excel button in the Export group.
A composite field displays with _____ around the field name.
double left- and right-pointing arrows
How many database objects can you export to Excel at a time?
one
Data exported from Access to Excel is saved with the _____ file extension.
.xlsx
Use options at the Properties dialog box with the _____ tab selected to add specific properties such as the date the database was completed, information on the department in which the database was created, and much more.
Custom
The Advanced button in the Sort & Filter group on the Home tab contains additional options for filtering records, including
Filter By Form.
To open a PDF or XPS file in a web browser, begin by opening the browser and then pressing _____ to display the Open dialog box.
Ctrl + O
When exporting data from Access to Word, which of the following steps occurs earliest in the process?
Click the object to be exported.
What does XPS stand for?
XML paper specification
Imported data _____ connected to the source program.
is not
Which of the following buttons does not appear in the Clipboard task pane?
Copy
When you click on the field value Chicago, you will not see which of the following options at the Selection button drop-down list?
Is Like “Chicago”
To link data to an Access database, use options in the _____ group on the External Data tab.
Import & Link
To merge an Access table with a Word document, begin by clicking the table in the Navigation pane, clicking the External Data tab, and then clicking the _____ button.
Word Merge
When data is being imported from an external data source into Access, the appearance of the Import Wizard dialog box varies depending on
the type of file selected.
The _____ tab at the Properties dialog box displays information about the database type, size, and location.
General
The Address Block button is in the _____ group on the _____ tab.
Write & Insert; Mailings
A(n) _____ groups a number of fields.
composite
You can tell Access to compact and repair a database each time you
close it.
The Filter button contains an image of a
funnel.
Which of the following steps is not part of the process of merging Access data with a Word document?
Click the More button in the Export group.
Access the Properties dialog box by clicking the View and edit database properties hyperlink
at the Info backstage area.
