Deck 9: Importing and Exporting Data

Question 1

When you publish data to Word from Access, an RTF format document is created.

Answer 1

True

Question 2

Databases created by templates can be modified for your specific needs.

Answer 2

True

Question 3

You can establish referential integrity with a linked table.

Answer 3

False

Question 4

Which process is most like copying and pasting?

A) Linking
B) Relating
C) Querying
D) Importing

Question 5

Which of the following options means that if a record on the "one" side of one-to-many relationship is deleted, all records in the "many" table are also deleted?

A) Cascade Repeat Values
B) Cascade Application Parts
C) Cascade Delete Related Records
D) Cascade Delete Related Fields

Question 6

Importing is a process to quickly link to, but not copy data from an external source to an Access database.

Question 7

Which of the following options means that if a value in the primary key field is modified, all values in the foreign key field are automatically updated as well?

A) Cascade Repeat Values
B) Cascade Application Parts
C) Cascade Delete Related Records
D) Cascade Delete Related Fields

Question 8

Cascade Update Related Fields automatically updates the data in the primary key field when the matching foreign key field is changed.

Question 9

Database templates create sample tables and queries, but not forms and reports.

Question 10

Which of the following is NOT a way to set a startup form?

A) Use Access Options
B) Create an AutoExec macro
C) Name a form Startup
D) Each of these methods creates a startup form

Question 11

Cascade Delete Related Records automatically deletes all records in the ____ if the record with the matching key field in a "one" table is deleted.

A) "many" table
B) "one" table
C) database
D) primary key field

Question 12

Enforcing referential integrity helps prevent orphan records from being created in the database.

Question 13

To import data from Excel to Access, you would begin by clicking the ____.

A) Relationships button
B) Foreign key field
C) External Data tab
D) Enforce Referential Integrity button

Question 14

Microsoft often changes and updates online templates.

Question 15

Which type of template creates a traditional Access database?

A) custom Web app
B) Application Parts
C) custom desktop
D) desktop database

Question 16

If you change data in its original location and it is linked to an Access database, you must also update it in the Access database.

Question 17

If referential integrity is applied to a one-to-many relationship, what happens?

A) Connects tables
B) Prevents the creation of orphan records
C) Related fields are updated
D) Related fields are deleted

Question 18

If you link data to an Access database, data can be edited in the original file, but not in the Access database.

Question 19

Exporting is the opposite of importing.

Question 20

One use of a database created by a database template is to help you learn more about Access.

Question 21

ODBC stands for _____.

A) Open Database Communication
B) Object Database Connections
C) Object Database Corrections
D) Open Database Connectivity

Question 22

In the Get External Data - Excel Spreadsheet dialog box, which option would you choose to copy data into a new table in the existing database?

A) Import the source data into a new table in the current database
B) Append a copy of the records to the table
C) Link to the data source by creating a linked table
D) None of the above

Question 23

When you publish to Word from Access, the resulting document is in which file format?

A) Access
B) Word
C) Text
D) RTF

Question 24

A(n)  _____ file contains field values separated by a common character; this could be a comma, tab, dash, or other character.

A) RTF
B) ODBC
C) XML
D) CSV

Question 25

The file format RTF stands for _____.

A) Recordset text format
B) Record type format
C) Rich text format
D) Registered time format

Question 26

The _____ feature determines when a line of text extends into the right margin of the page and automatically forces the text to the next line without pressing [Enter].

A) Mail merge
B) Word wrap
C) Publisher
D) Office Clipboard

Question 27

Once a linked table is related to other objects in a database, it can be a part of _____ that use fields from multiple tables.

A) Forms
B) Queries
C) Neither A nor B
D) Both A and B

Question 28

Codes that are replaced with values in a field during a mail merge process are called ____.

A) Merge fields
B) Export agents
C) OLE fields
D) Hyperlink connections

Question 29

Copying data from an Access object into a different file format is called _____.

