Question 1

One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data.

Accepted Answer

A) True 
 B)False

Question 2

An attachment appears as a paperclip in a table.

Accepted Answer

A) True 
 B)False

Question 3

What is one of the reasons you import directly into Access from Excel?

Accepted Answer

Once the data is imported,you can append

Question 4

When you export a table from Access,the table must be closed for the export to complete.

Accepted Answer

A) True 
 B)False

Question 5

Which of the following allows you to manage attached files in forms and reports?

Accepted Answer

A)  Attachment control 
B)  Attachment field 
C)  Attachment file 
D)  Attached form 
A)  Attachment control 
B)  Attachment field 
C)  Attachment file 
D)  Attached form

Question 6

What is the major difference between a linked file and an imported file?

Accepted Answer

A linked file is resident in t

Question 7

Exporting tables and queries to Excel is usually predictable and consistent because of the similarity between an Access datasheet and an Excel spreadsheet.

Accepted Answer

A) True 
 B)False

Question 8

Tables,queries,forms and reports can all be exported to a PDF or XPS document.

Accepted Answer

A) True 
 B)False

Question 9

What is one reason to import an Excel worksheet into Access instead of linking it?

Accepted Answer

A)  You have more control over the imported data 
B)  You are still working with a copy of the worksheet and cannot modify it 
C)  The data looks similar but still does not reside in the database 
D)  The new worksheet copy is dependent on the original 
A)  You have more control over the imported data 
B)  You are still working with a copy of the worksheet and cannot modify it 
C)  The data looks similar but still does not reside in the database 
D)  The new worksheet copy is dependent on the original

Question 10

Once an attachment is added to a database table the file is saved as long as you have clicked the record below the current record.

Accepted Answer

A) True 
 B)False

Question 11

What is the main reason for exporting data to Excel instead of Word?

Accepted Answer

A)  You are not able to analyze the data as you can in Excel. 
B)  The data can be manipulated the same as in Excel. 
C)  Charts can be made in Word just as in Excel. 
D)  Table information looks the same in both Word and Excel. 
A)  You are not able to analyze the data as you can in Excel. 
B)  The data can be manipulated the same as in Excel. 
C)  Charts can be made in Word just as in Excel. 
D)  Table information looks the same in both Word and Excel.

Question 12

What happens when you export a form with a subform to Excel?

Accepted Answer

A)  The form exports but the subform does not 
B)  The subform exports but the form does not 
C)  The results can be unpredictable 
D)  The original form is deleted when the export is completed 
A)  The form exports but the subform does not 
B)  The subform exports but the form does not 
C)  The results can be unpredictable 
D)  The original form is deleted when the export is completed

Question 13

In Access,what is a reference to an external file called?

Accepted Answer

A)  Attachment 
B)  Paperclip 
C)  Field 
D)  OLE object 
A)  Attachment 
B)  Paperclip 
C)  Field 
D)  OLE object

Question 14

What type of files are compressed by Access when you attach them?

Accepted Answer

A)  Word and Excel files 
B)  Word and JPEG files 
C)  Excel and JPEG files 
D)  JPEG and other photo formats 
A)  Word and Excel files 
B)  Word and JPEG files 
C)  Excel and JPEG files 
D)  JPEG and other photo formats

Question 15

Access is not able to ________ an attachment.

Accepted Answer

A)  analyze the data within 
B)  copy 
C)  print 
D)  save 
A)  analyze the data within 
B)  copy 
C)  print 
D)  save

Question 16

Why is it easy to export Access tables to Excel?

Accepted Answer

The similarity between an Acce

Question 17

Why should you examine the Access table in your source fie before linking it?

Accepted Answer

To make sure the table contain

Question 18

You can ________ information from Access to another file format such as Word,Excel or PDF.

Accepted Answer

The answer of You can ________ information from Access to...

Question 19

Exporting data from Access to Excel is generally very complicated because the format of Access is different than Excel.

Accepted Answer

A) True 
 B)False

Question 20

When adding a file to an attachment field,the file is actually copied into the database itself.

Accepted Answer

A) True 
 B)False

Exam 20: Get Connected: Exchanging Data Between Access and Other Applications

One of the main reasons for importing a spreadsheet into Access is that you have more control over the imported data.

An attachment appears as a paperclip in a table.

What is one of the reasons you import directly into Access from Excel?

When you export a table from Access,the table must be closed for the export to complete.

Which of the following allows you to manage attached files in forms and reports?

What is the major difference between a linked file and an imported file?

Exporting tables and queries to Excel is usually predictable and consistent because of the similarity between an Access datasheet and an Excel spreadsheet.

Tables,queries,forms and reports can all be exported to a PDF or XPS document.

What is one reason to import an Excel worksheet into Access instead of linking it?

Once an attachment is added to a database table the file is saved as long as you have clicked the record below the current record.

What is the main reason for exporting data to Excel instead of Word?

What happens when you export a form with a subform to Excel?

In Access,what is a reference to an external file called?

What type of files are compressed by Access when you attach them?

Access is not able to ________ an attachment.

Why is it easy to export Access tables to Excel?

Why should you examine the Access table in your source fie before linking it?

You can ________ information from Access to another file format such as Word,Excel or PDF.

Exporting data from Access to Excel is generally very complicated because the format of Access is different than Excel.

When adding a file to an attachment field,the file is actually copied into the database itself.

Introduction to Access: Hands-On-Exercise Videos

Tables and Queries in Relational Databases: Hands-On-Exercise Videos

Customize, analyze, and Summarize Query Data: Hands-On-Exercise Videos

Creating and Using Professional Forms and Reports: Hands-On-Exercise Videos

Data Validation and Data Analysis: Hands-On-Exercise Videos

Action and Specialized Queries: Hands-On-Exercise Videos

Advanced Forms and Reports: Hands-On-Exercise Videos

Get Connected: Hands-On-Exercise Videos

Fine-Tuning the Database: Hands-On-Exercise Videos

Using Macros and SQL in Access: Hands-On-Exercise Videos

Introduction to Access: Finding Your Way Through an Access Database

Office Fundamentals and File Management: Hands-On-Exercise Videos

Office Fundamentals and File Management

Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Action and Specialized Queries: Moving Beyond the Select Query

Advanced Forms and Reports: Moving Beyond the Basics

Fine-Tuning the Database: Analyzing and Improving Database Performance

Using Macros and SQL in Access: Advanced Techniques

Filters