Question 1

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

Question 2

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

Question 3

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

Question 4

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 5

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

Question 6

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

Question 7

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

Question 8

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 9

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

Question 10

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

Accepted Answer

A)    >
B)    >
C)   
D)    >

Question 11

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

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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

Question 18

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

Accepted Answer

Some import errors are recorded in an er...

Question 19

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

Question 20

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

Accepted Answer

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

Exam 3: Creating and Using Queries

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedMail merge allows you to merge documents...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedSome import errors are recorded in an er...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Mail merge allows you to merge documents...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
Some import errors are recorded in an er...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified