Deck 9: Get Connected

Question 1

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

A) Rows
B) Columns
C) Titles
D) Sheets

Answer 1

A

Question 2

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

Answer 2

A

Question 3

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

Answer 3

B

Question 4

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

Question 5

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

A) Form
B) Report
C) Table
D) Macro

Question 6

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.

Question 7

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.

Question 8

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.

Question 9

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

Question 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

Question 11

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

A) ACCDB
B) XLSX
C) DOCX
D) RTF

Question 12

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

Question 13

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.

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

A) Rows
B) Columns
C) Titles
D) Sheets

Question 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

Question 20

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

A) Query
B) Filtered Table
C) Table
D) Subform

Question 21

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

Question 22

What is the default program for opening CSV files?

A) Access
B) Excel
C) Wordpad
D) Notepad

Question 23

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

Question 24

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.

Question 25

XPS is considered an alternative to what file format?

A) TXT
B) RTF
C) PDF
D) DOCX

Question 26

Attaching files increases the size of the database.

Question 27

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.

Question 28

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

Question 29

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.

Question 30

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

Question 31

Who developed the XPS file format?

A) Microsoft
B) Adobe
C) Apple
D) IBM

Question 32

ScreenTips are fixed in Access.

Question 33

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

Question 34

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

A) Form
B) Report
C) Query
D) Table

Question 35

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.

Question 36

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

A) Publisher
B) Notepad
C) Word
D) Outlook

Question 37

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.

Question 38

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

Question 39

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.

Question 40

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

Question 41

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.

Question 42

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.

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

You cannot selectively export form records.

Question 50

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

Question 51

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.

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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.

Question 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.

Question 59

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

Question 60

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

Question 61

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

Question 62

RTF stands for ________ Text Format.

Question 63

RTF stands for Rich ________ Format.

Question 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.

Question 65

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.

Question 66

URL stands for Uniform Resource ________.

Question 67

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

Question 68

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

Question 69

Access uses the ________ icon to indicate attachments.

Question 70

PDF files are more commonly used than XPS documents.

Question 71

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

Question 72

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.

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

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