Question 1

What data type is most appropriate for a field named SquareFeet?

Accepted Answer

A)  Hyperlink 
B)  Attachment 
C)  Number 
D)  AutoNumber 
A)  Hyperlink 
B)  Attachment 
C)  Number 
D)  AutoNumber

Question 2

To find employee records that do not contain an entry in the Email field,use the _____ criterion in the Email field.

Accepted Answer

A)  Is Not Null 
B)  Is Null 
C)  Find Unmatched 
D)  Is Blank 
A)  Is Not Null 
B)  Is Null 
C)  Find Unmatched 
D)  Is Blank

Question 3

Which of the following statements are true about field properties? Select all the options that apply.

Accepted Answer

A)  Modifying the properties helps ensure database accuracy. 
B)  Some properties are required,and some are optional. 
C)  The properties are the same for each data type. 
D)  The properties can be used to change the way data is displayed. 
A)  Modifying the properties helps ensure database accuracy. 
B)  Some properties are required,and some are optional. 
C)  The properties are the same for each data type. 
D)  The properties can be used to change the way data is displayed.

Question 4

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply.

Accepted Answer

A)  Close the query. 
B)  Copy the query. 
C)  Paste the query. 
D)  Open the query. 
A)  Close the query. 
B)  Copy the query. 
C)  Paste the query. 
D)  Open the query.

Question 5

You can recover a forgotten database password by opening the database in Exclusive mode.

Accepted Answer

A) True 
 B)False

Question 6

If you add Is Null as the criterion for the Advisor field in the Students table,what are the results?

Accepted Answer

A)  Advisors without students 
B)  Students with advisors 
C)  Students with more than one advisor 
D)  Students without advisors 
A)  Advisors without students 
B)  Students with advisors 
C)  Students with more than one advisor 
D)  Students without advisors

Question 7

Which of the following properties can you set for a Short Text field?

Accepted Answer

A)  Format 
B)  Decimal Places 
C)  Default Value 
D)  Input Mask 
A)  Format 
B)  Decimal Places 
C)  Default Value 
D)  Input Mask

Question 8

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

To create a filter using the _____ feature,you work in a view similar to Query Design view.

Accepted Answer

A)  Filter By Selection 
B)  Filter by Form 
C)  Advanced Filter 
D)  Comparison 
A)  Filter By Selection 
B)  Filter by Form 
C)  Advanced Filter 
D)  Comparison

Question 10

To allow users to enter more than one value in a field,you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

Accepted Answer

A)  General tab 
B)  Lookup tab 
C)  Description column 
D)  Data Type column 
A)  General tab 
B)  Lookup tab 
C)  Description column 
D)  Data Type column

Question 11

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 12

You can _____ an Access database into a back-end database and front-end database.

Accepted Answer

A)  split 
B)  convert 
C)  backup 
D)  reconfigure 
A)  split 
B)  convert 
C)  backup 
D)  reconfigure

Question 13

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 14

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 15

The term _____ describes a field value that does not exist because it has never been entered.

Accepted Answer

A)  join 
B)  zero-length 
C)  orphan 
D)  null 
A)  join 
B)  zero-length 
C)  orphan 
D)  null

Question 16

Which of the following fields are good candidates for a multivalue lookup field? Select all the options that apply.

Accepted Answer

A)  Project Team 
B)  Task Assigned To 
C)  Number Of Bedrooms 
D)  Preferred Features 
A)  Project Team 
B)  Task Assigned To 
C)  Number Of Bedrooms 
D)  Preferred Features

Question 17

You use the Performance Analyzer to analyze tables only.

Accepted Answer

A) True 
 B)False

Question 18

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

Accepted Answer

A)  Linked Table Manager 
B)  Database Connector 
C)  Database Documenter 
D)  Table Location Manager 
A)  Linked Table Manager 
B)  Database Connector 
C)  Database Documenter 
D)  Table Location Manager

Question 19

If you set a database _____,all users must enter that combination of characters before they are allowed to open the database.

Accepted Answer

A)  password 
B)  startup option 
C)  permission 
D)  share list 
A)  password 
B)  startup option 
C)  permission 
D)  share list

Question 20

To _____ a query,you right-click it in the Navigation Pane,and then click Copy on the shortcut menu.

Accepted Answer

A)  paste 
B)  cut 
C)  copy 
D)  rename 
A)  paste 
B)  cut 
C)  copy 
D)  rename

What data type is most appropriate for a field named SquareFeet?

To find employee records that do not contain an entry in the Email field,use the _____ criterion in the Email field.

Which of the following statements are true about field properties? Select all the options that apply.

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply.

You can recover a forgotten database password by opening the database in Exclusive mode.

If you add Is Null as the criterion for the Advisor field in the Students table,what are the results?

Which of the following properties can you set for a Short Text field?

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

To create a filter using the _____ feature,you work in a view similar to Query Design view.

To allow users to enter more than one value in a field,you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

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

You can _____ an Access database into a back-end database and front-end database.

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

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

The term _____ describes a field value that does not exist because it has never been entered.

Which of the following fields are good candidates for a multivalue lookup field? Select all the options that apply.

You use the Performance Analyzer to analyze tables only.

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

If you set a database _____,all users must enter that combination of characters before they are allowed to open the database.

To _____ a query,you right-click it in the Navigation Pane,and then click Copy on the shortcut menu.

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

What data type is most appropriate for a field named SquareFeet?

To find employee records that do not contain an entry in the Email field,use the _____ criterion in the Email field.

Which of the following statements are true about field properties? Select all the options that apply.

Which of the following are tasks you can perform on a query listed in the Navigation Pane? Select all the options that apply.

You can recover a forgotten database password by opening the database in Exclusive mode.

If you add Is Null as the criterion for the Advisor field in the Students table,what are the results?

Which of the following properties can you set for a Short Text field?

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

To create a filter using the _____ feature,you work in a view similar to Query Design view.

To allow users to enter more than one value in a field,you set the Allow Multiple Values property to Yes in the _____ in Table Design View.

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

You can _____ an Access database into a back-end database and front-end database.

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

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

The term _____ describes a field value that does not exist because it has never been entered.

Which of the following fields are good candidates for a multivalue lookup field? Select all the options that apply.

You use the Performance Analyzer to analyze tables only.

What Access tool should you use if the path to the back-end database changes and you need to reconnect the front-end and back-end databases?

If you set a database _____,all users must enter that combination of characters before they are allowed to open the database.

To _____ a query,you right-click it in the Navigation Pane,and then click Copy on the shortcut menu.

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