Question 1

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

Question 2

What is the default program for opening CSV files?

Accepted Answer

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

Question 3

XPS is considered an alternative to what file format?

Accepted Answer

A)  TXT 
B)  RTF 
C)  PDF 
D)  DOCX 
A)  TXT 
B)  RTF 
C)  PDF 
D)  DOCX C

Question 4

When you change a file that had been attached to a database through the attachment data type and then change that document, the changes will be reflected in the database.

Accepted Answer

A) True 
 B)False

Question 5

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.

Question 6

If you export a form which has a subform from Access to Excel, what happens to the records in the subform?

Accepted Answer

A)  They export as expected. 
B)  They are not exported. 
C)  They are exported to a separate sheet. 
D)  They are exported, but in a separate range on the sheet. 
A)  They export as expected. 
B)  They are not exported. 
C)  They are exported to a separate sheet. 
D)  They are exported, but in a separate range on the sheet.

Question 7

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 8

In order to save time in data entry, it is almost always preferable to export the data as well as the structure when exporting to another database.

Accepted Answer

A) True 
 B)False

Question 9

Manipulating data in Excel is preferable to changing data in Access.

Accepted Answer

A) True 
 B)False

Question 10

What is a ScreenTip?

Accepted Answer

A)  A descriptive text that will display when you need help creating a hyperlink 
B)  A descriptive text that will display when you click on a hyperlink 
C)  A descriptive text that will display when you point to an object or an item on the Ribbon 
D)  A descriptive text that will display when you edit a hyperlink 
A)  A descriptive text that will display when you need help creating a hyperlink 
B)  A descriptive text that will display when you click on a hyperlink 
C)  A descriptive text that will display when you point to an object or an item on the Ribbon 
D)  A descriptive text that will display when you edit a hyperlink

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

Which of the following will the hyperlink data type not link to?

Accepted Answer

A)  File on your computer 
B)  File stored only in RAM 
C)  Website 
D)  Email address 
A)  File on your computer 
B)  File stored only in RAM 
C)  Website 
D)  Email address

Question 13

Which of the following can you do to a linked table from within the destination database?

Accepted Answer

A)  Modify the data type of a field 
B)  Add fields 
C)  Use the data in forms, queries, and reports 
D)  Delete fields 
A)  Modify the data type of a field 
B)  Add fields 
C)  Use the data in forms, queries, and reports 
D)  Delete fields

Question 14

What is the feature which allows a connection to an external database without having to copy all the external records into the current database?

Accepted Answer

A)  Table Relationships 
B)  Copying 
C)  Embedding 
D)  Linking 
A)  Table Relationships 
B)  Copying 
C)  Embedding 
D)  Linking

Question 15

One advantage of linking to an external Excel sheet is that you can edit the data directly in Access instead of having to open the file in Excel and make the changes there.

Accepted Answer

A) True 
 B)False

Question 16

What is not a primary key option when importing a text file into Access?

Accepted Answer

A)  Set no primary key 
B)  Use the first field name as the primary key 
C)  Override the existing primary key numbers 
D)  Allow Access to use the existing primary key if there are no values in the imported data higher than any existing data 
A)  Set no primary key 
B)  Use the first field name as the primary key 
C)  Override the existing primary key numbers 
D)  Allow Access to use the existing primary key if there are no values in the imported data higher than any existing data

Question 17

Unless you filter the table, by default when you export an Access table to Excel, all fields and records are exported.

Accepted Answer

A) True 
 B)False

Question 18

Because RTF is designed to work with several programs, it does not support standard alignment options.

Accepted Answer

A) True 
 B)False

Question 19

Why did Microsoft create the XPS file format?

Accepted Answer

A)  So that files could be password protected more securely 
B)  So that a document viewed in Print Preview would display exactly the same on all computers 
C)  So that additional security measures could be added to a document 
D)  So that more of the formatting would transfer than the RTF standard would allow 
A)  So that files could be password protected more securely 
B)  So that a document viewed in Print Preview would display exactly the same on all computers 
C)  So that additional security measures could be added to a document 
D)  So that more of the formatting would transfer than the RTF standard would allow

Question 20

Which of the following Access objects cannot be exported to Excel?

Accepted Answer

A)  Form 
B)  Report 
C)  Table 
D)  Macro 
A)  Form 
B)  Report 
C)  Table 
D)  Macro

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

What is the default program for opening CSV files?

XPS is considered an alternative to what file format?

When you change a file that had been attached to a database through the attachment data type and then change that document, the changes will be reflected in the database.

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

If you export a form which has a subform from Access to Excel, what happens to the records in the subform?

Who developed the XPS file format?

In order to save time in data entry, it is almost always preferable to export the data as well as the structure when exporting to another database.

Manipulating data in Excel is preferable to changing data in Access.

What is a ScreenTip?

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

Which of the following will the hyperlink data type not link to?

Which of the following can you do to a linked table from within the destination database?

What is the feature which allows a connection to an external database without having to copy all the external records into the current database?

One advantage of linking to an external Excel sheet is that you can edit the data directly in Access instead of having to open the file in Excel and make the changes there.

What is not a primary key option when importing a text file into Access?

Unless you filter the table, by default when you export an Access table to Excel, all fields and records are exported.

Because RTF is designed to work with several programs, it does not support standard alignment options.

Why did Microsoft create the XPS file format?

Which of the following Access objects cannot be exported to Excel?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters

Exam 8: Get Connected

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

What is the default program for opening CSV files?

XPS is considered an alternative to what file format?

When you change a file that had been attached to a database through the attachment data type and then change that document, the changes will be reflected in the database.

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

If you export a form which has a subform from Access to Excel, what happens to the records in the subform?

Who developed the XPS file format?

In order to save time in data entry, it is almost always preferable to export the data as well as the structure when exporting to another database.

Manipulating data in Excel is preferable to changing data in Access.

What is a ScreenTip?

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

Which of the following will the hyperlink data type not link to?

Which of the following can you do to a linked table from within the destination database?

What is the feature which allows a connection to an external database without having to copy all the external records into the current database?

One advantage of linking to an external Excel sheet is that you can edit the data directly in Access instead of having to open the file in Excel and make the changes there.

What is not a primary key option when importing a text file into Access?

Unless you filter the table, by default when you export an Access table to Excel, all fields and records are exported.

Because RTF is designed to work with several programs, it does not support standard alignment options.

Why did Microsoft create the XPS file format?

Which of the following Access objects cannot be exported to Excel?

Introduction to Access

Tables and Queries in Relational Databases

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters