Get Connected Chapter.9 Test Bank 1st Edition

Exploring Microsoft Office 365, Access 2019 Comprehensive (Poatsy)

Chapter 9 Get Connected

1) Which of the following is true about the attachment field type?

A) You can only attach one file through the attachment field type.

B) You can attach multiple files, but of only one type of file.

C) You can attach multiple files of various types of files.

D) The attached files are actually links to those files.

Diff: 3

Objective: A8.01 Create a Hyperlink Field

2) What is a ScreenTip?

A) A descriptive text that will display when you need help creating a hyperlink

B) A descriptive text that will display when you click on a hyperlink

C) A descriptive text that will display when you point to an object or an item on the ribbon

D) A descriptive text that will display when you edit a hyperlink

Diff: 1

Objective: A8.01 Create a Hyperlink Field

3) Which of the following will the hyperlink data type not link to?

A) File on your computer

B) File stored only in RAM

C) Website

D) Email address

Diff: 2

Objective: A8.01 Create a Hyperlink Field

4) What is the first step in editing a hyperlink field?

A) Click on the hyperlink and select Edit Hyperlink.

B) Double-click on the hyperlink and select Edit Hyperlink.

C) Right-click on the hyperlink and select Edit Hyperlink.

D) Delete the hyperlink and create it again.

Diff: 2

Objective: A8.01 Create a Hyperlink Field

5) If you want to store the details of website locations, but do not want the values to be actual hyperlinks, you can use what data type instead?

A) File

B) Text

C) Attachment

D) OLE Object

Diff: 2

Objective: A8.01 Create a Hyperlink Field

6) If your database is getting too large, what will not help to reduce the size of the database file?

A) Delete unnecessary attachments

B) Compact your database

C) Delete incorrect attachments

D) Delete unnecessary hyperlinks

Diff: 2

Objective: A8.02 Add an Attachment Field

7) What does the number indicate if you see it in parenthesis to the right of the paperclip icon?

A) Number of attachments in that record

B) Total number of attachments currently in that field

C) Total number of attachments that have been allowed for that field

D) Total number of attachments remained from what has been allowed for that field

Diff: 3

Objective: A8.02 Add an Attachment Field

8) When a report which has an attachment control is viewed in Print Preview, which attachment displays?

A) All of them

B) None of them

C) The last one

D) The first one

Diff: 3

Objective: A8.03 Add Attachment Controls to Forms and Reports

9) When a report which has an attachment control is viewed in Report View, what does the Attachment toolbar not allow you to do?

A) Navigate from one attachment to another

B) Click the paperclip icon to open the Attachments dialog box

C) Delete any attachments

D) Move back and forth through the attachments

Diff: 3

Objective: A8.03 Add Attachment Controls to Forms and Reports

10) What allows you to manage attached files in forms and reports?

A) Attachment control

B) Attachment subform/subreport

C) Hyperlink control

D) Attached File control

Diff: 1

Objective: A8.03 Add Attachment Controls to Forms and Reports

11) When should you not save the export steps?

A) When you will not be repeating the export

B) When you will be repeating the export

C) When the steps are complicated

D) When you are uncertain if you will be repeating the export

Diff: 1

Objective: A8.04 Export Data to Excel

12) When you export data from Access to Excel, the records in Access become what in Excel?

A) Rows

B) Columns

C) Titles

D) Sheets

Diff: 2

Objective: A8.04 Export Data to Excel

13) Which of the following is not a valid data source for exporting to Excel?

A) Query

B) Filtered Table

C) Table

D) Subform

Diff: 1

Objective: A8.04 Export Data to Excel

14) If you export a form which has a subform from Access to Excel, what happens to the records in the subform?

A) They export as expected.

B) They are not exported.

C) They are exported to a separate sheet.

D) They are exported, but in a separate range on the sheet.

Diff: 2

Objective: A8.04 Export Data to Excel

15) Which of the following is not a typical reason to export data from Access to Excel?

A) Excel files are smaller.

B) Allows distribution of data to those who do not have Access

C) Allows the user to take advantage of Excel's charting capabilities

D) It is often easier to run various scenarios in Excel.

Diff: 2

Objective: A8.04 Export Data to Excel

16) Which of the following Access objects cannot be exported to Excel?

A) Form

B) Report

C) Table

D) Macro

Diff: 3

Objective: A8.04 Export Data to Excel

17) When you export data from Access to Excel, the fields in Access become what in Excel?

A) Rows

B) Columns

C) Titles

D) Sheets

Diff: 1

Objective: A8.04 Export Data to Excel

18) When you export from Access into Word, the resultant file is in what format?

A) ACCDB

B) XLSX