A) Linking
B) Exporting
C) Combining
D) Copying

Question 30

Which program would be best suited to entering, editing, and managing large paragraphs of text?

A) Access
B) Excel
C) Outlook
D) Word

Question 31

A common example of a delimited text file is a(n) _____ file.

A) PDF
B) CSV
C) RTF
D) DLT

Question 32

____ makes a duplicate copy of the data in the Access database.

A) Linking
B) Importing
C) Compacting
D) Indexing

Question 33

To set a startup form, click the File tab, then click _____

A) New
B) Account
C) Open
D) Options

Question 34

Which of the following programs is not able to share information with Access?

A) Excel
B) Word
C) Access
D) All can share data with Access

Question 35

To export a report as an email attachment, click the _____ button in the Export group of the tab on the Ribbon.

A) Attach
B) Send
C) Email
D) PDF

Question 36

PDF stands for _____.

A) Portable Document Format
B) Published Data Format
C) Photographic Data File
D) Paired Database File

Question 37

You read a PDF document with _____ software:

A) Adobe Dreamweaver
B) Microsoft Paint
C) Adobe Reader
D) Microsoft Format

Question 38

A feature called ____ helps you copy information from Excel to Access.

A) Shortcut
B) Table Template
C) Import Spreadsheet Wizard
D) Mail Merge Task Pane

Question 39

A(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.

A) XML
B) HTML
C) EML
D) delimited

Question 40

Which of the following is NOT a source from which Access can import data?

A) Excel
B) Outlook folder
C) HTML
D) PDF

Question 41

Kelsey needs to send information from an Access report to her manager.  What is the advantage of sending the report as a PDF?

Question 42

Microsoft _____ is the word-processing program in the Microsoft Office suite.

Question 43

_____ is a process to quickly copy data from an external file into an Access database.

Question 44

Identify three different techniques to copy Access data to other applications.

Question 45

Aaron needs to send information from an Access report to his manager.  What is the advantage of emailing the report as a PDF file?

Question 46

In the Relationships window, a linking line without referential integrity shows the "one" and "many" symbols. _____

Question 47

Word automatic is a feature that determines when a line of text extends into the right margin of the page and automatically forces the text to the next line without pressing [Enter].

Question 48

A(n) _____ text file typically contains one record on each line, with the field values separated by a common character.

Question 49

Microsoft _____ is the spreadsheet program within the Microsoft Office suite.

Question 50

_____ connects an Access database to data in an external file, such as another Access database, Excel spreadsheet, or SQL Server database, but does not copy the data into the database.

Question 51

Some templates are _____  which means they are available to download from the Microsoft Office Online Web site.

Question 52

Linked tables cannot be related to other tables in an Access database. _____

Question 53

Swipe and drop is a technique to copy Access data to another application.

Question 54

The RTF file format can be opened and edited in Microsoft Word . _____

Question 55

Describe when you would use the Saved Exports button on the External Data tab.

Question 56

_____ is a way to copy Access information to another database, spreadsheet, or file format.

Question 57

The Office Clipboard is a tool that helps you copy Access data to other applications.

Question 58

A database _____ is a tool that you use to quickly create a new database based on a particular subject.

Question 59

The merge document is the Word document that contains the standard text for each form letter.

Question 60

Why should Cascade Updated Related Fields and Cascade Delete Related Records be used with caution?

Question 61

Rich Text Format can be opened and edited in Microsoft Word.

Question 62

Describe how Aaron could use the Issues option in the Quick Start category to enhance an existing database.

Question 65

In a Word merge data from an Access table or query is combined into a Word form letter.

Question 66

David is creating  new database.  Discuss a pro and con of creating it from a predeveloped Access database template.

Question 67

Lara works at a large corporation.  Explain how the Application Parts features could help her improve an existing database.

Question 68

Merge fields are codes that are replaced with the field values when the mail merge is processed.

Question 69

Why might you use a database template in a business environment?