Question 1

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

Accepted Answer

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

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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

Accepted Answer

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

Question 8

You can establish referential integrity with a linked table.

Accepted Answer

The answer of You can establish referential integrity with a...

Question 9

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

Accepted Answer

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 10

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.

Accepted Answer

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

Question 11

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

Accepted Answer

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 12

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

Accepted Answer

The answer of A mail merge combines data from an...

Question 13

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

Accepted Answer

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 14

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

Accepted Answer

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

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

The answer of A line chart uses horizontal bars to...

Question 19

To export query data to Excel, you _____.

Accepted Answer

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 20

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

Accepted Answer

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

Exam 8: Performing What-If Analyses