Question 1

Some import errors are recorded in an error log table that is automatically created by Access.

Accepted Answer

A) True 
 B)False

Question 2

When exporting from Access to Excel,formulas used in expressions are exported.

Accepted Answer

A) True 
 B)False

Question 3

A linked table provides read-only capabilities within Access.

Accepted Answer

A) True 
 B)False

Question 4

Which of the following are defined by the XML Schema Definition file?

Accepted Answer

A)  details of the table 
B)  details of the field sizes 
C)  details of the field data types 
D)  all of the above

Question 5

Typically a fixed-width file does not include the field names in the first row.

Accepted Answer

A) True 
 B)False

Question 6

The process for importing a fixed-width text file is the same as the process for importing a delimited text file.

Accepted Answer

A) True 
 B)False

Question 7

In HTML,which of the following defines a paragraph and is used to display text on the web page?

Accepted Answer

A)  p tag 
B)  tags 
C)  / 
D)  start tag

Question 8

What must you do in order to export specific records from Access?

Accepted Answer

A)  copy the records you want to export 
B)  select the records you want to export 
C)  move the records you want to export to a separate table 
D)  delete unwanted records before exporting

Question 9

If the data in an Excel column contains mostly numbers,but also includes some dates,every cell in the column will display in the date format.

Accepted Answer

A) True 
 B)False

Question 10

How can you export specific records from Access to Excel?

Accepted Answer

A)  Open the table or query in Datasheet view. 
B)  Select the records you want to export. 
C)  Start the export process after selecting records. 
D)  all of the above

Question 11

What is XML and how does it compare to HTML?

Accepted Answer

The answer of What is XML and how does it...

Question 12

When importing from an Excel file,the first row of the Excel file must contain the names of all of the fields in the Access table.

Accepted Answer

A) True 
 B)False

Question 13

When you initiate a mail merge,Access opens the Microsoft Access Mail Merge Wizard.

Accepted Answer

A) True 
 B)False

Question 14

How can you export Access data to Word?

Accepted Answer

A)  export to PDF format 
B)  export to RTF format 
C)  export to CSV format 
D)  export to HTML format

Question 15

What happens when you choose to export the schema file?

Accepted Answer

A)  an XSD file is created 
B)  an XML file is created 
C)  an XLS file is created 
D)  an MDB file is created

Question 16

Which of the following characters are not allowed in text files?

Accepted Answer

A)  letters A-Z 
B)  numbers 0-9 
C)  bolded characters 
D)  common punctuation marks

Question 17

Explain what you know about creating mailing labels using data from Microsoft Access.

Accepted Answer

The answer of Explain what you know about creating mailing...

Question 18

With labels,Microsoft Word automatically inserts a next record ( >)merge field code.

Accepted Answer

A) True 
 B)False

Question 19

If the data in an Excel column contains some text and some numbers,the #Num! error may display in some cells.

Accepted Answer

A) True 
 B)False

Question 20

Which of the following statements is not true about establishing a link between Access and Excel?

Accepted Answer

A)  A linked table can be edited directly within Access. 
B)  If changes are made to the Excel file after the import process is completed,the changes automatically carry forward into the Access database the next time the table is opened. 
C)  Linking saves space by not having the data stored both in an Excel file and again in an Access table. 
D)  A linked file does not actually contain any records.

Exam 3: Creating and Using Queries

Some import errors are recorded in an error log table that is automatically created by Access.

When exporting from Access to Excel,formulas used in expressions are exported.

A linked table provides read-only capabilities within Access.

Which of the following are defined by the XML Schema Definition file?

Typically a fixed-width file does not include the field names in the first row.

The process for importing a fixed-width text file is the same as the process for importing a delimited text file.

In HTML,which of the following defines a paragraph and is used to display text on the web page?

What must you do in order to export specific records from Access?

If the data in an Excel column contains mostly numbers,but also includes some dates,every cell in the column will display in the date format.

How can you export specific records from Access to Excel?

What is XML and how does it compare to HTML?

When importing from an Excel file,the first row of the Excel file must contain the names of all of the fields in the Access table.

When you initiate a mail merge,Access opens the Microsoft Access Mail Merge Wizard.

How can you export Access data to Word?

What happens when you choose to export the schema file?

Which of the following characters are not allowed in text files?

Explain what you know about creating mailing labels using data from Microsoft Access.

With labels,Microsoft Word automatically inserts a next record (< < NextRecord > >)merge field code.

If the data in an Excel column contains some text and some numbers,the #Num! error may display in some cells.

Which of the following statements is not true about establishing a link between Access and Excel?