Question 1

What is the disadvantage of linking an Excel spreadsheet from Access?

Accepted Answer

The file c

Question 2

What can you do if a comparable table already exists when you import a spreadsheet?

Accepted Answer

A)  Append a copy of the Excel records to the table 
B)  Copy the table to Access 
C)  Link the table to the Access table 
D)  Export the table to Excel 
A)  Append a copy of the Excel records to the table 
B)  Copy the table to Access 
C)  Link the table to the Access table 
D)  Export the table to Excel

Question 3

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 4

Why would you want to export an Access report to a PDF?

Accepted Answer

The documents do not require p

Question 5

Which application allows you to view XPS documents if the XPS viewer has not been installed?

Accepted Answer

A)  Your browser 
B)  Microsoft Word 
C)  Microsoft Excel 
D)  Adobe Acrobat Reader 
A)  Your browser 
B)  Microsoft Word 
C)  Microsoft Excel 
D)  Adobe Acrobat Reader

Question 6

The file extension for a Rich Text Format file is slx.

Accepted Answer

A) True 
 B)False

Question 7

When exporting to a PDF, what should you check for when the objects are exported?

Accepted Answer

A)  The number of pages 
B)  The format of the report 
C)  The name of the exported file 
D)  The folder the file was saved to 
A)  The number of pages 
B)  The format of the report 
C)  The name of the exported file 
D)  The folder the file was saved to

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

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 10

Which of the following fields enables you to add multiple files of different types to a table?

Accepted Answer

A)  Attachment 
B)  Text 
C)  Caption 
D)  OLE 
A)  Attachment 
B)  Text 
C)  Caption 
D)  OLE

Question 11

When an Access query is exported to Word, it is saved as a(n) ________ file.

Accepted Answer

A)  RTF 
B)  DOCX 
C)  PDF 
D)  XPS 
A)  RTF 
B)  DOCX 
C)  PDF 
D)  XPS

Question 12

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

Accepted Answer

A)  The size of the database remains the same. 
B)  The linked table adds space to the database size. 
C)  The linked table adds space byte for byte. 
D)  The size of the database decreases in size. 
A)  The size of the database remains the same. 
B)  The linked table adds space to the database size. 
C)  The linked table adds space byte for byte. 
D)  The size of the database decreases in size.

Question 13

A linked file opens in Access even though the data resides in an external Excel file.

Accepted Answer

A) True 
 B)False

Question 14

To open the Attachments dialog box, you ________.

Accepted Answer

A)  point to the paperclip icon and press F2 
B)  click the paperclip icon 
C)  double-click the paperclip icon 
D)  right-click the paperclip icon 
A)  point to the paperclip icon and press F2 
B)  click the paperclip icon 
C)  double-click the paperclip icon 
D)  right-click the paperclip icon

Question 15

When you export a table structure from one Access database to another, the new database has to be created.

Accepted Answer

A) True 
 B)False

Question 16

Once an attachment is added, the only way to delete the attachment is to delete the record.

Accepted Answer

A) True 
 B)False

Question 17

In a report, click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next.

Accepted Answer

A) True 
 B)False

Question 18

PDF is a file format created by Microsoft.

Accepted Answer

A) True 
 B)False

Question 19

Saving the export steps is the last step in the export process.

Accepted Answer

A) True 
 B)False

Question 20

A new attachment field displays as .

Accepted Answer

A) True 
 B)False

What is the disadvantage of linking an Excel spreadsheet from Access?

What can you do if a comparable table already exists when you import a spreadsheet?

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.

Why would you want to export an Access report to a PDF?

Which application allows you to view XPS documents if the XPS viewer has not been installed?

The file extension for a Rich Text Format file is slx.

When exporting to a PDF, what should you check for when the objects are exported?

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

Access is not able to ________ an attachment.

Which of the following fields enables you to add multiple files of different types to a table?

When an Access query is exported to Word, it is saved as a(n) ________ file.

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

A linked file opens in Access even though the data resides in an external Excel file.

To open the Attachments dialog box, you ________.

When you export a table structure from one Access database to another, the new database has to be created.

Once an attachment is added, the only way to delete the attachment is to delete the record.

In a report, click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next.

PDF is a file format created by Microsoft.

Saving the export steps is the last step in the export process.

A new attachment field displays as .

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters

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

What is the disadvantage of linking an Excel spreadsheet from Access?

What can you do if a comparable table already exists when you import a spreadsheet?

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.

Why would you want to export an Access report to a PDF?

Which application allows you to view XPS documents if the XPS viewer has not been installed?

The file extension for a Rich Text Format file is slx.

When exporting to a PDF, what should you check for when the objects are exported?

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

Access is not able to ________ an attachment.

Which of the following fields enables you to add multiple files of different types to a table?

When an Access query is exported to Word, it is saved as a(n) ________ file.

What happens to the size of an Access database when a table is linked to an Excel spreadsheet?

A linked file opens in Access even though the data resides in an external Excel file.

To open the Attachments dialog box, you ________.

When you export a table structure from one Access database to another, the new database has to be created.

Once an attachment is added, the only way to delete the attachment is to delete the record.

In a report, click the next and previous arrows on the Attachment toolbar to advance from one attachment to the next.

PDF is a file format created by Microsoft.

Saving the export steps is the last step in the export process.

A new attachment field displays as .

Introduction to Access: Finding Your Way Through an Access Database

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 Sqlin Access: Advanced Techniques

Office Fundamentals and File Management

Filters