Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

ETM 1030 > AL1 C7 C8 > Flashcards

AL1 C7 C8 Flashcards

1
Q

Which two text boxes appear in the Set Database Password dialog box?

A

Password and Verify

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

a text field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Clicking the _____ next to an object in the Object Dependencies task pane shows the other objects that depend on it.

A

expand button

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Switch back and forth between data and filtered data by clicking the

A

Toggle Filter button.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

What information must you supply at the Unset Database Password dialog box?

A

the database password

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

The _____ file format was developed by Adobe Systems.

A

PDF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Chapter 7 identifies how to filter data by selection and by

A

form

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

If you save an Access object as an XPS file, you can open it in which of the following?

A

Internet Explorer

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Which of the following pieces of information cannot be recorded in fields on the Summary tab at the Properties dialog box?

A

date created

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

After a table has been filtered, the message Filtered appears in the

A

Record Navigation bar.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

The Export - RTF File dialog box displays after you click _____ at the More button drop-down list.

A

Word

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

The Export group is on the _____ tab.

A

External Data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

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

A

the Access table but not the original Excel spreadsheet.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Which of the following is one of the options at the Get External Data - Excel Spreadsheet dialog box?

A

(?)
NOT Choose my own primary key.
Link to the data source by creating a linked table.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

To export an Access table to Excel, begin by

A

clicking the table in the Navigation pane.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

The Clipboard group is on the _____ tab.

A

Home

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

What type(s) of Access object(s) can be merged with a Word document?

A

tables and queries

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

PDF is a file format that captures all the elements of a file as

A

an electronic image.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

When Excel is closed, Access displays with a dialog box that asks if you want to save the

A

export step.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

What does RTF stand for?

A

rich-text format

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

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.

A

Open Exclusive

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

You will use a password when you _____ an Access database.

A

encrypt

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Which of the following fields does not appear on the Summary tab at the Properties dialog box?

A

Location

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
24
Q

Access _____ and earlier versions save a database with a different file extension.

A

2003

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
25
Which filters are available depends on
the type of data selected in the column.
26
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.
27
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
28
Chapter 8 discusses methods for exporting Access data to which two Microsoft Office programs?
Word and Excel
29
Access cannot be used to do which of the following?
store objects from other programs
30
How are text items displayed in the Clipboard task pane?
The first 50 characters are displayed.
31
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
32
What two buttons appear at the top of the Clipboard task pane?
Paste All and Clear All
33
Which of the following is not one of the export options in the Export - Excel Spreadsheet dialog box?
Export only the selected fields
34
Chapter 8 suggests that you store data in _____ and analyze it using _____.
Access; Excel
35
What happens when you click the Clipboard task pane launcher?
The Clipboard task pane displays.
36
If you encrypt a database with a password and then lose the password,
you will not be able to open the database.
37
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
38
A set of restrictions placed on records in a table or query to isolate temporarily these records is called a
filter
39
Click the _____ tab to view information such as the dates the database was created, modified, accessed, and printed.
(?) NOT Custom NOT Summary
40
A database with a large number of interdependent objects is _____ to work with than a simpler database.
more complex
41
View the structure of a database at the
Object Dependencies task pane.
42
What does saving a file in rich-text format do when exporting Access data to Word?
It preserves formatting such as fonts and styles.
43
At the Export - Excel Spreadsheet dialog box, Access uses _____ as the Excel workbook name.
the name of the object
44
When you double-click the name of the file to be imported into Access at the Import dialog box, the _____ is activated.
Import Wizard
45
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
46
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.
47
To save an Access database in an earlier version of the program, begin by clicking the
File tab and then the Save As option.
48
When you open the Object Dependencies task pane, _____ is selected by default.
Objects that depend on me
49
The Object Dependencies button is in the Relationships group on the _____ tab.
Database Tools
50
To use the Filter button to filter data, you should first
open the object and click in the field to be filtered.
51
Two options control what will be displayed in the Object Dependencies task pane: _____ and _____.
Objects that depend on me; Objects that I depend on
52
Backing up a database is especially important in which of these situations?
Several people manage and update the database.
53
What is the last button to click when saving an Access object as a PDF file?
Publish
54
What does PDF stand for?
portable document format
55
What opens when you click the Excel button in the Export group on the External Data tab?
the Export - Excel Spreadsheet dialog box
56
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.
PDF
57
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
58
The Selection button is in the _____ group on the Home tab.
Sort & Filter
59
Which of the following is not one of the headings under which objects are grouped in the Object Dependencies task pane?
Modules
60
To remove a filter from a table, begin by clicking in the field column containing the filter and then
clicking the Filter button.
61
What happens when you click on an object name in the Object Dependencies task pane?
The object opens in Design view.
62
The _____ of a database includes tables, queries, forms, and reports, as well as relationships.
structure
63
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.
64
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
65
Data exported from Access to Word is saved with the _____ file extension.
.rtf
66
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.
67
Up to _____ items can be collected and pasted on the Office Clipboard.
24
68
The <> field used when merging data with a Word document is an example of a(n) _____ field.
composite
69
When filtering on a specific field, you can display a list of _____ for that field.
unique values
70
The filtering shortcut menu also contains options for
sorting data.
71
Where are options provided for compacting a database?
at the Info backstage area
72
Which of the following steps is not part of linking data to an Excel worksheet?
Click the Excel button in the Export group.
73
A composite field displays with _____ around the field name.
double left- and right-pointing arrows
74
How many database objects can you export to Excel at a time?
one
75
Data exported from Access to Excel is saved with the _____ file extension.
.xlsx
76
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
77
The Advanced button in the Sort & Filter group on the Home tab contains additional options for filtering records, including
Filter By Form.
78
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
79
When exporting data from Access to Word, which of the following steps occurs earliest in the process?
Click the object to be exported.
80
What does XPS stand for?
XML paper specification
81
Imported data _____ connected to the source program.
is not
82
Which of the following buttons does not appear in the Clipboard task pane?
Copy
83
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”
84
To link data to an Access database, use options in the _____ group on the External Data tab.
Import & Link
85
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
86
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.
87
The _____ tab at the Properties dialog box displays information about the database type, size, and location.
General
88
The Address Block button is in the _____ group on the _____ tab.
Write & Insert; Mailings
89
A(n) _____ groups a number of fields.
composite
90
You can tell Access to compact and repair a database each time you
close it.
91
The Filter button contains an image of a
funnel.
92
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.
93
Access the Properties dialog box by clicking the View and edit database properties hyperlink
at the Info backstage area.

ETM 1030 (18 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions