Question 1

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

Accepted Answer

An Access database template would help D

Question 2

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

Accepted Answer

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

Question 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which process is most like copying and pasting?

Accepted Answer

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

Question 8

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

Accepted Answer

The answer of Microsoft _____ is the word-processing program in...

Question 9

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

Accepted Answer

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

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

Accepted Answer

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

Question 11

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

Accepted Answer

The answer of Microsoft _____ is the spreadsheet program within...

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

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

Question 15

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?

Accepted Answer

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

Question 16

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

Accepted Answer

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

Question 17

Match each term with the best description.
-Word document that contains the standard text for each mail-merge letter/label

Accepted Answer

A) Main document 
B) Merge field 
C) Mail merge 
D) Mail Merge task pane 
A) Main document 
B) Merge field 
C) Mail merge 
D) Mail Merge task pane

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

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

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

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

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

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

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

Which process is most like copying and pasting?

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

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

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

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

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

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

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

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?

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

Match each term with the best description. -Word document that contains the standard text for each mail-merge letter/label

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

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

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

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters

Exam 10: Importing and Exporting Data

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

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

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

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

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

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

Which process is most like copying and pasting?

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

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

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

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

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

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

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

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?

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

Match each term with the best description. -Word document that contains the standard text for each mail-merge letter/label

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

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

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

Getting Started With Microsoft Office 2013

Getting Started With Chapter Access 2013

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyzing Data With Reports

Analyzing Database Design Using Northwind

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Chapter Access and the Web

Filters