Question 1

After exporting a file, if the document is too wide to display all the text, it will display on two pages.

Accepted Answer

A) True 
 B)False  True

Question 2

What differentiates a hyperlink from text?

Accepted Answer

A)  Blue underline 
B)  Green underline 
C)  Red underline 
D)  Black underline 
A)  Blue underline 
B)  Green underline 
C)  Red underline 
D)  Black underline A

Question 3

What is the default software application associated with a CSV file?

Accepted Answer

A)  Microsoft Excel 
B)  Microsoft Word 
C)  XML Paper Specification 
D)  Portable Document Format 
A)  Microsoft Excel 
B)  Microsoft Word 
C)  XML Paper Specification 
D)  Portable Document Format A

Question 4

What is the disadvantage of storing attachments in your database?

Accepted Answer

They incre

Question 5

A linked table is marked with an asterisk in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 6

A hyperlink field enables you to attach multiple files of different types.

Accepted Answer

A) True 
 B)False

Question 7

When there is a file in the ________ field a paperclip appears in the field.

Accepted Answer

The answer of When there is a file in the...

Question 8

For an import to be successful, column headings and data formats should be an exact match, and in the same order, to those in your database.

Accepted Answer

A) True 
 B)False

Question 9

You can export an Access query to an Excel spreadsheet, but you CANNOT export a report.

Accepted Answer

A) True 
 B)False

Question 10

________ allows you connect to a table without having to import the table data into your database.

Accepted Answer

A)  Linking 
B)  Copying 
C)  Pasting 
D)  Moving 
A)  Linking 
B)  Copying 
C)  Pasting 
D)  Moving

Question 11

If a company stores tables in a centralized database, you probably ________ the Access tables from your desktop Access database to the tables in the company's centralized database.

Accepted Answer

The answer of If a company stores tables in a...

Question 12

What happens each time you open an attachment file in Access?

Accepted Answer

A)  Access creates a temporary file on your computer's hard drive. 
B)  The attachment opens in Design view. 
C)  The attachment opens in a form or report. 
D)  The attachment opens as a hyperlink. 
A)  Access creates a temporary file on your computer's hard drive. 
B)  The attachment opens in Design view. 
C)  The attachment opens in a form or report. 
D)  The attachment opens as a hyperlink.

Question 13

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 14

When you save an RTF file, you might want to change the file type to a Word document in order to make formatting and editing easier.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following file types increases the database size byte for byte when attached in Access?

Accepted Answer

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

Question 16

Columnar forms and reports do not export to Word properly.

Accepted Answer

A) True 
 B)False

Question 17

When exporting data from Access to Word, the default format is ________.

Accepted Answer

Rich Text

Question 18

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 19

Match between columns
                        Premises: linking
portable document format (PDF)
Rich Text Format (RTF)
Text file
XML Paper Specification (XPS)

Accepted Answer

The Answer of a file format created by Adobe Systems is...

Question 20

When displaying a form or report, you would use an attachment control to manage your attached files.

Accepted Answer

A) True 
 B)False

After exporting a file, if the document is too wide to display all the text, it will display on two pages.

What differentiates a hyperlink from text?

What is the default software application associated with a CSV file?

What is the disadvantage of storing attachments in your database?

A linked table is marked with an asterisk in the Navigation Pane.

A hyperlink field enables you to attach multiple files of different types.

When there is a file in the ________ field a paperclip appears in the field.

For an import to be successful, column headings and data formats should be an exact match, and in the same order, to those in your database.

You can export an Access query to an Excel spreadsheet, but you CANNOT export a report.

________ allows you connect to a table without having to import the table data into your database.

If a company stores tables in a centralized database, you probably ________ the Access tables from your desktop Access database to the tables in the company's centralized database.

What happens each time you open an attachment file in Access?

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

When you save an RTF file, you might want to change the file type to a Word document in order to make formatting and editing easier.

Which of the following file types increases the database size byte for byte when attached in Access?

Columnar forms and reports do not export to Word properly.

When exporting data from Access to Word, the default format is ________.

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

When displaying a form or report, you would use an attachment control to manage your attached files.

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

After exporting a file, if the document is too wide to display all the text, it will display on two pages.

What differentiates a hyperlink from text?

What is the default software application associated with a CSV file?

What is the disadvantage of storing attachments in your database?

A linked table is marked with an asterisk in the Navigation Pane.

A hyperlink field enables you to attach multiple files of different types.

When there is a file in the ________ field a paperclip appears in the field.

For an import to be successful, column headings and data formats should be an exact match, and in the same order, to those in your database.

You can export an Access query to an Excel spreadsheet, but you CANNOT export a report.

________ allows you connect to a table without having to import the table data into your database.

If a company stores tables in a centralized database, you probably ________ the Access tables from your desktop Access database to the tables in the company's centralized database.

What happens each time you open an attachment file in Access?

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

When you save an RTF file, you might want to change the file type to a Word document in order to make formatting and editing easier.

Which of the following file types increases the database size byte for byte when attached in Access?

Columnar forms and reports do not export to Word properly.

When exporting data from Access to Word, the default format is ________.

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

When displaying a form or report, you would use an attachment control to manage your attached files.

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