Question 1

A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet.

Accepted Answer

A)  hyperlink 
B)  software application 
C)  ScreenTip 
D)  command 
A)  hyperlink 
B)  software application 
C)  ScreenTip 
D)  command

Question 2

________ is a file format used for document exchange independent of software applications and operating systems created by Adobe Systems.

Accepted Answer

PDF,Portab

Question 3

PDF or XPS documents can be opened by their respective document readers,which are free downloads.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

The Answer of a format that enables documents created in is...

Question 5

The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment.

Accepted Answer

A)  PDF 
B)  DOCX 
C)  XLS 
D)  XML 
A)  PDF 
B)  DOCX 
C)  XLS 
D)  XML

Question 6

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 7

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 8

Match between columns
                        Premises: importing
fixed-length text file
CSV text file
attachment field
hyperlink

Accepted Answer

The Answer of allocates a certain number of characters for is...

Question 9

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 quickly...

Question 10

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 11

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 12

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 13

________ are common methods of exchanging information between two computer systems.

Accepted Answer

A)  Text files 
B)  Excel spreadsheets 
C)  Access tables 
D)  Access forms 
A)  Text files 
B)  Excel spreadsheets 
C)  Access tables 
D)  Access forms

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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 17

Columnar forms and reports do not export to Word properly.

Accepted Answer

A) True 
 B)False

Question 18

What does Access do when you link a table to another Access database?

Accepted Answer

A)  Creates a new table called a linked table 
B)  Makes a table in the new database with all the data 
C)  Imports the table as a text file 
D)  Imports the table as an Excel spreadsheet 
A)  Creates a new table called a linked table 
B)  Makes a table in the new database with all the data 
C)  Imports the table as a text file 
D)  Imports the table as an Excel spreadsheet

Question 19

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

Accepted Answer

CSV text f

Question 20

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

A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet.

________ is a file format used for document exchange independent of software applications and operating systems created by Adobe Systems.

PDF or XPS documents can be opened by their respective document readers,which are free downloads.

The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment.

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

What is the purpose of a ScreenTip?

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

The ________ file format is considered an alternative to PDF.

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

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

________ are common methods of exchanging information between two computer systems.

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

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

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.

What does Access do when you link a table to another Access database?

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

Before linking to a spreadsheet,you must first:

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

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

A ________ enables you to quickly link to any file on your computer or to any Web page on the Internet.

________ is a file format used for document exchange independent of software applications and operating systems created by Adobe Systems.

PDF or XPS documents can be opened by their respective document readers,which are free downloads.

The ________ file format was created by Adobe Systems for document exchange independent of software application and operating system environment.

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

What is the purpose of a ScreenTip?

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

The ________ file format is considered an alternative to PDF.

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

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

________ are common methods of exchanging information between two computer systems.

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

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

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.

What does Access do when you link a table to another Access database?

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

Before linking to a spreadsheet,you must first:

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