Question 1

Use the Number data type for fields that store postal codes.

Accepted Answer

False
 - Short Text

Question 2

Query for zero-length values by entering Is Null as the criterion.

Accepted Answer

False 
- n

Question 3

If most records will contain "NY" in the State field, enter _____ as the _____ property for the State field.

Accepted Answer

A)  NY; Default Value 
B)  State; Default Value 
C)  NY; Input Mask 
D)  State; Field Size 
A)  NY; Default Value 
B)  State; Default Value 
C)  NY; Input Mask 
D)  State; Field Size

Question 4

In the Relationships window, which symbol identifies the field on the "many" side of the relationship?

Accepted Answer

A)  key symbol 
B)  linking symbol 
C)  infinity symbol 
D)  expand symbol 
A)  key symbol 
B)  linking symbol 
C)  infinity symbol 
D)  expand symbol

Question 5

Before you can change the Hidden property for a hidden object in the Navigation Pane, you must _____.

Accepted Answer

A)  hide the Navigation Pane itself 
B)  change the Navigation Options to show hidden objects 
C)  restart Access 
D)  open the Property Sheet for the Navigation Pane 
A)  hide the Navigation Pane itself 
B)  change the Navigation Options to show hidden objects 
C)  restart Access 
D)  open the Property Sheet for the Navigation Pane

Question 6

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

Accepted Answer

A) True 
 B)False

Question 7

To view a list of the database objects that depend on the selected object, open the Object Dependencies pane.

Accepted Answer

A) True 
 B)False

Question 8

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

Accepted Answer

A) True 
 B)False

Question 9

When you split an Access database, what do you call the database stored on your computer?

Accepted Answer

A)  Client-end database 
B)  Object database 
C)  Front-end database 
D)  Table database 
A)  Client-end database 
B)  Object database 
C)  Front-end database 
D)  Table database

Question 10

You can set a startup option to show or hide the Navigation Pane itself.

Accepted Answer

A) True 
 B)False

Question 11

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 12

Number fields store values that represent quantities, measurements, and scores, for example.

Accepted Answer

A) True 
 B)False

Question 13

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 14

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

Accepted Answer

A) True 
 B)False

Question 15

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

Accepted Answer

A)  security 
B)  exclusive mode 
C)  window design 
D)  startup 
A)  security 
B)  exclusive mode 
C)  window design 
D)  startup

Question 16

What must you do before setting a password for a database?

Accepted Answer

A)  Split the database. 
B)  Open the database in Exclusive mode. 
C)  Remove any linked tables from the database. 
D)  'Set a password for each object in the database. 
A)  Split the database. 
B)  Open the database in Exclusive mode. 
C)  Remove any linked tables from the database. 
D)  'Set a password for each object in the database.

Question 17

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

Accepted Answer

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

Question 18

Which of the following is a startup command-line option?

Accepted Answer

A)  /repair 
B)  /excl 
C)  /open 
D)  /trust 
A)  /repair 
B)  /excl 
C)  /open 
D)  /trust

Question 19

How do you start the Performance Analyzer?

Accepted Answer

A)  Click the Database Tools tab, and then click the Document Database button. 
B)  Click the Database Tools tab, and then click the Analyze Performance button. 
C)  Click the Database Tools tab, and then click the Analyze Database button. 
D)  Click the File tab, click Options, and then click Analyze Performance. 
A)  Click the Database Tools tab, and then click the Document Database button. 
B)  Click the Database Tools tab, and then click the Analyze Performance button. 
C)  Click the Database Tools tab, and then click the Analyze Database button. 
D)  Click the File tab, click Options, and then click Analyze Performance.

Question 20

How can examining object dependencies help you when developing a database?

Accepted Answer

A)  It identifies potential performance problems. 
B)  It flags naming conflicts among database objects. 
C)  It deletes objects you have not used recently. 
D)  It can prevent you from deleting a query used by another object. 
A)  It identifies potential performance problems. 
B)  It flags naming conflicts among database objects. 
C)  It deletes objects you have not used recently. 
D)  It can prevent you from deleting a query used by another object.

Use the Number data type for fields that store postal codes.

Query for zero-length values by entering Is Null as the criterion.

If most records will contain "NY" in the State field, enter _ as the _ property for the State field.

In the Relationships window, which symbol identifies the field on the "many" side of the relationship?

Before you can change the Hidden property for a hidden object in the Navigation Pane, you must _____.

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

To view a list of the database objects that depend on the selected object, open the Object Dependencies pane.

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

When you split an Access database, what do you call the database stored on your computer?

You can set a startup option to show or hide the Navigation Pane itself.

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

Number fields store values that represent quantities, measurements, and scores, for example.

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

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

What must you do before setting a password for a database?

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

Which of the following is a startup command-line option?

How do you start the Performance Analyzer?

How can examining object dependencies help you when developing a database?

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

Use the Number data type for fields that store postal codes.

Query for zero-length values by entering Is Null as the criterion.

If most records will contain "NY" in the State field, enter _____ as the _____ property for the State field.

In the Relationships window, which symbol identifies the field on the "many" side of the relationship?

Before you can change the Hidden property for a hidden object in the Navigation Pane, you must _____.

You can keep an action query in the Navigation Pane but hide it using the Hidden property.

To view a list of the database objects that depend on the selected object, open the Object Dependencies pane.

Database passwords are case sensitive, which means that IOWA and iowa are different passwords.

When you split an Access database, what do you call the database stored on your computer?

You can set a startup option to show or hide the Navigation Pane itself.

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

Number fields store values that represent quantities, measurements, and scores, for example.

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

To create a multivalued field in Table Design view, enter Yes in the Allow Multiple Values Lookup property.

To keep the Navigation Pane hidden in the Access window, you set a(n) _____ option.

What must you do before setting a password for a database?

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

Which of the following is a startup command-line option?

How do you start the Performance Analyzer?

How can examining object dependencies help you when developing a database?

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

If most records will contain "NY" in the State field, enter _ as the _ property for the State field.