Question 1

Before exporting a table to another database,what must be done first?

Accepted Answer

A) A database must be created. 
B) A table structure must be created. 
C) A form and report structure must be created. 
D) Nothing needs to be done beforehand. 
A) A database must be created. 
B) A table structure must be created. 
C) A form and report structure must be created. 
D) Nothing needs to be done beforehand.

Question 2

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

Accepted Answer

A) True 
 B)False

Question 3

________ allocate a certain number of characters for each field.

Accepted Answer

A) Fixed-length text files 
B) CSV text files 
C) Linked files 
D) Excel tables 
A) Fixed-length text files 
B) CSV text files 
C) Linked files 
D) Excel tables

Question 4

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 5

What is one reason to import an Excel worksheet into Access instead of linking it?

Accepted Answer

A) You have more control over the imported data 
B) You are still working with a copy of the worksheet and cannot modify it 
C) The data looks similar but still does not reside in the database 
D) The new worksheet copy is dependent on the original 
A) You have more control over the imported data 
B) You are still working with a copy of the worksheet and cannot modify it 
C) The data looks similar but still does not reside in the database 
D) The new worksheet copy is dependent on the original

Question 6

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 7

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

Accepted Answer

A) True 
 B)False

Question 8

How is an attachment field identified in a table?

Accepted Answer

A) Paperclip 
B) Pound sign 
C) File icon 
D) Open book 
A) Paperclip 
B) Pound sign 
C) File icon 
D) Open book

Question 9

When adding a file to an attachment field,the file is actually copied into the database itself.

Accepted Answer

A) True 
 B)False

Question 10

When you export a table from Access,the table must be closed for the export to complete.

Accepted Answer

A) True 
 B)False

Question 11

What is the disadvantage of storing attachments in your database?

Accepted Answer

They incre

Question 12

Access is not able to ________ an attachment.

Accepted Answer

A) analyze the data within 
B) copy 
C) print 
D) save 
A) analyze the data within 
B) copy 
C) print 
D) save

Question 13

If a company stores tables in a centralized database,you probably ________ the Access tables from your desktop Access database to the tables in the company's centralized database.

Accepted Answer

The answer of If a company stores tables in a...

Question 14

Which of the following fields enables you to add multiple files of different types to a table?

Accepted Answer

A) Attachment 
B) Text 
C) Caption 
D) OLE 
A) Attachment 
B) Text 
C) Caption 
D) OLE

Question 15

When exporting to a PDF,what should you check for when the objects are exported?

Accepted Answer

A) The number of pages 
B) The format of the report 
C) The name of the exported file 
D) The folder the file was saved to 
A) The number of pages 
B) The format of the report 
C) The name of the exported file 
D) The folder the file was saved to

Question 16

When exporting from Access to Word,you are not able to analyze the data in Word.

Accepted Answer

A) True 
 B)False

Question 17

Columnar forms and reports do not export to Word properly.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

The Answer of data type that enables you to quickly is...

Question 19

What is one of the reasons you import directly into Access from Excel?

Accepted Answer

Once the data is imported,you can append

Question 20

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

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

Before exporting a table to another database,what must be done first?

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

________ allocate a certain number of characters for each field.

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

What is one reason to import an Excel worksheet into Access instead of linking it?

The ________ file format is considered an alternative to PDF.

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

How is an attachment field identified in a table?

When adding a file to an attachment field,the file is actually copied into the database itself.

When you export a table from Access,the table must be closed for the export to complete.

What is the disadvantage of storing attachments in your database?

Access is not able to ________ an attachment.

If a company stores tables in a centralized database,you probably ________ the Access tables from your desktop Access database to the tables in the company's centralized database.

Which of the following fields enables you to add multiple files of different types to a table?

When exporting to a PDF,what should you check for when the objects are exported?

When exporting from Access to Word,you are not able to analyze the data in Word.

Columnar forms and reports do not export to Word properly.

What is one of the reasons you import directly into Access from Excel?

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

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

Word: Desktop Publishing and Graphic Design: Creating a Newsletter, working With Graphics, and Linking Objects

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

Word: Word and the Internet: Web Page Creation and Enhancement, and Blogs

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

Power: Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel: Statistical Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

Access: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters