Question 1

RTF does not support which feature?

Accepted Answer

A) Font definitions 
B) Auto updated calculated fields 
C) Standard alignment options 
D) Basic formatting,such as bold and italics 
A) Font definitions 
B) Auto updated calculated fields 
C) Standard alignment options 
D) Basic formatting,such as bold and italics

Question 2

PDF stands for ________ Document Format.

Accepted Answer

The answer of PDF stands for ________ Document Format....

Question 3

All attachments appear as icons representative of the program that created the file.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Use a table from one database in another database
Add various files to one field in Access
Add a title and formatting to a document in Word from data in Access
Add data to a table from a text file
Make data in a spreadsheet available to Access

Accepted Answer

The Answer of Export to Word and Import from Excel is...

Question 5

What is the first step in exporting a table from one database to another database?

Accepted Answer

A) Delete any unwanted fields in the source table. 
B) Create the new database. 
C) Temporarily delete any relationships that exist with the source table. 
D) Make a copy of the table,then delete all the records in the source table. 
A) Delete any unwanted fields in the source table. 
B) Create the new database. 
C) Temporarily delete any relationships that exist with the source table. 
D) Make a copy of the table,then delete all the records in the source table.

Question 6

Just like in Word,when you see a hyperlink in datasheet view,you can follow that hyperlink by holding down the Ctrl key while clicking on the hyperlink.

Accepted Answer

A) True 
 B)False

Question 7

When attempting to connect two databases,you cannot link to queries,forms,reports,macros,or modules.

Accepted Answer

A) True 
 B)False

Question 8

When you click a hyperlink value,Access launches the appropriate program,such as a Web browser,Word,or Excel,and enables you to interact with the file.

Accepted Answer

A) True 
 B)False

Question 9

When should you not save the export steps?

Accepted Answer

A) When you will not be repeating the export 
B) When you will be repeating the export 
C) When the steps are complicated 
D) When you are uncertain if you will be repeating the export 
A) When you will not be repeating the export 
B) When you will be repeating the export 
C) When the steps are complicated 
D) When you are uncertain if you will be repeating the export

Question 10

Access uses the ________ icon to indicate attachments.

Accepted Answer

paperclip,

Question 11

Which of the following is not true about text files which can be imported into Assess?

Accepted Answer

A) The two most common are CSV and fixed-length text files. 
B) They are normally created manually. 
C) They are formatted consistently. 
D) They are normally created by software. 
A) The two most common are CSV and fixed-length text files. 
B) They are normally created manually. 
C) They are formatted consistently. 
D) They are normally created by software.

Question 12

Who developed the XPS file format?

Accepted Answer

A) Microsoft 
B) Adobe 
C) Apple 
D) IBM 
A) Microsoft 
B) Adobe 
C) Apple 
D) IBM

Question 13

Which of the following is not an option when importing a CSV file into Access?

Accepted Answer

A) Import into a new table 
B) Link to the data source 
C) Append a copy to a specific table 
D) Replace the records in a specific table 
A) Import into a new table 
B) Link to the data source 
C) Append a copy to a specific table 
D) Replace the records in a specific table

Question 14

XML Paper Specification (XPS)is a file format designed by Adobe.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is not a valid data source for exporting to Excel?

Accepted Answer

A) Query 
B) Filtered Table 
C) Table 
D) Subform 
A) Query 
B) Filtered Table 
C) Table 
D) Subform

Question 16

If you want to attach more than one file to a record,then you need to create multiple fields with the attachment data type.

Accepted Answer

A) True 
 B)False

Question 17

Importing an Excel worksheet enables you to modify the data in the imported table in Access.

Accepted Answer

A) True 
 B)False

Question 18

PDF stands for Portable Document ________.

Accepted Answer

The answer of PDF stands for Portable Document ________....

Question 19

Which of the following statements is not true about importing an Excel spreadsheet into Access?

Accepted Answer

A) You have less control over the imported data. 
B) It will make the database file size larger. 
C) There will be no dependency between the imported data and the original Excel sheet. 
D) You have more control over the imported data. 
A) You have less control over the imported data. 
B) It will make the database file size larger. 
C) There will be no dependency between the imported data and the original Excel sheet. 
D) You have more control over the imported data.

Question 20

Which of the following is true about the attachment field type?

Accepted Answer

A) You can only attach one file through the attachment field type. 
B) You can attach multiple files,but of only one type of file. 
C) You can attach multiple files of various types of files. 
D) The attached files are actually links to those files. 
A) You can only attach one file through the attachment field type. 
B) You can attach multiple files,but of only one type of file. 
C) You can attach multiple files of various types of files. 
D) The attached files are actually links to those files.

RTF does not support which feature?

PDF stands for ________ Document Format.

All attachments appear as icons representative of the program that created the file.

What is the first step in exporting a table from one database to another database?

Just like in Word,when you see a hyperlink in datasheet view,you can follow that hyperlink by holding down the Ctrl key while clicking on the hyperlink.

When attempting to connect two databases,you cannot link to queries,forms,reports,macros,or modules.

When you click a hyperlink value,Access launches the appropriate program,such as a Web browser,Word,or Excel,and enables you to interact with the file.

When should you not save the export steps?

Access uses the ________ icon to indicate attachments.

Which of the following is not true about text files which can be imported into Assess?

Who developed the XPS file format?

Which of the following is not an option when importing a CSV file into Access?

XML Paper Specification (XPS)is a file format designed by Adobe.

Which of the following is not a valid data source for exporting to Excel?

If you want to attach more than one file to a record,then you need to create multiple fields with the attachment data type.

Importing an Excel worksheet enables you to modify the data in the imported table in Access.

PDF stands for Portable Document ________.

Which of the following statements is not true about importing an Excel spreadsheet into Access?

Which of the following is true about the attachment field type?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 9: Get Connected

RTF does not support which feature?

PDF stands for ________ Document Format.

All attachments appear as icons representative of the program that created the file.

What is the first step in exporting a table from one database to another database?

Just like in Word,when you see a hyperlink in datasheet view,you can follow that hyperlink by holding down the Ctrl key while clicking on the hyperlink.

When attempting to connect two databases,you cannot link to queries,forms,reports,macros,or modules.

When you click a hyperlink value,Access launches the appropriate program,such as a Web browser,Word,or Excel,and enables you to interact with the file.

When should you not save the export steps?

Access uses the ________ icon to indicate attachments.

Which of the following is not true about text files which can be imported into Assess?

Who developed the XPS file format?

Which of the following is not an option when importing a CSV file into Access?

XML Paper Specification (XPS)is a file format designed by Adobe.

Which of the following is not a valid data source for exporting to Excel?

If you want to attach more than one file to a record,then you need to create multiple fields with the attachment data type.

Importing an Excel worksheet enables you to modify the data in the imported table in Access.

PDF stands for Portable Document ________.

Which of the following statements is not true about importing an Excel spreadsheet into Access?

Which of the following is true about the attachment field type?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Query Calculations and Expressions

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Enhanced Database Techniques

Filters