Question 1

You can export an Access table or form to another Access database.

Accepted Answer

A) True 
 B)False

Question 2

Before exporting a table to another database, what must be done first?

Accepted Answer

A)  A database must be created. 
B)  A table structure must be created. 
C)  A form and report structure must be created. 
D)  Nothing needs to be done beforehand. 
A)  A database must be created. 
B)  A table structure must be created. 
C)  A form and report structure must be created. 
D)  Nothing needs to be done beforehand.

Question 3

________ uses a comma to separate one column from the next, enabling the receiving software to distinguish one set of field values from the next.

Accepted Answer

A)  CSV text files 
B)  Fixed-length text files 
C)  Linked files 
D)  Excel tables 
A)  CSV text files 
B)  Fixed-length text files 
C)  Linked files 
D)  Excel tables

Question 4

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

Accepted Answer

Once the data is imported, you can appen

Question 5

When you double-click on a document with a RTF file extension, which of the following programs does Windows open by default?

Accepted Answer

A)  Word 
B)  Excel 
C)  Notepad 
D)  Wordpad 
A)  Word 
B)  Excel 
C)  Notepad 
D)  Wordpad

Question 6

What happens when you click a hyperlink field value while in Datasheet view?

Accepted Answer

A)  Access launches the program required to display the file or Web page 
B)  Access adds an attachment to the table 
C)  Access saves the corresponding file 
D)  Access creates a ScreenTip that appears when you hover over the hyperlink 
A)  Access launches the program required to display the file or Web page 
B)  Access adds an attachment to the table 
C)  Access saves the corresponding file 
D)  Access creates a ScreenTip that appears when you hover over the hyperlink

Question 7

The ________ file format does not allow you to edit the exported documents.

Accepted Answer

A)  PDF 
B)  Word 
C)  Excel 
D)  RTF 
A)  PDF 
B)  Word 
C)  Excel 
D)  RTF

Question 8

Once a hyperlink has been added to a table, it cannot be edited.

Accepted Answer

A) True 
 B)False

Question 9

What is an imported spreadsheet?

Accepted Answer

A copy of the origin

Question 10

Word and Excel files are compressed by Access when you attach them.

Accepted Answer

A) True 
 B)False

Question 11

A(n) ________ data type enables you to quickly link to any file on your computer or to any Web page on the Internet.

Accepted Answer

The answer of A(n) ________ data type enables you to...

Question 12

How do you insert blank lines above a table after exporting it from Access into Word?

Accepted Answer

A)  Click immediately before the first value in the first cell of the table and press Enter to add an additional line. 
B)  You will have to cut the table and add a blank line, then paste the table back at the new cursor position. 
C)  You cannot add additional lines above the table. 
D)  Additional lines will appear below the table by default. 
A)  Click immediately before the first value in the first cell of the table and press Enter to add an additional line. 
B)  You will have to cut the table and add a blank line, then paste the table back at the new cursor position. 
C)  You cannot add additional lines above the table. 
D)  Additional lines will appear below the table by default.

Question 13

The ________ file format is considered an alternative to PDF.

Accepted Answer

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

Question 14

To remove an attachment from a record, you ________.

Accepted Answer

A)  click the paperclip press Delete 
B)  double-click the paperclip and click Remove 
C)  right-click the paperclip and select Delete from the menu 
D)  right-click the paperclip and select Remove from the menu 
A)  click the paperclip press Delete 
B)  double-click the paperclip and click Remove 
C)  right-click the paperclip and select Delete from the menu 
D)  right-click the paperclip and select Remove from the menu

Question 15

A(n) ________ is the location of a Web site or Web page on the Internet.

Accepted Answer

URL, unifo

Question 16

What type of file does Access create when exporting to Word?

Accepted Answer

A)  RTF 
B)  HTML 
C)  DOCX 
D)  JPEG 
A)  RTF 
B)  HTML 
C)  DOCX 
D)  JPEG

Question 17

What are the two most common types of text files that can be imported into Access?

Accepted Answer

CSV text f

Question 18

A(n) ________ is the location of a Web site or Web page on the Internet.

Accepted Answer

A)  URL 
B)  HTTP 
C)  HTML 
D)  PDF 
A)  URL 
B)  HTTP 
C)  HTML 
D)  PDF

Question 19

When exporting a table to Excel, all records in the table are exported, even if they are not needed.

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A linked file is resident in t

You can export an Access table or form to another Access database.

Before exporting a table to another database, what must be done first?

________ uses a comma to separate one column from the next, enabling the receiving software to distinguish one set of field values from the next.

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

When you double-click on a document with a RTF file extension, which of the following programs does Windows open by default?

What happens when you click a hyperlink field value while in Datasheet view?

The ________ file format does not allow you to edit the exported documents.

Once a hyperlink has been added to a table, it cannot be edited.

What is an imported spreadsheet?

Word and Excel files are compressed by Access when you attach them.

A(n) ________ data type enables you to quickly link to any file on your computer or to any Web page on the Internet.

How do you insert blank lines above a table after exporting it from Access into Word?

The ________ file format is considered an alternative to PDF.

To remove an attachment from a record, you ________.

A(n) ________ is the location of a Web site or Web page on the Internet.

What type of file does Access create when exporting to Word?

What are the two most common types of text files that can be imported into Access?

A(n) ________ is the location of a Web site or Web page on the Internet.

When exporting a table to Excel, all records in the table are exported, even if they are not needed.

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

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

You can export an Access table or form to another Access database.

Before exporting a table to another database, what must be done first?

________ uses a comma to separate one column from the next, enabling the receiving software to distinguish one set of field values from the next.

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

When you double-click on a document with a RTF file extension, which of the following programs does Windows open by default?

What happens when you click a hyperlink field value while in Datasheet view?

The ________ file format does not allow you to edit the exported documents.

Once a hyperlink has been added to a table, it cannot be edited.

What is an imported spreadsheet?

Word and Excel files are compressed by Access when you attach them.

A(n) ________ data type enables you to quickly link to any file on your computer or to any Web page on the Internet.

How do you insert blank lines above a table after exporting it from Access into Word?

The ________ file format is considered an alternative to PDF.

To remove an attachment from a record, you ________.

A(n) ________ is the location of a Web site or Web page on the Internet.

What type of file does Access create when exporting to Word?

What are the two most common types of text files that can be imported into Access?

A(n) ________ is the location of a Web site or Web page on the Internet.

When exporting a table to Excel, all records in the table are exported, even if they are not needed.

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

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