Question 1

Which of the following statements is true about exporting XML data?

Accepted Answer

A)  You can choose to export a form or report. 
B)  You can choose to export a table or query. 
C)  You can export a selected record. 
D)  all of the above 
A)  You can choose to export a form or report. 
B)  You can choose to export a table or query. 
C)  You can export a selected record. 
D)  all of the above

Question 2

When linking to a table in Excel,what is the maximum number of characters that can be stored in a field?

Accepted Answer

A)  55 
B)  155 
C)  255 
D)  355 
A)  55 
B)  155 
C)  255 
D)  355

Question 3

What rules should you keep in mind when you are appending data into an existing table?

Accepted Answer

When you are appending data into an exis

Question 4

Which of the following allows you to merge documents?

Accepted Answer

A)  mail merge 
B)  merge fields 
C)  main document 
D)  data source 
A)  mail merge 
B)  merge fields 
C)  main document 
D)  data source

Question 5

For fixed-width files,or delimited files that do not include field names,Access assigns field names of Field1,Field2,etc.

Accepted Answer

A) True 
 B)False

Question 6

How is data that has been exported to Word formatted in Word?

Accepted Answer

A)  on separate lines 
B)  into paragraphs 
C)  with commas 
D)  as a Word table 
A)  on separate lines 
B)  into paragraphs 
C)  with commas 
D)  as a Word table

Question 7

What do you need to do to import only some of the data in an Excel worksheet?

Accepted Answer

A)  define a named range in Excel 
B)  sort the Excel worksheet 
C)  group the records in the Excel worksheet 
D)  delete those records you don't want to import 
A)  define a named range in Excel 
B)  sort the Excel worksheet 
C)  group the records in the Excel worksheet 
D)  delete those records you don't want to import

Question 8

Which of the following does XML use to define the structure of the data?

Accepted Answer

A)  root tag 
B)  dataroot tag 
C)  tags 
D)  XML tag 
A)  root tag 
B)  dataroot tag 
C)  tags 
D)  XML tag

Question 9

Microsoft Word is the default text editor in Windows.

Accepted Answer

A) True 
 B)False

Question 10

XML is the primary language used to build web pages.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following provides a simple means to create and view an HTML file?

Accepted Answer

A)  Microsoft Word 
B)  Microsoft SharePoint 
C)  Notepad 
D)  all of the above 
A)  Microsoft Word 
B)  Microsoft SharePoint 
C)  Notepad 
D)  all of the above

Question 12

In the Excel file,if you want to make modifications,the linked table must be open in access when you open the Excel file.

Accepted Answer

A) True 
 B)False

Question 13

When importing a worksheet into a new table,the original Excel file is not changed in any way during the process.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following field code characters informs the document to format a number with two decimal places?

Accepted Answer

A)  number sign (#) 
B)  dollar sign ($) 
C)  comma (,) 
D)  .00 
A)  number sign (#) 
B)  dollar sign ($) 
C)  comma (,) 
D)  .00

Question 15

Explain what you know about delimited and fixed-width file formats.

Accepted Answer

Text files are usually created using eit

Question 16

Which of the following statements is true about text files?

Accepted Answer

A)  In a delimited file,the first row of the text file must contain the names of all of the fields in the Access table. 
B)  In a fixed-width file,include field names in the first row. 
C)  In a fixed-width file,ensure that all values are entered in their correct positions in the file. 
D)  all of the above 
A)  In a delimited file,the first row of the text file must contain the names of all of the fields in the Access table. 
B)  In a fixed-width file,include field names in the first row. 
C)  In a fixed-width file,ensure that all values are entered in their correct positions in the file. 
D)  all of the above

Question 17

If changes are made to the XML file after the import process is completed,the changes are automatically carried forward into the Access database.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following statements is not true about importing a delimited file into a new table?

Accepted Answer

A)  If the database table does not already exist,use the import option to create a new table and copy all of the records into the table. 
B)  The original text file is not changed in any way during the process. 
C)  If changes are made to the text file after the import process is completed,the changes automatically carry forward into the Access database. 
D)  Once the delimited text file is ready,you are ready to import the data into the database. 
A)  If the database table does not already exist,use the import option to create a new table and copy all of the records into the table. 
B)  The original text file is not changed in any way during the process. 
C)  If changes are made to the text file after the import process is completed,the changes automatically carry forward into the Access database. 
D)  Once the delimited text file is ready,you are ready to import the data into the database.

Question 19

Which of the following is a main step required to perform a mail merge?

Accepted Answer

A)  select document type 
B)  select starting point 
C)  select recipients 
D)  all of the above 
A)  select document type 
B)  select starting point 
C)  select recipients 
D)  all of the above

Which of the following statements is true about exporting XML data?

When linking to a table in Excel,what is the maximum number of characters that can be stored in a field?

What rules should you keep in mind when you are appending data into an existing table?

Which of the following allows you to merge documents?

For fixed-width files,or delimited files that do not include field names,Access assigns field names of Field1,Field2,etc.

How is data that has been exported to Word formatted in Word?

What do you need to do to import only some of the data in an Excel worksheet?

Which of the following does XML use to define the structure of the data?

Microsoft Word is the default text editor in Windows.

XML is the primary language used to build web pages.

Which of the following provides a simple means to create and view an HTML file?

In the Excel file,if you want to make modifications,the linked table must be open in access when you open the Excel file.

When importing a worksheet into a new table,the original Excel file is not changed in any way during the process.

Which of the following field code characters informs the document to format a number with two decimal places?

Explain what you know about delimited and fixed-width file formats.

Which of the following statements is true about text files?

If changes are made to the XML file after the import process is completed,the changes are automatically carried forward into the Access database.

Which of the following statements is not true about importing a delimited file into a new table?

Which of the following is a main step required to perform a mail merge?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters

Exam 3: Creating and Using Queries

Which of the following statements is true about exporting XML data?

When linking to a table in Excel,what is the maximum number of characters that can be stored in a field?

What rules should you keep in mind when you are appending data into an existing table?

Which of the following allows you to merge documents?

For fixed-width files,or delimited files that do not include field names,Access assigns field names of Field1,Field2,etc.

How is data that has been exported to Word formatted in Word?

What do you need to do to import only some of the data in an Excel worksheet?

Which of the following does XML use to define the structure of the data?

Microsoft Word is the default text editor in Windows.

XML is the primary language used to build web pages.

Which of the following provides a simple means to create and view an HTML file?

In the Excel file,if you want to make modifications,the linked table must be open in access when you open the Excel file.

When importing a worksheet into a new table,the original Excel file is not changed in any way during the process.

Which of the following field code characters informs the document to format a number with two decimal places?

Explain what you know about delimited and fixed-width file formats.

Which of the following statements is true about text files?

If changes are made to the XML file after the import process is completed,the changes are automatically carried forward into the Access database.

Which of the following statements is not true about importing a delimited file into a new table?

Which of the following is a main step required to perform a mail merge?

Creating a Database and Tables

Using Design View, Data Validation, and Relationships

Creating and Using Forms and Reports

Templates, Advanced Relationships, and Macros

Creating Advanced Queries and Reports and Using SQL

Creating Advanced Forms

Integrating Applications

Designing and Managing Databases

Customizing Access and Using Skydrive and Office Web Apps

Filters