Question 1

Which of the following can you merge together using mail merge?

Accepted Answer

A)  letters 
B)  labels 
C)  envelopes 
D)  all of the above 
A)  letters 
B)  labels 
C)  envelopes 
D)  all of the above

Question 2

What do you need to do prior to importing an Excel file?

Accepted Answer

A)  display Datasheet view 
B)  launch the Import Text Wizard button 
C)  review the XML tags 
D)  ensure that the formatting of the Excel file is correct 
A)  display Datasheet view 
B)  launch the Import Text Wizard button 
C)  review the XML tags 
D)  ensure that the formatting of the Excel file is correct

Question 3

A linked table contains records that you can see and edit.

Accepted Answer

A) True 
 B)False

Question 4

When importing Excel data to a new Access table,which of the following error occurs when the import process fails completely?

Accepted Answer

A)  error with importing the file 
B)  subscript out of range 
C)  primary key error 
D)  truncated text value 
A)  error with importing the file 
B)  subscript out of range 
C)  primary key error 
D)  truncated text value

Question 5

Sometimes data you export from Access needs to be formatted as a text file instead of an Excel file.

Accepted Answer

A) True 
 B)False

Question 6

What is the error log? How is an error log useful?

Accepted Answer

Some import errors are recorded in an er

Question 7

In Access,you use the Save As command to save a copy of your data.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following does Access open when you initiate a mail merge?

Accepted Answer

A)  Microsoft Word Mail Merge Wizard 
B)  Microsoft Access Mail Merge Wizard 
C)  main document 
D)  data source 
A)  Microsoft Word Mail Merge Wizard 
B)  Microsoft Access Mail Merge Wizard 
C)  main document 
D)  data source

Question 9

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

Accepted Answer

A)  You can import an XML data file to append records to an existing table. 
B)  You can import an XML data file to create a new table. 
C)  If changes are made to the XML file after the import process is completed,the changes do not automatically care forward into the Access database. 
D)  all of the above 
A)  You can import an XML data file to append records to an existing table. 
B)  You can import an XML data file to create a new table. 
C)  If changes are made to the XML file after the import process is completed,the changes do not automatically care forward into the Access database. 
D)  all of the above

Question 10

Which of the following are common errors that occur when you are creating a new table or appending to an existing table?

Accepted Answer

A)  missing-data values 
B)  error with importing the file 
C)  missing fields 
D)  all of the above 
A)  missing-data values 
B)  error with importing the file 
C)  missing fields 
D)  all of the above

Question 11

What is mail merge? What steps does the Microsoft Word Mail Merge Wizard walk you through?

Accepted Answer

Mail merge allows you to merge documents

Question 12

If an import process fails completely,the table is not created or updated.

Accepted Answer

A) True 
 B)False

Question 13

When exporting a table or query to an Excel file,which of the following describe some common issues?

Accepted Answer

A)  images are not exported 
B)  data displays in the wrong Excel columns 
C)  formulas used in expressions are not exported,only the result of the calculation is exported 
D)  all of the above 
A)  images are not exported 
B)  data displays in the wrong Excel columns 
C)  formulas used in expressions are not exported,only the result of the calculation is exported 
D)  all of the above

Question 14

Which of the following can you use mail merge to create?

Accepted Answer

A)  name badges 
B)  product tags 
C)  project folder labels 
D)  all of the above 
A)  name badges 
B)  product tags 
C)  project folder labels 
D)  all of the above

Question 15

In a Word document,which of the following are merge fields surrounded by?

Accepted Answer

A)   
B)   > 
C)  [ ] 
D)  ( ) 
A)   
B)   > 
C)  [ ] 
D)  ( )

Question 16

Which of the statements is true about importing a delimited file into an existing table?

Accepted Answer

A)  If the database table already exists,use the append option. 
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 do not automatically carry forward into the Access database. 
D)  all of the above 
A)  If the database table already exists,use the append option. 
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 do not automatically carry forward into the Access database. 
D)  all of the above

Question 17

Which of the following refers to a very common delimited file type?

Accepted Answer

A)  CSV 
B)  TXT 
C)  XML 
D)  XSD 
A)  CSV 
B)  TXT 
C)  XML 
D)  XSD

Question 18

Which of the following is a starting document in a mail merge?

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 19

With labels,which of the following field codes does Word automatically insert at the beginning of each record?

Accepted Answer

A)   > 
B)   > 
C)   
D)   > 
A)   > 
B)   > 
C)   
D)   >

Question 20

Which of the following can you use to create text files?

Accepted Answer

A)  Notepad 
B)  Wordpad 
C)  Microsoft Word 
D)  both A and B 
A)  Notepad 
B)  Wordpad 
C)  Microsoft Word 
D)  both A and B

Which of the following can you merge together using mail merge?

What do you need to do prior to importing an Excel file?

A linked table contains records that you can see and edit.

When importing Excel data to a new Access table,which of the following error occurs when the import process fails completely?

Sometimes data you export from Access needs to be formatted as a text file instead of an Excel file.

What is the error log? How is an error log useful?

In Access,you use the Save As command to save a copy of your data.

Which of the following does Access open when you initiate a mail merge?

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

Which of the following are common errors that occur when you are creating a new table or appending to an existing table?

What is mail merge? What steps does the Microsoft Word Mail Merge Wizard walk you through?

If an import process fails completely,the table is not created or updated.

When exporting a table or query to an Excel file,which of the following describe some common issues?

Which of the following can you use mail merge to create?

In a Word document,which of the following are merge fields surrounded by?

Which of the statements is true about importing a delimited file into an existing table?

Which of the following refers to a very common delimited file type?

Which of the following is a starting document in a mail merge?

With labels,which of the following field codes does Word automatically insert at the beginning of each record?

Which of the following can you use to create text files?

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 can you merge together using mail merge?

What do you need to do prior to importing an Excel file?

A linked table contains records that you can see and edit.

When importing Excel data to a new Access table,which of the following error occurs when the import process fails completely?

Sometimes data you export from Access needs to be formatted as a text file instead of an Excel file.

What is the error log? How is an error log useful?

In Access,you use the Save As command to save a copy of your data.

Which of the following does Access open when you initiate a mail merge?

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

Which of the following are common errors that occur when you are creating a new table or appending to an existing table?

What is mail merge? What steps does the Microsoft Word Mail Merge Wizard walk you through?

If an import process fails completely,the table is not created or updated.

When exporting a table or query to an Excel file,which of the following describe some common issues?

Which of the following can you use mail merge to create?

In a Word document,which of the following are merge fields surrounded by?

Which of the statements is true about importing a delimited file into an existing table?

Which of the following refers to a very common delimited file type?

Which of the following is a starting document in a mail merge?

With labels,which of the following field codes does Word automatically insert at the beginning of each record?

Which of the following can you use to create text files?

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