Deck 9: Importing and Exporting Data

Question 1

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

Answer 1

B

Question 2

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

Answer 2

False

Question 3

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.

Answer 3

False

Question 4

You can establish referential integrity with a linked table.

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

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

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

Question 9

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

Question 10

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

Question 11

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

Question 12

Microsoft often changes and updates online templates.

Question 13

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

Question 14

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 15

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

Question 16

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 17

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

Question 18

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 19

Which type of template creates a traditional Access database?

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

Question 20

Exporting is the opposite of importing.

Question 21

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

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

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

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

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

Question 24

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 25

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 26

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

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

Question 27

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 28

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

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

Question 29

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 30

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 31

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 32

Which process is most like copying and pasting?

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

Question 33

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 34

ODBC stands for _____.

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

Question 35

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 36

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 37

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

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

Question 38

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 39

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

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

Question 40

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 41

PDF stands for _____.

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

Question 42

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 43

The file format RTF stands for _____.

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

You read a PDF document with _____ software:

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

Question 49

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 50

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

Question 51

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 52

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

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

Question 53

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

Question 54

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

Question 55

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

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 57

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

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

Question 58

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

Question 59

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

Question 60

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

Question 61

Describe how Aaron could use the Contacts option selected in the figure shown to enhance an existing database.

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

Doug needs to maintain an Excel spreadsheet but also needs to use the same data in an Access database.  He wants to make sure that any updates to the Excel spreadsheet are automatically updated in the Access database.  In the figure above, which option should he choose and why?

Question 69

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

Question 70

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

Question 71

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 72

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

Question 73

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

Question 74

Lara works at a large corporation.  Explain how the features shown in the attached figure could help her improve an exist database.

Question 75

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

Question 76

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

Question 77

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 79

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

Question 80

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