Deck 8: Performing What-If Analyses

Question 1

An advantage of emailing query results as a PDF file is that _____.

A) a PDF file has built-in security features
B) a PDF file is usually smaller than a text file
C) a PDF file is a common data source for mail merge documents
D) anyone can read a PDF file using free Adobe Reader software

Answer 1

D

Question 2

To export query data to Excel, you _____.

A) save the query as an XLSX file
B) click the Create tab, and then click the Excel Query button in the Queries group
C) click the External Data tab, and then click the Excel button in the Export group
D) select Excel as the destination when you run the query

Answer 2

C

Question 3

To use data from an Access form on a webpage, you can _____.

A) copy and paste the data to a blank page in a browser
B) publish the form as a Word file
C) export the data to an HTML document
D) merge the data with a webpage

Answer 3

C

Question 4

Export query data as a(n) _____ file if you want to open the file in a browser.

A) Excel
B) HTML
C) Chrome
D) email

Question 5

Mail fields are codes that Word replaces with field values when processing a mail merge.

Question 6

When you export a query as an HTML document, you are exporting the _____.

A) query design
B) query grid
C) fields in the query
D) query results

Question 7

An HTML document is a text file that uses _____ to mark up content stored in the file.

A) rich text formatting
B) conditional formatting
C) XML tags
D) HTML tags

Question 8

If you export report data as an RTF or XML file, you can open the exported file in a browser.

Question 9

After you export report data to an HTML document, you can _____ the data in a browser.

A) edit
B) format
C) view
D) update

Question 10

A mail merge combines data from an Access table or form into a Word form letter.

Question 11

Export form data to a(n) _____ file to present the data as a webpage for a person, not a program, to read.

A) XML
B) Firefox
C) Excel
D) HTML

Question 12

If you export form data as a(n) _____ file, you can view the data but not change it.

A) Excel
B) PDF
C) text
D) XML

Question 13

If an HTML file uses _____ tags to structure its data, you can import the data as a new Access table.

A) database
B) font
C) import
D) table

Question 14

What Access tool helps you import an HTML document as a new Access table?

A) Application Part
B) Import HTML Wizard
C) table template
D) Publish to HTML Wizard

Question 15

How can you send an open form as an email attachment when you are working in an Access database?

A) Click the Email button on the External Data tab.
B) Click the File tab and then click Send.
C) Drag the form tab to an open email message.
D) Click the Attachment button on the Create tab.

Question 16

If you export a report as a PDF file, other people can edit the report.

Question 17

To export a report as an email attachment, click the _____ button in the Export group on the External Data tab.

A) Send
B) Email
C) Share
D) Attach

Question 18

When you export table data to a PDF file, you need software such as _____ to view the data.

A) Microsoft Excel
B) an Access web template
C) Microsoft Outlook
D) Adobe Reader

Question 19

A common example of delimited text file is a PDF file.

Question 20

When you export an Access table to a(n) _____ file, you have the option to preserve the formatting and layout of the table.

A) PDF
B) XML
C) HTML
D) RTF

Question 21

Before using the Chart Wizard, you should plan which fields you want the chart to display.

Question 22

An Access chart displays data in rows and columns, similar to a spreadsheet.

Question 23

A _____ chart typically shows trends over time.

A) bar
B) line
C) column
D) pie

Question 24

An Access query can be the _____ for a mail merge in Word.

A) main document
B) merge field source
C) data source
D) template

Question 25

A(n) _____ chart typically shows cumulative totals, such as combined sales totals for store locations.

A) pie
B) line
C) area
D) column

Question 26

A chart is a visual representation of numeric data that helps users see comparisons, patterns, and trends in the data.

Question 27

You can create a mail merge in Word using name and address data stored in Access.

Question 28

When you use the Chart Wizard to add a chart to a report, your first step is to select _____.

A) a format for the chart
B) the chart type
C) the table or query containing the data for the chart
D) the chart size

Question 29

The chart type that uses slices to show parts of a whole is a _____ chart.

A) line
B) bar
C) pie
D) column

Question 30

_____ connects an Access database to data in an external file, such as an Excel spreadsheet or Outlook folder, but does not copy the data into the database.

A) Linking
B) Importing
C) Exporting
D) Relating

Question 31

You can use the Chart Wizard to add a chart to a form or query.