C) DOCX

D) RTF

Diff: 1

Objective: A8.05 Export Data to Word

19) RTF does not support which feature?

A) Font definitions

B) Auto updated calculated fields

C) Standard alignment options

D) Basic formatting, such as bold and italics

Diff: 2

Objective: A8.05 Export Data to Word

20) Why did Microsoft create the XPS file format?

A) So that files could be password protected more securely

B) So that a document viewed in Print Preview would display exactly the same on all computers

C) So that additional security measures could be added to a document

D) So that more of the formatting would transfer than the RTF standard would allow

Diff: 3

Objective: A8.06 Export Data to a PDF or XPS Document

21) XPS is considered an alternative to what file format?

A) TXT

B) RTF

C) PDF

D) DOCX

Diff: 3

Objective: A8.06 Export Data to a PDF or XPS Document

22) What Access object can you not selectively export to a PDF or XPS document?

A) Form

B) Report

C) Query

D) Table

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

23) Who developed the XPS file format?

A) Microsoft

B) Adobe

C) Apple

D) IBM

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

24) What is the first step in exporting a table from one database to another database?

A) Delete any unwanted fields in the source table.

B) Create the new database.

C) Temporarily delete any relationships that exist with the source table.

D) Make a copy of the table, then delete all the records in the source table.

Diff: 2

Objective: A8.07 Export Objects to Another Access Database

25) What is the feature which allows a connection to an external database without having to copy all the external records into the current database?

A) Table Relationships

B) Copying

C) Embedding

D) Linking

Diff: 1

Objective: A8.08 Link to an Access Table

26) What query type can you create to assist in copying records from a linked table?

A) Append

B) Update

C) Make table

D) Copy/Paste

Diff: 2

Objective: A8.08 Link to an Access Table

27) Which of the following can you do to a linked table from within the destination database?

A) Modify the data type of a field

B) Add fields

C) Use the data in forms, queries, and reports

D) Delete fields

Diff: 1

Objective: A8.08 Link to an Access Table

28) Which of the following statements is not true about importing an Excel spreadsheet into Access?

A) You have less control over the imported data.

B) It will make the database file size larger.

C) There will be no dependency between the imported data and the original Excel sheet.

D) You have more control over the imported data.

Diff: 2

Objective: A2.03 Import Data From External Sources

29) A CSV file might look like which of the following?

A) Bill Smith 1 Main St

B) Bill, Smith, 1 Main St

C) Bill*Smith*1 Main St

D) Bill Smith 1 Main St

Diff: 1

Objective: A8.11 Import a Text File

30) What is the default program for opening CSV files?

A) Access

B) Excel

C) Wordpad

D) Notepad

Diff: 1

Objective: A8.11 Import a Text File

31) Which of the following is not an option when importing a CSV file into Access?

A) Import into a new table

B) Link to the data source

C) Append a copy to a specific table

D) Replace the records in a specific table

Diff: 2

Objective: A8.11 Import a Text File

32) What is not a primary key option when importing a text file into Access?

A) Set no primary key

B) Use the first field name as the primary key

C) Override the existing primary key numbers

D) Allow Access to use the existing primary key if there are no values in the imported data higher than any existing data

Diff: 2

Objective: A8.11 Import a Text File

33) Which of the following is not true about text files which can be imported into Assess?

A) The two most common are CSV and fixed-length text files.

B) They are normally created manually.

C) They are formatted consistently.

D) They are normally created by software.

Diff: 2

Objective: A8.11 Import a Text File

34) Besides Excel, which program is often used to view the contents of a CSV file?

A) Publisher

B) Notepad

C) Word

D) Outlook

Diff: 2

Objective: A8.11 Import a Text File

35) URL is the location of a website or webpage on the Internet.

Diff: 1

Objective: A8.01 Create a Hyperlink Field

36) ScreenTips are fixed in Access.

Diff: 2

Objective: A8.01 Create a Hyperlink Field

37) When you click a hyperlink value, Access launches the appropriate program, such as a Web browser, Word, or Excel, and enables you to interact with the file.

Diff: 1

Objective: A8.01 Create a Hyperlink Field

38) Just like in Word, when you see a hyperlink in datasheet view, you can follow that hyperlink by holding down the Ctrl key while clicking on the hyperlink.

Diff: 2

Objective: A8.01 Create a Hyperlink Field

39) The hyperlink data type that enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

Diff: 1

Objective: A8.01 Create a Hyperlink Field

40) Attaching files increases the size of the database.

Diff: 2

Objective: A8.02 Add an Attachment Field

41) When you change a file that had been attached to a database through the attachment data type and then change that document, the changes will be reflected in the database.

Diff: 3

