Question 1

Match between columns
                        Premises: Add several pictures to each record
Be able to view a report the same on any computer
Add the capability to jump out to a website easily
Add capability of managing attachments on a form
Be able to manipulate a table's data in Excel

Accepted Answer

The Answer of Attachment data type and Hyperlink data type is...

Question 2

When you export from Access into Word,the resultant file is in what format?

Accepted Answer

A) ACCDB 
B) XLSX 
C) DOCX 
D) RTF 
A) ACCDB 
B) XLSX 
C) DOCX 
D) RTF

Question 3

Access can only link to one Excel spreadsheet at a time.

Accepted Answer

A) True 
 B)False

Question 4

If you want to export several objects from one database to another at the same time,make sure the Multiple Objects check box is checked.

Accepted Answer

A) True 
 B)False

Question 5

Because Word is a part of the Office suite,you can analyze data exported from Access just as easily in Word as you can in Excel.

Accepted Answer

A) True 
 B)False

Question 6

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

Question 7

If you open and modify an attached file in its associated application,Access will automatically save the modified file back into the database.

Accepted Answer

A) True 
 B)False

Question 8

RTF stands for ________ Text Format.

Accepted Answer

The answer of RTF stands for ________ Text Format....

Question 9

Match between columns
                        Premises: URL
PDF
XPS
CSV
RTF

Accepted Answer

The Answer of Double-clicking will open Excel and http://www.amazon.com and is...

Question 10

What does the number indicate if you see it in parenthesis to the right of the paperclip icon?

Accepted Answer

A) Number of attachments in that record 
B) Total number of attachments currently in that field 
C) Total number of attachments that have been allowed for that field 
D) Total number of attachments remained from what has been allowed for that field 
A) Number of attachments in that record 
B) Total number of attachments currently in that field 
C) Total number of attachments that have been allowed for that field 
D) Total number of attachments remained from what has been allowed for that field

Question 11

What query type can you create to assist in copying records from a linked table?

Accepted Answer

A) Append 
B) Update 
C) Make table 
D) Copy/Paste 
A) Append 
B) Update 
C) Make table 
D) Copy/Paste

Question 12

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 13

If a source document is too wide to fit on one page,then a PDF reader will automatically shrink up the text to make sure it fits on one page.

Accepted Answer

A) True 
 B)False

Question 14

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 15

When you export data from Access to Excel,the fields in Access become what in Excel?

Accepted Answer

A) Rows 
B) Columns 
C) Titles 
D) Sheets 
A) Rows 
B) Columns 
C) Titles 
D) Sheets

Question 16

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

Question 17

If your database is getting too large,what will not help to reduce the size of the database file?

Accepted Answer

A) Delete unnecessary attachments 
B) Compact your database 
C) Delete incorrect attachments 
D) Delete unnecessary hyperlinks 
A) Delete unnecessary attachments 
B) Compact your database 
C) Delete incorrect attachments 
D) Delete unnecessary hyperlinks

Question 18

When you export forms and reports from Access to Excel,the results can be unpredictable.

Accepted Answer

A) True 
 B)False

Question 19

Match between columns
                        Premises: Attachment field
CSV text file
URL
Attachment controls
XPS

Accepted Answer

The Answer of Allows you to manage attached files in is...

Question 20

A CSV file might look like which of the following?

Accepted Answer

A) Bill Smith 1 Main St 
B) Bill,Smith,1 Main St 
C) Bill*Smith*1 Main St 
D) Bill Smith 1 Main .St 
A) Bill Smith 1 Main St 
B) Bill,Smith,1 Main St 
C) Bill*Smith*1 Main St 
D) Bill Smith 1 Main .St

When you export from Access into Word,the resultant file is in what format?

Access can only link to one Excel spreadsheet at a time.

If you want to export several objects from one database to another at the same time,make sure the Multiple Objects check box is checked.

Because Word is a part of the Office suite,you can analyze data exported from Access just as easily in Word as you can in Excel.

XPS is considered an alternative to what file format?

If you open and modify an attached file in its associated application,Access will automatically save the modified file back into the database.

RTF stands for ________ Text Format.

What does the number indicate if you see it in parenthesis to the right of the paperclip icon?

What query type can you create to assist in copying records from a linked table?

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

If a source document is too wide to fit on one page,then a PDF reader will automatically shrink up the text to make sure it fits on one page.

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

When you export data from Access to Excel,the fields in Access become what in Excel?

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

If your database is getting too large,what will not help to reduce the size of the database file?

When you export forms and reports from Access to Excel,the results can be unpredictable.

A CSV file might look like which of the following?

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

When you export from Access into Word,the resultant file is in what format?

Access can only link to one Excel spreadsheet at a time.

If you want to export several objects from one database to another at the same time,make sure the Multiple Objects check box is checked.

Because Word is a part of the Office suite,you can analyze data exported from Access just as easily in Word as you can in Excel.

XPS is considered an alternative to what file format?

If you open and modify an attached file in its associated application,Access will automatically save the modified file back into the database.

RTF stands for ________ Text Format.

What does the number indicate if you see it in parenthesis to the right of the paperclip icon?

What query type can you create to assist in copying records from a linked table?

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

If a source document is too wide to fit on one page,then a PDF reader will automatically shrink up the text to make sure it fits on one page.

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

When you export data from Access to Excel,the fields in Access become what in Excel?

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

If your database is getting too large,what will not help to reduce the size of the database file?

When you export forms and reports from Access to Excel,the results can be unpredictable.

A CSV file might look like which of the following?

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