Question 1

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

Accepted Answer

A)  Use Access Options 
B)  Create an AutoExec macro 
C)  Name a form Startup 
D)  Each of these methods creates 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 2

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

Accepted Answer

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

Question 3

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?

Accepted Answer

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

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 5

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

Accepted Answer

The answer of _____ is a way to copy Access...

Question 6

Microsoft often changes and updates online templates.

Accepted Answer

A) True 
 B)False

Question 7

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 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

Templates help you quickly create a new

Question 10

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

Accepted Answer

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

Question 11

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

Accepted Answer

The answer of _____ connects an Access database to data...

Question 12

You read a PDF document with _____ software:

Accepted Answer

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

Question 13

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

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

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

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

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

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(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.

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

Microsoft often changes and updates online templates.

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

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

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

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

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

You read a PDF document with _____ software:

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

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

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

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

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?

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

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters

Exam 9: Importing and Exporting Data

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

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

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(n) _____ file is a text file containing Extensible Markup Language tags that identify field names and data.

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

Microsoft often changes and updates online templates.

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

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

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

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

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

You read a PDF document with _____ software:

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

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

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

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

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?

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

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

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

Getting Started With Access

Building and Using Queries

Using Forms

Using Reports

Modifying the Database Structure

Improving Queries

Enhancing Forms

Analyizng Data With Reports

Creating Advanced Queries

Creating Advanced Reports

Creating Macros

Creating Modules and Vba

Administering the Database

Using Acess and the Web

Completing a Database Application

Filters