Question 1

It is not possible to make changes to data in an Access table using an exported static web page in a browser.

Accepted Answer

A) True 
 B)False

Question 2

In the accompanying figure, which numbered arrow indicates the chart legend?

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  4 
A)  1 
B)  2 
C)  3 
D)  4

Question 3

Results returned by the Table Analyzer tool are always appropriate and do not need to be reviewed by the database designer.

Accepted Answer

A) True 
 B)False

Question 4

A(n) ____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

Accepted Answer

The answer of A(n) ____________________ contains tags and other instructions...

Question 5

The data value of each data item in a chart is represented by ____________________.

Accepted Answer

The answer of The data value of each data item...

Question 6

A(n) ____ is a program containing original information or an original object that can be integrated into Access.

Accepted Answer

A)  destination program 
B)  source program 
C)  embedded program 
D)  linked program 
A)  destination program 
B)  source program 
C)  embedded program 
D)  linked program

Question 7

The ____________________ Wizard allows Field Names to be added to text files imported into an Access database if the first row of the imported data does not contain field names.

Accepted Answer

The answer of The ____________________ Wizard allows Field Names to...

Question 8

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.

Accepted Answer

A)  Application Parts gallery 
B)  EXTERNAL DATA gallery 
C)  Templates gallery 
D)  SharePoint Lists 
A)  Application Parts gallery 
B)  EXTERNAL DATA gallery 
C)  Templates gallery 
D)  SharePoint Lists

Question 9

Which of the following is the file extension associated with an Access template?

Accepted Answer

A)  *.accdb 
B)  *.accdt 
C)  *.mdb 
D)  *.dtacc 
A)  *.accdb 
B)  *.accdt 
C)  *.mdb 
D)  *.dtacc

Question 10

It is important to open the ____ file before opening a linked Access table.

Accepted Answer

A)  XSL 
B)  destination file 
C)  source file 
D)  XSD 
A)  XSL 
B)  destination file 
C)  source file 
D)  XSD

Question 11

Values in a CSV file are separated by which symbol?

Accepted Answer

A)  , (comma) 
B)  ; (semi-colon) 
C)  : (colon) 
D)  - (dash) 
A)  , (comma) 
B)  ; (semi-colon) 
C)  : (colon) 
D)  - (dash)

Question 12

The Chart Type window in Microsoft Graph offers the option to create custom chart types.

Accepted Answer

A) True 
 B)False

Question 13

A text file in which each line is a record containing the same number of values in the same position, and the values are separated by commas.

Accepted Answer

A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis 
A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis

Question 14

A database type from which Access accepts imported data.

Accepted Answer

A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis 
A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis

Question 15

A programming language that uses customizable tags to describe the data it contains and how that data should be structured.

Accepted Answer

A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis 
A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis

Question 16

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen, and changes made to the source data will not be reflected in the database..

Accepted Answer

A)  Link to the data source 
B)  Copy the data source 
C)  Append a copy of the records to the table 
D)  Overwrite the records of the table 
A)  Link to the data source 
B)  Copy the data source 
C)  Append a copy of the records to the table 
D)  Overwrite the records of the table

Question 17

A static web page changes any time the data exported to the web page are changed in the Access database.

Accepted Answer

A) True 
 B)False

Question 18

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?

Accepted Answer

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

Question 19

The vertical axis of a chart that contains numbers representing a range of data values in a data series.

Accepted Answer

A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis 
A)  XSD file 
B)  HTML document 
C)  x-axis 
D)  CSV file 
E)  XSL
F) destination program
G) mySQL
H) XML (Extensible Markup Language)
I) source program
J) y-axis

Question 20

In the accompanying figure, which tab control is active?

Accepted Answer

A)  FORM DESIGN TOOLS 
B)  Page 35 
C)  frmVisitsAndInvoices 
D)  Page 34 
A)  FORM DESIGN TOOLS 
B)  Page 35 
C)  frmVisitsAndInvoices 
D)  Page 34

It is not possible to make changes to data in an Access table using an exported static web page in a browser.

In the accompanying figure, which numbered arrow indicates the chart legend?

Results returned by the Table Analyzer tool are always appropriate and do not need to be reviewed by the database designer.

A(n) ____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

The data value of each data item in a chart is represented by ____________________.

A(n) ____ is a program containing original information or an original object that can be integrated into Access.

The ____________________ Wizard allows Field Names to be added to text files imported into an Access database if the first row of the imported data does not contain field names.

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.

Which of the following is the file extension associated with an Access template?

It is important to open the ____ file before opening a linked Access table.

Values in a CSV file are separated by which symbol?

The Chart Type window in Microsoft Graph offers the option to create custom chart types.

A text file in which each line is a record containing the same number of values in the same position, and the values are separated by commas.

A database type from which Access accepts imported data.

A programming language that uses customizable tags to describe the data it contains and how that data should be structured.

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen, and changes made to the source data will not be reflected in the database..

A static web page changes any time the data exported to the web page are changed in the Access database.

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?

The vertical axis of a chart that contains numbers representing a range of data values in a data series.

In the accompanying figure, which tab control is active?

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters

Exam 4: Access: Sharing, Integrating, and Analyzing Data

It is not possible to make changes to data in an Access table using an exported static web page in a browser.

In the accompanying figure, which numbered arrow indicates the chart legend?

Results returned by the Table Analyzer tool are always appropriate and do not need to be reviewed by the database designer.

A(n) ____________________ contains tags and other instructions that a Web browser processes and displays as a Web page.

The data value of each data item in a chart is represented by ____________________.

A(n) ____ is a program containing original information or an original object that can be integrated into Access.

The ____________________ Wizard allows Field Names to be added to text files imported into an Access database if the first row of the imported data does not contain field names.

All application parts created by all users of the Access program are available in all Access database files on the computer and will be visible in the ____.

Which of the following is the file extension associated with an Access template?

It is important to open the ____ file before opening a linked Access table.

Values in a CSV file are separated by which symbol?

The Chart Type window in Microsoft Graph offers the option to create custom chart types.

A text file in which each line is a record containing the same number of values in the same position, and the values are separated by commas.

A database type from which Access accepts imported data.

A programming language that uses customizable tags to describe the data it contains and how that data should be structured.

Access will create a table from data imported from an Excel spreadsheet if the table specified in the Get External Data dialog box does not exist when the ____option is chosen, and changes made to the source data will not be reflected in the database..

A static web page changes any time the data exported to the web page are changed in the Access database.

Which type of file may be used to export an Access report and reduce the file size to minimize downloading time?

The vertical axis of a chart that contains numbers representing a range of data values in a data series.

In the accompanying figure, which tab control is active?

Access: Creating Advanced Queries and Enhancing Table Design

Access: Using Form Tools and Creating Custom Forms

Access: Creating Custom Reports

Excell: Working With Excel Tables, Pivottables, and Pivotcharts

Excell: Managing Multiple Worksheets and Workbooks

Excell: Developing an Excel Application

Excell: Working With Advanced Functions

Powerpoint: Applying Advanced Formatting to Objects

Powerpoint: Advanced Animations and Distributing Presentations

Word: Working With Templates, Themes, and Styles

Word: Using Mail Merge

Word: Collaborating With Others and Integrating Data

Filters