Question 32

A delimited text file such as a CSV file stores one _____ on each line.

A) record
B) field
C) table
D) property

Question 33

When you copy data from an external file into an Access database, you are importing the data.

Question 34

How can you close a table named Services when it is displayed in Table Datasheet view?

A) Click the Close button on the title bar.
B) Click the Close 'Services' button in the datasheet.
C) Click the Close Services button in the Navigation Pane.
D) Click the Close Table button on the Home tab.

Question 35

In a CSV text file, a comma often separates each field value from another field value.

Question 36

Run the steps in a saved export using the _____ button on the External Data tab.

A) Saved Exports
B) More
C) Synchronize
D) Rerun

Question 37

Which of the following are ways you can import a CSV file into Access? Select all the options that apply.

A) Select the records to import as a query.
B) Link to the data source by creating a linked table.
C) Import the source data into a new table in the current database.
D) Append a copy of the records to the table.

Question 38

Which chart type uses vertical bars to compare values?

A) pie
B) line
C) bar
D) column

Question 39

A line chart uses horizontal bars to compare values, such as annual sales for a company's sales representatives.

Question 40

A(n) _____ file contains field values separated by a common character such as a comma or tab.

A) CSV
B) ODBC
C) XML
D) RTF

Question 41

A(n) _____ chart best illustrates the contribution of three products to total company sales in a year.

A) pie
B) area
C) line
D) column

Question 42

A(n) _____ is a template for creating a table that contains fields and specifies their data types.

A) Application Part
B) Access web app
C) Navigation form
D) Data Type Wizard

Question 43

An XML file is a text file containing Extensible Markup Language tags that identify field names and data.

Question 44

A SharePoint list is a collection of data that you can share with other people who use the SharePoint site.

Question 45

A(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.

A) HTML
B) delimited
C) XML
D) EML

Question 46

To share form data among two or more programs, export the form as a(n) _____ file.

A) another Access database
B) Excel
C) XML
D) PDF

Question 47

Why is it easy to import XML data into an Access table?

A) All XML files use XML tags to structure data into fields and records.
B) Previous versions of Access created databases in the XML format.
C) XML files contain unstructured data.
D) XML files typically contain numeric data.

Question 48

If you link data to an Access database, you can edit the data in the original file, but not in the Access database.

Question 49

Which of the following types of files does Access create when it exports data to the XML file format? Select all the options that apply.

A) XAM
B) XML
C) XSD
D) XSL

Question 50

Which two properties control how a form and subform are linked?

A) Form and Subform
B) Record Source and Control Source
C) Main Form and Link Subform
D) Link Child Fields and Link Master Fields

Question 51

You use _____ to mark up structured data so you can easily share the data with other programs.

A) XML
B) HTML
C) ODBC
D) dBase

Question 52

The _____ property indicates which field serves the link between the main form and subform.

A) Subform Link
B) Link Master Fields
C) Source Object
D) Primary Key

Question 53

Each page of a(n) _____ control is a container for other controls, such as text boxes or command buttons.

A) attachment
B) tab
C) option group
D) combo box

Question 54

_____ connects an Access database to data in an external file such as an Outlook folder.

A) Importing
B) Linking
C) Delimiting
D) Publishing

Question 55

Which of the following chart types can you add to an Access report? Select all the options that apply.

A) 3-D column chart
B) area chart
C) line chart
D) progress chart

Question 56

When using the Chart Wizard, you can drag a Number field to the Data area of a chart to have the wizard automatically _____ the values in the field.

A) count
B) sum
C) group
D) list

Question 57

To insert a page break in a report in Report Design view, click a section, and then press the CTRL+ENTER keys.

Question 58

When exporting to XML, Access creates an _____ helper file that contains a description of the data's characteristics.

A) XSD
B) XLSX
C) XP
D) HTML

Question 59

You can add one or more _____ to a tab control.

A) property sheets
B) headers
C) pages
D) themes

Question 60

A(n) _____ provides a template for designing a form.

A) Access web app
B) Application Part
C) Quick Style
D) SharePoint server

Question 61

Which of the following types of external files can you link to an Access database? Select all the options that apply.

A) dBase file
B) SharePoint list
C) Word table
D) HTML document

Question 62

You can establish referential integrity with a linked table.