Question 1

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 2

A(n) ________ appears next to a linked table name in the Navigation Pane.

Accepted Answer

A)  arrow 
B)  star 
C)  pound sign 
D)  ampersand 
A)  arrow 
B)  star 
C)  pound sign 
D)  ampersand

Question 3

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

Accepted Answer

The answer of The Access data type that enables you...

Question 4

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 5

Match the following terms with their meanings:
I. attachment field
II. CSV text file
III. fixed-length text file
IV. hyperlink
V. importing
A. data type that enables you to quickly link to any file on your computer or any Web page on the Internet
B. is used it to attach multiple files of any format and then launch those files from within Access
C. enables you to copy external data into your database without linking it to your source file
D. uses a comma to separate one column from another, enabling the receiving software to distinguish one set of field values from the next
E. allocates a certain number of characters for each field

Accepted Answer

The answer of Match the following terms with their meanings:
I....

Question 6

How is an attachment field identified in a table?

Accepted Answer

A)  Paperclip 
B)  Pound sign 
C)  File icon 
D)  Open book 
A)  Paperclip 
B)  Pound sign 
C)  File icon 
D)  Open book

Question 7

Before linking to a spreadsheet, you must first:

Accepted Answer

A)  make sure the data is organized. 
B)  make sure there are no blank fields. 
C)  make sure the names of the tables are the same. 
D)  all the above are true 
A)  make sure the data is organized. 
B)  make sure there are no blank fields. 
C)  make sure the names of the tables are the same. 
D)  all the above are true

Question 8

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 9

________ allocate a certain number of characters for each field.

Accepted Answer

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

Question 10

An imported Excel spreadsheet displays in the Navigation Pane as a linked table.

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

You CANNOT export Access data to a(n) ________.

Accepted Answer

A)  Excel spreadsheet 
B)  Word document 
C)  Access table 
D)  PowerPoint presentation 
A)  Excel spreadsheet 
B)  Word document 
C)  Access table 
D)  PowerPoint presentation

Question 13

Match the following terms with their meanings:
I. linking
II. portable document format (PDF)
III. Rich Text Format (RTF)
IV. Text file
V. XML Paper Specification (XPS)
A. a file format created by Adobe Systems for document exchange independent of software application and operating system environment
B. a file format developed by Microsoft and designed to display a printed page onscreen identically on any computer platform
C. a format that enables documents created in one software application to be opened with a different software application
D. format that enables documents created in one software application to be opened with a different software application
E. process that enables you to connect to a table without having to import the table data into your database

Accepted Answer

The answer of Match the following terms with their meanings:
I....

Question 14

Linking and importing produce the same result in Access.

Accepted Answer

A) True 
 B)False

Question 15

What is the purpose of a ScreenTip?

Accepted Answer

A)  It displays when you point your mouse over the hyperlink text 
B)  It modifies what the user sees in Datasheet view 
C)  It launches the hyperlink 
D)  It edits the hyperlink 
A)  It displays when you point your mouse over the hyperlink text 
B)  It modifies what the user sees in Datasheet view 
C)  It launches the hyperlink 
D)  It edits the hyperlink

Question 16

The ________ data type is used to create a link to a Web site.

Accepted Answer

A)  Internet link 
B)  external link 
C)  hyperlink 
D)  Web link 
A)  Internet link 
B)  external link 
C)  hyperlink 
D)  Web link

Question 17

If you want to share an Access report with someone who does not have Microsoft Office, you can export the report as a(n) ________ file.

Accepted Answer

A)  XLXS 
B)  DOCX 
C)  DOC 
D)  PDF 
A)  XLXS 
B)  DOCX 
C)  DOC 
D)  PDF

Question 18

JPEG and other photo formats increase the database size byte for byte.

Accepted Answer

A) True 
 B)False

Question 19

Before exporting a table to another database, the new database has to be created.

Accepted Answer

A) True 
 B)False

Question 20

When editing a hyperlink, it is enclosed in ________, which Access uses to activate the link when clicked.

Accepted Answer

A)  quotation marks (") 
B)  asterisks (*) 
C)  ampersands (&) 
D)  pound signs (#) 
A)  quotation marks (") 
B)  asterisks (*) 
C)  ampersands (&) 
D)  pound signs (#)

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

A(n) ________ appears next to a linked table name in the Navigation Pane.

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

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

How is an attachment field identified in a table?

Before linking to a spreadsheet, you must first:

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

________ allocate a certain number of characters for each field.

An imported Excel spreadsheet displays in the Navigation Pane as a linked table.

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

You CANNOT export Access data to a(n) ________.

Linking and importing produce the same result in Access.

What is the purpose of a ScreenTip?

The ________ data type is used to create a link to a Web site.

If you want to share an Access report with someone who does not have Microsoft Office, you can export the report as a(n) ________ file.

JPEG and other photo formats increase the database size byte for byte.

Before exporting a table to another database, the new database has to be created.

When editing a hyperlink, it is enclosed in ________, which Access uses to activate the link when clicked.

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

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

A(n) ________ appears next to a linked table name in the Navigation Pane.

The Access data type that enables you to link to any file on your computer or any Web site on the Internet is called ________.

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

How is an attachment field identified in a table?

Before linking to a spreadsheet, you must first:

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

________ allocate a certain number of characters for each field.

An imported Excel spreadsheet displays in the Navigation Pane as a linked table.

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

You CANNOT export Access data to a(n) ________.

Linking and importing produce the same result in Access.

What is the purpose of a ScreenTip?

The ________ data type is used to create a link to a Web site.

If you want to share an Access report with someone who does not have Microsoft Office, you can export the report as a(n) ________ file.

JPEG and other photo formats increase the database size byte for byte.

Before exporting a table to another database, the new database has to be created.

When editing a hyperlink, it is enclosed in ________, which Access uses to activate the link when clicked.

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