Objective: A8.02 Add an Attachment Field

42) In a form or report, you can interact with attachments using an attachment subform.

Diff: 1

Objective: A8.03 Add Attachment Controls to Forms and Reports

43) The attachment field type will allow a user to open and use a file even if the user does not have that application installed.

Diff: 2

Objective: A8.02 Add an Attachment Field

44) Importing an Excel worksheet enables you to modify the data in the imported table in Access.

Diff: 2

Objective: A8.09 Link to and Import an Excel Spreadsheet

45) If you want to attach more than one file to a record, then you need to create multiple fields with the attachment data type.

Diff: 2

Objective: A8.02 Add an Attachment Field

46) If you open and modify an attached file in its associated application, Access will automatically save the modified file back into the database.

Diff: 2

Objective: A8.02 Add an Attachment Field

47) All attachments appear as icons representative of the program that created the file.

Diff: 2

Objective: A8.03 Add Attachment Controls to Forms and Reports

48) Unless you filter the table, by default when you export an Access table to Excel, all fields and records are exported.

Diff: 2

Objective: A8.04 Export Data to Excel

49) You cannot selectively export form records.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

50) If a source document is too wide to fit on one page, then a PDF reader will automatically shrink up the text to make sure it fits on one page.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

51) Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables, forms, reports) from scratch.

Diff: 1

Objective: A8.07 Export Objects to Another Access Database

52) When you export data from Access to Excel, the fields in Access become columns in Excel.

Diff: 2

Objective: A8.04 Export Data to Excel

53) When you export forms and reports from Access to Excel, the results can be unpredictable.

Diff: 1

Objective: A8.04 Export Data to Excel

54) Manipulating data in Excel is preferable to changing data in Access.

Diff: 1

Objective: A8.04 Export Data to Excel

55) Because Word is a part of the Office suite, you can analyze data exported from Access just as easily in Word as you can in Excel.

Diff: 1

Objective: A8.05 Export Data to Word

56) Because RTF is designed to work with several programs, it does not support standard alignment options.

Diff: 2

Objective: A8.05 Export Data to Word

57) Access can only link to one Excel spreadsheet at a time.

Diff: 2

Objective: A8.09 Link to and Import an Excel Spreadsheet

58) When you export Access data to a PDF or XPS document, you are required to purchase a commercial software application to view the information.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

59) One reason for creating the PDF format was that the user would not need one particular program to view the file.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

60) One reason for creating the PDF format was that the user would not need a particular operating system to view the file.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

61) XML Paper Specification (XPS) was designed to display a printed page on a screen identically on any computer platform.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

62) XML Paper Specification (XPS) is a file format designed by Adobe.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

63) PDF files are more commonly used than XPS documents.

Diff: 1

Objective: A8.06 Export Data to a PDF or XPS Document

64) In order to save time in data entry, it is almost always preferable to export the data as well as the structure when exporting to another database.

Diff: 3

Objective: A8.07 Export Objects to Another Access Database

65) When attempting to connect two databases, you cannot link to queries, forms, reports, macros, or modules.

Diff: 2

Objective: A8.07 Export Objects to Another Access Database

66) Linking an Excel spreadsheet to an Access table enables you to update data in the Excel sheet from within Access.

Diff: 3

Objective: A8.09 Link to and Import an Excel Spreadsheet

67) If you want to export several objects from one database to another at the same time, make sure the Multiple Objects check box is checked.

Diff: 3

Objective: A8.07 Export Objects to Another Access Database

68) You can link to the tables in another Access database, as well as queries, forms, reports, macros, or modules in the other database.

Diff: 3

Objective: A8.08 Link to an Access Table

69) One advantage of linking to an external Excel sheet is that you can edit the data directly in Access instead of having to open the file in Excel and make the changes there.

Diff: 3

Objective: A8.09 Link to and Import an Excel Spreadsheet

70) Importing an Excel spreadsheet into Access does not affect the size of the database file.

Diff: 1

Objective: A8.09 Link to and Import an Excel Spreadsheet

71) When you export an object from Access to Word, Access creates a file in Word's native .docx format.

Diff: 1

Objective: A8.05 Export Data to Word

72) URL stands for Uniform Resource ________.

Diff: 1

Objective: A8.01 Create a Hyperlink Field

73) The ________ data type enables you to link to a file on your computer, to a webpage on the Internet, or to an email address.

Diff: 1

Objective: A8.01 Create a Hyperlink Field

74) Access uses the ________ icon to indicate attachments.

Diff: 2

Objective: A8.02 Add an Attachment Field

75) In a form or report, you can interact with attachments using an attachment ________.

Diff: 2

