Deck 10: Importing and Exporting Data

Question 1

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

Answer 1

A

Question 2

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

Answer 2

False

Question 3

Which type of template creates a traditional Access database?

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

Answer 3

D

Question 4

Exporting is the opposite of importing.

Question 5

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

Question 6

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 7

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

Question 8

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 9

In the figure above, the relationship between the Courses and Materials tables is a(n) ____.

A) One-to-many relationship with referential integrity
B) Many-to-many relationship
C) Cascade Update Related Fields option
D) Cascade Delete Related Records option

Question 10

Microsoft often changes and updates online templates.

Question 11

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

Question 12

In the figure above, the relationship between the Courses and Materials tables does not include the enforce referential integrity option.

Question 13

In the figure above, the Departments field list is probably a _____

A) Linked table
B) Many-to-many relationship
C) Cascade Update Related Fields option
D) Cascade Delete Related Records option

Question 14

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 15

You can establish referential integrity with a linked table.

Question 16

Enforce Referential Integrity helps prevent records in the "many" table that don't have a matching record in the "one" table.

Question 17

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

Question 18

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

Question 19

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 20

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

Question 21

In the figure above, which button would you use if you wanted to create a custom letter in Word addressed to each customer in a Customers table?

A) 4
B) 5
C) 6
D) 7

Question 22

In the figure above, item 3 points to the ____.

A) Import from Excel spreadsheet button
B) Import from workbook button
C) Merge to Excel workbook button
D) Export to Excel spreadsheet button

Question 23

Which process is most like copying and pasting?

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

Question 24

In the figure above, item 3 points to the ____.

A) Import from Excel spreadsheet button
B) Import from workbook button
C) Merge to Excel workbook button
D) Export to Excel spreadsheet button

Question 25

ODBC stands for _____.

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

Question 26

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

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

Question 27

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

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

Question 28

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

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

Question 29

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 30

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 31

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 32

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 33

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 34

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 35

In the figure above, which item would help you copy data from another database into Access?

A) 2
B) 3
C) 4
D) 5

Question 36

In the figure above, which item would help you copy data from Excel into Access?

A) 1
B) 2
C) 3
D) 4

Question 37

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 38

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

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

Question 39

In the figure above, items 3, 4, 5, and 6 help you ____.

A) Export data from Access to another file
B) Import data from Access to another file
C) Link to data from another file into Access
D) Copy data from another file into Access

Question 40

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

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

Question 41

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 42

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

Question 43

_____ 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 44

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

Question 45

The file format RTF stands for _____.

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

Question 46

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

Question 47

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

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

Question 48

Describe when you would use the Saved Exports button on the EXTERNAL DATA tab.

Question 49

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

Question 50

In the figure shown, 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 51

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

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

Question 52

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

Question 53

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

Question 54

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 55

In the figure above, in the relationship that uses the CourseID field, the _____ table serves as the "one" side of the links.

Question 56

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

Question 57

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 58

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

Question 59

PDF stands for _____.

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

Question 60

You read a PDF document with _____ software:

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

Question 61

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

Question 62

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

Question 63

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 64

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

Question 65

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

Question 66

In the figure, chose the Import option to copy records from one source to another.

Question 67

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

Question 68

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

Question 69

Match the following terms with the best choice.
a.Importing
c.Linking
b.Exporting
d.Mail merging
Copying data from Access to an external file

Question 70

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

Question 71

Match each term with the best description.
a.Main document
c.Mail merge
b.Merge field
d.Mail Merge task pane
Word document that contains the standard text for each mail-merge letter/label

Question 72

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

Question 73

Match the following terms with the best choice.
a.Importing
c.Linking
b.Exporting
d.Mail merging
Combining data from Access to a Word form letter, label, or envelope

Question 74

Match the following terms with the best choice.
a.Importing
c.Linking
b.Exporting
d.Mail merging
Copying data from an external file into an Access database

Question 75

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

Question 76

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

Question 77

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

Question 78

Match the following terms with the best choice.
a.Importing
c.Linking
b.Exporting
d.Mail merging
Connecting data in an external file to an Access database

Question 79

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 80

Match each term with the best description.
a.Main document
c.Mail merge
b.Merge field
d.Mail Merge task pane
Data from an Access object is combined with a Word label or letter