Question 1

The text you specify for the Application Title property appears in the title bar instead of the database filename.

Accepted Answer

A) True 
 B)False

Question 2

Which of the following are ways to improve database performance? Select all the options that apply.

Accepted Answer

A)  Compact the database regularly. 
B)  Add more memory. 
C)  Convert the database to an earlier format. 
D)  Close other open applications you do not need. 
A)  Compact the database regularly. 
B)  Add more memory. 
C)  Convert the database to an earlier format. 
D)  Close other open applications you do not need.

Question 3

Where do you paste a copied query?

Accepted Answer

A)  at the end of a query datasheet 
B)  in the Navigation Pane 
C)  in Query Design view 
D)  on an object tab for any query 
A)  at the end of a query datasheet 
B)  in the Navigation Pane 
C)  in Query Design view 
D)  on an object tab for any query

Question 4

After you split a database, what does the back-end database contain?

Accepted Answer

A)  Links to the database tables 
B)  Queries, forms, and reports 
C)  Queries, forms, and reports. 
D)  The database tables 
A)  Links to the database tables 
B)  Queries, forms, and reports 
C)  Queries, forms, and reports. 
D)  The database tables

Question 5

Which startup command-line option opens the database for exclusive access?

Accepted Answer

A)  '/ro 
B)  '/excl 
C)  '/exclusive 
D)  '/enable 
A)  '/ro 
B)  '/excl 
C)  '/exclusive 
D)  '/enable

Question 6

You can copy and paste any object in Access except for tables.

Accepted Answer

A) True 
 B)False

Question 7

What do you use to open a database in Exclusive mode?

Accepted Answer

A)  Create tab on the ribbon 
B)  Navigation Pane 
C)  Open dialog box 
D)  Access Options dialog box 
A)  Create tab on the ribbon 
B)  Navigation Pane 
C)  Open dialog box 
D)  Access Options dialog box

Question 8

Use the Default field property to specify that an entry is required for the field.

Accepted Answer

False
 - Required
Fa

Question 9

Use the _____ Table Manager to manage a split database.

Accepted Answer

A)  Split 
B)  Datasheet 
C)  Linked 
D)  Front-End 
A)  Split 
B)  Datasheet 
C)  Linked 
D)  Front-End

Question 10

_____ data is scrambled so that it is indecipherable when opened by another program.

Accepted Answer

A)  Encrypted 
B)  Compacted 
C)  Read-Only 
D)  Linked 
A)  Encrypted 
B)  Compacted 
C)  Read-Only 
D)  Linked

Question 11

When you split an Access database, how many copies of the back-end database do you have?

Accepted Answer

A)  One copy for each user 
B)  One copy for each object in the database 
C)  One copy 
D)  Two copies 
A)  One copy for each user 
B)  One copy for each object in the database 
C)  One copy 
D)  Two copies

Question 12

The _____ property displays a value that is automatically entered in the field for new records.

Accepted Answer

A)  New Record 
B)  AutoEntry 
C)  Default Value 
D)  Starting Value 
A)  New Record 
B)  AutoEntry 
C)  Default Value 
D)  Starting Value

Question 13

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

Accepted Answer

A)  Unique 
B)  Indexed 
C)  Default Value 
D)  Required 
A)  Unique 
B)  Indexed 
C)  Default Value 
D)  Required

Question 14

Which of the following is displayed in the Relationships window? Select all the options that apply.

Accepted Answer

A)  primary keys 
B)  field names 
C)  data types 
D)  relationships 
A)  primary keys 
B)  field names 
C)  data types 
D)  relationships

Question 15

Which Short Text field property should you use to indicate users must enter a value in the field?

Accepted Answer

A)  Default 
B)  Required 
C)  Validation Rule 
D)  Yes/No 
A)  Default 
B)  Required 
C)  Validation Rule 
D)  Yes/No

Question 16

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

Accepted Answer

A) True 
 B)False

Question 17

Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.

Accepted Answer

A)  linked tables 
B)  object dependencies 
C)  trusted folder 
D)  Database Documenter report 
A)  linked tables 
B)  object dependencies 
C)  trusted folder 
D)  Database Documenter report

Question 18

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.

Accepted Answer

A)  Allow Zero Length 
B)  Allow Multiple Values 
C)  Allow Value List Edits 
D)  Allow Null 
A)  Allow Zero Length 
B)  Allow Multiple Values 
C)  Allow Value List Edits 
D)  Allow Null

Question 19

Which of the following are ways to help secure an Access database? Select all the options that apply.

Accepted Answer

A)  Password 
B)  Encryption 
C)  Show/hide objects 
D)  Attachment fields 
A)  Password 
B)  Encryption 
C)  Show/hide objects 
D)  Attachment fields

Question 20

Why might you want to hide an action query in the Navigation Pane?

Accepted Answer

A)  To avoid accidentally running the query 
B)  To remove clutter from the Navigation Pane 
C)  To keep the action query private 
D)  To run the query in the background 
A)  To avoid accidentally running the query 
B)  To remove clutter from the Navigation Pane 
C)  To keep the action query private 
D)  To run the query in the background

The text you specify for the Application Title property appears in the title bar instead of the database filename.

Which of the following are ways to improve database performance? Select all the options that apply.

Where do you paste a copied query?

After you split a database, what does the back-end database contain?

Which startup command-line option opens the database for exclusive access?

You can copy and paste any object in Access except for tables.

What do you use to open a database in Exclusive mode?

Use the Default field property to specify that an entry is required for the field.

Use the _____ Table Manager to manage a split database.

_____ data is scrambled so that it is indecipherable when opened by another program.

When you split an Access database, how many copies of the back-end database do you have?

The _____ property displays a value that is automatically entered in the field for new records.

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

Which of the following is displayed in the Relationships window? Select all the options that apply.

Which Short Text field property should you use to indicate users must enter a value in the field?

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.

Which of the following are ways to help secure an Access database? Select all the options that apply.

Why might you want to hide an action query in the Navigation Pane?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Filters

Exam 12: Developing an Excel Application

The text you specify for the Application Title property appears in the title bar instead of the database filename.

Which of the following are ways to improve database performance? Select all the options that apply.

Where do you paste a copied query?

After you split a database, what does the back-end database contain?

Which startup command-line option opens the database for exclusive access?

You can copy and paste any object in Access except for tables.

What do you use to open a database in Exclusive mode?

Use the Default field property to specify that an entry is required for the field.

Use the _____ Table Manager to manage a split database.

_____ data is scrambled so that it is indecipherable when opened by another program.

When you split an Access database, how many copies of the back-end database do you have?

The _____ property displays a value that is automatically entered in the field for new records.

If users must enter text in a LastName field, you can set the _____ property for the field in Table Datasheet view.

Which of the following is displayed in the Relationships window? Select all the options that apply.

Which Short Text field property should you use to indicate users must enter a value in the field?

To unhide a hidden object in the Navigation Pane, you must enter a password for accessing the object.

Before deleting a query, you can view its _____ to determine if any other queries, forms, or reports depend on that query.

If you set the _____ property to Yes for the CustEmail field, that means users can enter two quotation marks ("") in the field to mean no entry.

Which of the following are ways to help secure an Access database? Select all the options that apply.

Why might you want to hide an action query in the Navigation Pane?

Getting Started With Excel

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Filters