Objective: A8.03 Add Attachment Controls to Forms and Reports

76) When you export data from Access to Excel, the fields in Access become ________ in Excel.

Diff: 2

Objective: A8.04 Export Data to Excel

77) When exporting from Access to Excel, you can use an Access table or ________.

Diff: 2

Objective: A8.04 Export Data to Excel

78) When you export data from Access to Excel, the records in Access become ________ in Excel.

Diff: 2

Objective: A8.04 Export Data to Excel

79) RTF stands for Rich ________ Format.

Diff: 1

Objective: A8.05 Export Data to Word

80) RTF stands for ________ Text Format.

Diff: 1

Objective: A8.05 Export Data to Word

81) Microsoft ________ is often the default program for opening RTF files.

Diff: 1

Objective: A8.05 Export Data to Word

82) PDF stands for Portable Document ________.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

83) If a hyperlink is an email address, Access launches a new email window and automatically enters the email address in the ________ field.

Diff: 2

Objective: A8.01 Create a Hyperlink Field

84) PDF stands for ________ Document Format.

Diff: 2

Objective: A8.06 Export Data to a PDF or XPS Document

85) XPS stands for XML ________ Specification.

Diff: 3

Objective: A8.06 Export Data to a PDF or XPS Document

86) ________ is the process of copying external data directly into the database.

Diff: 2

Objective: A8.08 Link to an Access Table

87) ________ allows you to connect to an external database without having to import the table into your current database.

Diff: 2

Objective: A8.08 Link to an Access Table

88) CSV stands for ________ Separated Values.

Diff: 1

Objective: A8.11 Import a Text File

89) When you export an object from Access to Word, Access creates a file in the ________ format.

Diff: 1

Objective: A8.05 Export Data to Word

90) ________ text files allocate a certain number of characters for each field.

Diff: 2

Objective: A8.11 Import a Text File

91) ________ is the default program for opening CSV files.

Diff: 2

Objective: A8.11 Import a Text File

92) Match the following terms with their descriptions:

I. Attachment controls

II. XPS

III. Attachment field

IV. URL

V. CSV text file

A. Developed by Microsoft

B. Location of a website

C. Used to attach several files to a record

D. Allows you to manage attached files in forms and reports

E. Uses a comma to delineate columns

Diff: 1

Objective: Multiple Objectives

93) Match the following terms with their descriptions:

I. RTF

II. PDF

III. XPS

IV. CSV

V. URL

A. Uses commas to determine columns

B. Enables documents to be created in one program and opened in another

C. Created by Adobe to allow the sharing of files

D. Displays a printed page on screen the same no matter what computer is used

E. Location of a webpage

Diff: 1

Objective: Multiple Objectives

94) Match the following terms with their descriptions:

I. Fixed-length text file

II. Hyperlink

III. Importing

IV. Linking

V. Text file

A. Data type to link to a file on your computer or a webpage

B. Connects to an external file without copying the records to the existing table

C. Common file formats used for exchanging data

D. Copies external data without maintain a link to the external file

E. Allocates a certain number of characters for each field

Diff: 1

Objective: Multiple Objectives

95) Match the following desired actions with the method used to accomplish those actions:

I. Add several pictures to each record

II. Add the capability to jump out to a website easily

III. Add capability of managing attachments on a form

IV. Be able to manipulate a table's data in Excel

V. Be able to view a report the same on any computer

A. Attachment data type

B. Attachment control

C. Export to XPS

D. Export to Excel

E. Hyperlink data type

Diff: 1

Objective: Multiple Objectives

96) Match the following desired actions with the method used to accomplish those actions:

I. Add a title and formatting to a document in Word from data in Access

II. Add data to a table from a text file

III. Use a table from one database in another database

IV. Make data in a spreadsheet available to Access

V. Add various files to one field in Access

A. Import a text file

B. Add an attachment field

C. Export to Word

D. Export an Access object

E. Import from Excel

Diff: 1

Objective: Multiple Objectives

97) Match the following terms with their descriptions:

I. Attachment control

II. Attachment field

III. Fixed-length text file

IV. CSV text file

V. Hyperlink

A. Can take you to a website

B. Uses commas to indicate columns

C. Assigns a number of characters for each field

D. Files which can be launched from Access

E. Allows you to manage attachments in forms and reports

Diff: 1

Objective: Multiple Objectives

98) Match the following terms with their descriptions:

I. PDF

II. XPS

III. RTF

IV. CSV

V. URL

A. Useful for basic formatted text documents

B. Created by Adobe Systems

C. Double-clicking will open Excel

D. Considered an alternative to PDF

E. http://www.amazon.com

Diff: 3

Objective: Multiple Objectives