Deck 8: Performing What-If Analyses

Question 1

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

Answer 1

B

Question 2

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

Answer 2

D

Question 3

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

Answer 3

D

Question 4

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 5

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 6

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 7

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 8

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 9

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

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

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

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 13

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

Question 14

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

Question 15

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 16

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 17

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

Question 18

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

Question 19

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 20

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 21

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

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

Question 22

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 23

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 24

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

Question 25

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 26

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 27

Which chart type uses vertical bars to compare values?

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

Question 28

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

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

Question 29

A _____ chart typically shows trends over time.

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

Question 30

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

Question 31

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

Question 32

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 33

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

Question 34

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 35

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 36

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

Question 37

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

Question 38

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 39

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

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

Question 40

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

Question 41

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

Question 42

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

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

Question 43

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

Question 44

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 45

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 46

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

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

Question 47

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

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

Question 48

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

Question 49

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 50

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

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 53

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 54

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 55

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 56

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