Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

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
Q

Which filters are available depends on

A

the type of data selected in the column.

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

What caution is given in Chapter 7 about compacting and repairing a database in a multi-user environment?

A

Make sure no other user has the database open before compacting or repairing it.

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

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.

A

Adobe Acrobat Reader

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

Chapter 8 discusses methods for exporting Access data to which two Microsoft Office programs?

A

Word and Excel

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

Access cannot be used to do which of the following?

A

store objects from other programs

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

How are text items displayed in the Clipboard task pane?

A

The first 50 characters are displayed.

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

When merging an Access table with a Word document, the Access table is considered the _____ and the Word document is considered the _____.

A

data source; main document

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

What two buttons appear at the top of the Clipboard task pane?

A

Paste All and Clear All

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

Which of the following is not one of the export options in the Export - Excel Spreadsheet dialog box?

A

Export only the selected fields

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

Chapter 8 suggests that you store data in _____ and analyze it using _____.

A

Access; Excel

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

What happens when you click the Clipboard task pane launcher?

A

The Clipboard task pane displays.

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

If you encrypt a database with a password and then lose the password,

A

you will not be able to open the database.

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

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.

A

File Types

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

A set of restrictions placed on records in a table or query to isolate temporarily these records is called a

A

filter

39
Q

Click the _____ tab to view information such as the dates the database was created, modified, accessed, and printed.

A

(?)
NOT Custom
NOT Summary

40
Q

A database with a large number of interdependent objects is _____ to work with than a simpler database.

A

more complex

41
Q

View the structure of a database at the

A

Object Dependencies task pane.

42
Q

What does saving a file in rich-text format do when exporting Access data to Word?

A

It preserves formatting such as fonts and styles.

43
Q

At the Export - Excel Spreadsheet dialog box, Access uses _____ as the Excel workbook name.

A

the name of the object

44
Q

When you double-click the name of the file to be imported into Access at the Import dialog box, the _____ is activated.

A

Import Wizard

45
Q

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.

A

use the data only in Access; update the data in the source program

46
Q

When exporting data to Word, what happens after you click OK at the Export - RTF dialog box?

A

Word automatically opens and the data displays in a Word document that is saved automatically with the same name as the database object.

47
Q

To save an Access database in an earlier version of the program, begin by clicking the

A

File tab and then the Save As option.

48
Q

When you open the Object Dependencies task pane, _____ is selected by default.

A

Objects that depend on me

49
Q

The Object Dependencies button is in the Relationships group on the _____ tab.

A

Database Tools

50
Q

To use the Filter button to filter data, you should first

A

open the object and click in the field to be filtered.

51
Q

Two options control what will be displayed in the Object Dependencies task pane: _____ and _____.

A

Objects that depend on me; Objects that I depend on

52
Q

Backing up a database is especially important in which of these situations?

A

Several people manage and update the database.

53
Q

What is the last button to click when saving an Access object as a PDF file?

A

Publish

54
Q

What does PDF stand for?

A

portable document format

55
Q

What opens when you click the Excel button in the Export group on the External Data tab?

A

the Export - Excel Spreadsheet dialog box

56
Q

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.

A

PDF

57
Q

What two pieces of information are required in the text boxes at the Export - Excel Spreadsheet dialog box?

A

the file name and file format of the exported object

58
Q

The Selection button is in the _____ group on the Home tab.

A

Sort & Filter

59
Q

Which of the following is not one of the headings under which objects are grouped in the Object Dependencies task pane?

A

Modules

60
Q

To remove a filter from a table, begin by clicking in the field column containing the filter and then

A

clicking the Filter button.

61
Q

What happens when you click on an object name in the Object Dependencies task pane?

A

The object opens in Design view.

62
Q

The _____ of a database includes tables, queries, forms, and reports, as well as relationships.

A

structure

63
Q

In a table that has been filtered, what happens when you click the Toggle Filter button?

A

Records are redisplayed but the filter is not removed.

64
Q

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.

A

fragmented

65
Q

Data exported from Access to Word is saved with the _____ file extension.

A

.rtf

66
Q

When merging Access data with Word, you can either merge the data with an existing Word document or

A

type the text into the main document.

67
Q

Up to _____ items can be collected and pasted on the Office Clipboard.

A

24

68
Q

The «AddressBlock» field used when merging data with a Word document is an example of a(n) _____ field.

A

composite

69
Q

When filtering on a specific field, you can display a list of _____ for that field.

A

unique values

70
Q

The filtering shortcut menu also contains options for

A

sorting data.

71
Q

Where are options provided for compacting a database?

A

at the Info backstage area

72
Q

Which of the following steps is not part of linking data to an Excel worksheet?

A

Click the Excel button in the Export group.

73
Q

A composite field displays with _____ around the field name.

A

double left- and right-pointing arrows

74
Q

How many database objects can you export to Excel at a time?

A

one

75
Q

Data exported from Access to Excel is saved with the _____ file extension.

A

.xlsx

76
Q

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.

A

Custom

77
Q

The Advanced button in the Sort & Filter group on the Home tab contains additional options for filtering records, including

A

Filter By Form.

78
Q

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.

A

Ctrl + O

79
Q

When exporting data from Access to Word, which of the following steps occurs earliest in the process?

A

Click the object to be exported.

80
Q

What does XPS stand for?

A

XML paper specification

81
Q

Imported data _____ connected to the source program.

A

is not

82
Q

Which of the following buttons does not appear in the Clipboard task pane?

A

Copy

83
Q

When you click on the field value Chicago, you will not see which of the following options at the Selection button drop-down list?

A

Is Like “Chicago”

84
Q

To link data to an Access database, use options in the _____ group on the External Data tab.

A

Import & Link

85
Q

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.

A

Word Merge

86
Q

When data is being imported from an external data source into Access, the appearance of the Import Wizard dialog box varies depending on

A

the type of file selected.

87
Q

The _____ tab at the Properties dialog box displays information about the database type, size, and location.

A

General

88
Q

The Address Block button is in the _____ group on the _____ tab.

A

Write & Insert; Mailings

89
Q

A(n) _____ groups a number of fields.

A

composite

90
Q

You can tell Access to compact and repair a database each time you

A

close it.

91
Q

The Filter button contains an image of a

A

funnel.

92
Q

Which of the following steps is not part of the process of merging Access data with a Word document?

A

Click the More button in the Export group.

93
Q

Access the Properties dialog box by clicking the View and edit database properties hyperlink

A

at the Info backstage area.

ETM 1030 (18 decks)

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