Deck 37: Access: Get Connected: Exchanging Data Between Access and Other Applications

Question 1

What happens each time you open an attachment file in Access?

A)Access creates a temporary file on your computer's hard drive.
B)The attachment opens in Design view.
C)The attachment opens in a form or report.
D)The attachment opens as a hyperlink.

Answer 1

A

Question 2

What type of files are compressed by Access when you attach them?

A)Word and Excel files
B)Word and JPEG files
C)Excel and JPEG files
D)JPEG and other photo formats

Answer 2

A

Question 3

What happens when you export a form with a subform to Excel?

A)The form exports but the subform does not
B)The subform exports but the form does not
C)The results can be unpredictable
D)The original form is deleted when the export is completed

Answer 3

A

Question 4

The objects you select to export from Access to Word should have which of the following types of layout?

A)Tabular
B)Stepped
C)Block
D)Outline

Question 5

How do you insert blank lines above a table after exporting it from Access into Word?

A)Click immediately before the first value in the first cell of the table and press Enter to add an additional line.
B)You will have to cut the table and add a blank line,then paste the table back at the new cursor position.
C)You cannot add additional lines above the table.
D)Additional lines will appear below the table by default.

Question 6

What is the default software application associated with a CSV file?

A)Microsoft Excel
B)Microsoft Word
C)XML Paper Specification
D)Portable Document Format

Question 7

What type of file does Access create when exporting to Word?

A)RTF
B)HTML
C)DOCX
D)JPEG

Question 8

When you double-click on a document with a RTF file extension,which of the following programs does Windows open by default?

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

Question 9

Which of the following file types increases the database size byte for byte when attached in Access?

A)JPEG and other photo formats
B)Word and Excel files
C)Excel and JPEG files
D)Word and JPEG files

Question 10

________ is a useful format for basic formatted text documents such as instruction manuals,resumes,letters,and other documents.

A)RTF
B)HTML
C)DOCX
D)JPEG

Question 11

What is the main reason for exporting data to Excel instead of Word?

A)You are not able to analyze the data as you can in Excel.
B)The data can be manipulated the same as in Excel.
C)Charts can be made in Word just as in Excel.
D)Table information looks the same in both Word and Excel.

Question 12

A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet.

A)hyperlink
B)software application
C)ScreenTip
D)command

Question 13

________ documents cannot be edited after being exported.

A)PDF or XPS
B)HTML or DOCX
C)DOCX or XPS
D)JPEG or PDF

Question 14

Which of the following fields enables you to add multiple files of different types to a table?

A)Attachment
B)Text
C)Caption
D)OLE

Question 15

What happens when you click a hyperlink field value while in Datasheet view?

A)Access launches the program required to display the file or Web page
B)Access adds an attachment to the table
C)Access saves the corresponding file
D)Access creates a ScreenTip that appears when you hover over the hyperlink

Question 16

What differentiates a hyperlink from text?

A)Blue underline
B)Green underline
C)Red underline
D)Black underline

Question 17

How is an attachment field identified in a table?

A)Paperclip
B)Pound sign
C)File icon
D)Open book

Question 18

A(n)________ is the location of a Web site or Web page on the Internet.

A)URL
B)HTTP
C)HTML
D)PDF

Question 19

In Access,what is a reference to an external file called?

A)Attachment
B)Paperclip
C)Field
D)OLE object

Question 20

What do you do if you only want to export part of a table to Excel?

A)Filter the table first
B)You cannot export only part of a table
C)Only reports can be exported
D)Access cannot export to Excel

Question 21

Which of the following allows you to manage attached files in forms and reports?

A)Attachment control
B)Attachment field
C)Attachment file
D)Attached form

Question 22

The ________ file format is considered an alternative to PDF.

A)XPS
B)DOCX
C)XLS
D)RTF

Question 23

What is one reason to import an Excel worksheet into Access instead of linking it?

A)You have more control over the imported data
B)You are still working with a copy of the worksheet and cannot modify it
C)The data looks similar but still does not reside in the database
D)The new worksheet copy is dependent on the original

Question 24

________ are common methods of exchanging information between two computer systems.

A)Text files
B)Excel spreadsheets
C)Access tables
D)Access forms

Question 25

What can you do if a comparable table already exists when you import a spreadsheet?

A)Append a copy of the Excel records to the table
B)Copy the table to Access
C)Link the table to the Access table
D)Export the table to Excel

Question 26

What does Access do when you link a table to another Access database?

A)Creates a new table called a linked table
B)Makes a table in the new database with all the data
C)Imports the table as a text file
D)Imports the table as an Excel spreadsheet

Question 27

________ allows you connect to a table without having to import the table data into your database.

A)Linking
B)Copying
C)Pasting
D)Moving

Question 28

________ allocate a certain number of characters for each field.

A)Fixed-length text files
B)CSV text files
C)Linked files
D)Excel tables

Question 29

When exporting to a PDF,what should you check for when the objects are exported?

A)The number of pages
B)The format of the report
C)The name of the exported file
D)The folder the file was saved to

Question 30

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

A)The size of the database remains the same.
B)The linked table adds space to the database size.
C)The linked table adds space byte for byte.
D)The size of the database decreases in size.

Question 31

Access is not able to ________ an attachment.

A)analyze the data within
B)copy
C)print
D)save

Question 32

What is the purpose of a ScreenTip?

A)It displays when you point your mouse over the hyperlink text
B)It modifies what the user sees in Datasheet view
C)It launches the hyperlink
D)It edits the hyperlink

Question 33

A(n)________ appears next to a linked table name in the Navigation Pane.

A)arrow
B)star
C)pound sign
D)ampersand

Question 34

What happens when you double-click an attachment field in a table?

A)A dialog box opens with options
B)The attachment opens
C)The attachment is removed
D)The attachment is saved to a file

Question 35

Which application allows you to view XPS documents if the XPS viewer has not been installed?

A)Your browser
B)Microsoft Word
C)Microsoft Excel
D)Adobe Acrobat Reader

Question 36

Before linking to a spreadsheet,you must first:

A)make sure the data is organized.
B)make sure there are no blank fields.
C)make sure the names of the tables are the same.
D)all the above are true

Question 37

The ________ file format does not allow you to edit the exported documents.

A)PDF
B)Word
C)Excel
D)RTF

Question 38

The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment.

A)PDF
B)DOCX
C)XLS
D)XML

Question 39

________ uses a comma to separate one column from the next,enabling the receiving software to distinguish one set of field values from the next.

A)CSV text files
B)Fixed-length text files
C)Linked files
D)Excel tables

Question 40

Before exporting a table to another database,what must be done first?

A)A database must be created.
B)A table structure must be created.
C)A form and report structure must be created.
D)Nothing needs to be done beforehand.

Question 41

Once an attachment is added to a database table the file is saved as long as you have clicked the record below the current record.

Question 42

When you export a table to Excel,the field names become the column headings and the records become the rows in the Excel spreadsheet.

Question 43

Word and Excel files are compressed by Access when you attach them.

Question 44

Exporting tables and queries to Excel is usually predictable and consistent because of the similarity between an Access datasheet and an Excel spreadsheet.

Question 45

Exporting data from Access to Excel is generally very complicated because the format of Access is different than Excel.

Question 46

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

Question 47

Once an attachment is added,the only way to delete the attachment is to delete the record.

Question 48

When exporting a table to Excel,all records in the table are exported,even if they are not needed.

Question 49

When exporting from Access to Word,you are not able to analyze the data in Word.

Question 50

When you export a table from Access,the table must be closed for the export to complete.

Question 51

Access creates a temporary file on your computer each time you open an attachment file.

Question 52

Once a hyperlink has been added to a table,it cannot be edited.

Question 53

In a report,click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next.

Question 54

If you want to export specific records in a table to Excel,you can either filter the table or create a query for the needed records.

Question 55

A hyperlink field enables you to attach multiple files of different types.

Question 56

JPEG and other photo formats increase the database size byte for byte.

Question 57

When adding a file to an attachment field,the file is actually copied into the database itself.

Question 58

Rich Text Format (RTF)is a format that enables documents created in one software application to be opened with a different software application.

Question 59

An attachment appears as a paperclip in a table.

Question 60

Saving the export steps is the last step in the export process.

Question 61

After exporting a file,if the document is too wide to display all the text,it will display on two pages.

Question 62

Linking and importing produce the same result in Access.

Question 63

An imported Excel spreadsheet displays in the Navigation Pane as a linked table.

Question 64

A linked table is marked with an asterisk in the Navigation Pane.

Question 65

Columnar forms and reports do not export to Word properly.

Question 66

A linked file opens in Access even though the data resides in an external Excel file.

Question 67

PDF is a file format created by Microsoft.

Question 68

XPS is a file format that displays a printed page onscreen identically on any computer platform.

Question 69

Before exporting a table to another database,the new database has to be created.

Question 70

PDF documents are the preferred format when exporting from Access.

Question 71

When you save an RTF file,you might want to change the file type to a Word document in order to make formatting and editing easier.

Question 72

After you export an Access table to an RTF file,the file cannot be edited in Word.

Question 73

The file extension for a Rich Text Format file is slx.

Question 74

One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data.

Question 75

PDF or XPS documents can be opened by their respective document readers,which are free downloads.

Question 76

When you export a table structure from one Access database to another,the new database has to be created.

Question 77

Tables,queries,forms and reports can all be exported to a PDF or XPS document.

Question 78

For an import to be successful,column headings and data formats should be an exact match,and in the same order,to those in your database.

Question 79

What are the two most common types of text files that can be imported into Access?

Question 80

When exporting data from Access to Word,the default format is ________.