Question 1

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 B

Question 2

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 C

Question 3

________ is the process of copying external data directly into the database.

Accepted Answer

Importing

Question 4

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 5

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 6

Attaching files increases the size of the database.

Accepted Answer

A) True 
 B)False

Question 7

URL is the location of a website or webpage on the Internet.

Accepted Answer

A) True 
 B)False

Question 8

Match the following desired actions with the method used to accomplish those actions:
I. Add a title and formatting to a document in Word from data in Access
II. Add data to a table from a text file
III. Use a table from one database in another database
IV. Make data in a spreadsheet available to Access
V. Add various files to one field in Access
A. Import a text file
B. Add an attachment field
C. Export to Word
D. Export an Access object
E. Import from Excel

Accepted Answer

The answer of Match the following desired actions with the...

Question 9

When a report which has an attachment control is viewed in Print Preview, which attachment displays?

Accepted Answer

A)  All of them 
B)  None of them 
C)  The last one 
D)  The first one 
A)  All of them 
B)  None of them 
C)  The last one 
D)  The first one

Question 10

In a form or report, you can interact with attachments using an attachment ________.

Accepted Answer

The answer of In a form or report, you can...

Question 11

One reason for creating the PDF format was that the user would not need a particular operating system to view the file.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Microsoft ________ is often the default program for opening RTF files.

Accepted Answer

The answer of Microsoft ________ is often the default program...

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

When you export data from Access to Excel, the records in Access become ________ in Excel.

Accepted Answer

The answer of When you export data from Access to...

Question 16

When you export data from Access to Excel, the fields in Access become columns in Excel.

Accepted Answer

A) True 
 B)False

Question 17

Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables, forms, reports) from scratch.

Accepted Answer

A) True 
 B)False

Question 18

What allows you to manage attached files in forms and reports?

Accepted Answer

A)  Attachment control 
B)  Attachment subform/subreport 
C)  Hyperlink control 
D)  Attached File control 
A)  Attachment control 
B)  Attachment subform/subreport 
C)  Hyperlink control 
D)  Attached File control

Question 19

Match the following terms with their descriptions:
I. PDF
II. XPS
III. RTF
IV. CSV
V. URL
A. Useful for basic formatted text documents
B. Created by Adobe Systems
C. Double-clicking will open Excel
D. Considered an alternative to PDF
E. http://www.amazon.com

Accepted Answer

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

Question 20

Access uses the ________ icon to indicate attachments.

Accepted Answer

paperclip,

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

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

________ is the process of copying external data directly into the database.

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

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

Attaching files increases the size of the database.

URL is the location of a website or webpage on the Internet.

When a report which has an attachment control is viewed in Print Preview, which attachment displays?

In a form or report, you can interact with attachments using an attachment ________.

One reason for creating the PDF format was that the user would not need a particular operating system to view the file.

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

Microsoft ________ is often the default program for opening RTF files.

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

When you export data from Access to Excel, the records in Access become ________ in Excel.

When you export data from Access to Excel, the fields in Access become columns in Excel.

Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables, forms, reports) from scratch.

What allows you to manage attached files in forms and reports?

Match the following terms with their descriptions: I. PDF II. XPS III. RTF IV. CSV V. URL A. Useful for basic formatted text documents B. Created by Adobe Systems C. Double-clicking will open Excel D. Considered an alternative to PDF E. http://www.amazon.com

Access uses the ________ icon to indicate attachments.

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

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

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

________ is the process of copying external data directly into the database.

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

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

Attaching files increases the size of the database.

URL is the location of a website or webpage on the Internet.

When a report which has an attachment control is viewed in Print Preview, which attachment displays?

In a form or report, you can interact with attachments using an attachment ________.

One reason for creating the PDF format was that the user would not need a particular operating system to view the file.

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

Microsoft ________ is often the default program for opening RTF files.

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

When you export data from Access to Excel, the records in Access become ________ in Excel.

When you export data from Access to Excel, the fields in Access become columns in Excel.

Exporting objects from one Access database to another often saves time because you do not have to create the objects (tables, forms, reports) from scratch.

What allows you to manage attached files in forms and reports?

Match the following terms with their descriptions: I. PDF II. XPS III. RTF IV. CSV V. URL A. Useful for basic formatted text documents B. Created by Adobe Systems C. Double-clicking will open Excel D. Considered an alternative to PDF E. http://www.amazon.com

Access uses the ________ icon to indicate attachments.

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