Deck 9: Get Connected

Question 1

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

Answer 1

D

Question 2

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 2

B

Question 3

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.

Answer 3

B

Question 4

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 5

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

Question 6

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 7

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 8

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 9

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 10

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

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

Question 11

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 12

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

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

Question 13

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 14

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 15

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 16

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

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 19

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

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

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

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

Question 22

ScreenTips are fixed in Access.

Question 23

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 24

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 25

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 26

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

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

Question 27

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 28

XPS is considered an alternative to what file format?

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

Question 29

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 30

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

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

Question 31

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 32

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 33

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 34

Attaching files increases the size of the database.

Question 35

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 36

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 37

What is the default program for opening CSV files?

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

Question 38

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 39

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 40

Who developed the XPS file format?

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

Question 41

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

Question 42

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

Question 43

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 44

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 45

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

Question 46

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

Question 47

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 48

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

Question 49

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

Question 50

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

Question 51

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

Question 52

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 53

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

Question 54

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

Question 55

You cannot selectively export form records.

Question 56

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

Question 57

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

Question 58

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 59

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 60

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 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

PDF files are more commonly used than XPS documents.

Question 67

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 68

URL stands for Uniform Resource ________.

Question 69

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

Question 70

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

Question 71

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 72

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

Question 73

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

Question 74

RTF stands for Rich ________ Format.

Question 75

Access uses the ________ icon to indicate attachments.

Question 76

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

Question 77

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

Question 78

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

Question 79

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 80

RTF stands for ________ Text Format.