Question 1

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 A

Question 2

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 A

Question 3

In Report Layout view,you can set the Format property of a Number field by _____ instead of using the property sheet.

Accepted Answer

A)  entering a sample formatted value 
B)  using the buttons in the Number group on the Format tab 
C)  using the buttons on the Page Setup tab 
D)  using the Format dialog box 
A)  entering a sample formatted value 
B)  using the buttons in the Number group on the Format tab 
C)  using the buttons on the Page Setup tab 
D)  using the Format dialog box B

Question 4

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 5

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

Accepted Answer

A)  AutoNumber 
B)  Short Text 
C)  Hours 
D)  Number 
A)  AutoNumber 
B)  Short Text 
C)  Hours 
D)  Number

Question 6

Set the _____ Form startup option to specify which form opens when the database opens.

Accepted Answer

A)  Initial 
B)  Splash 
C)  Navigation 
D)  Display 
A)  Initial 
B)  Splash 
C)  Navigation 
D)  Display

Question 7

To close a query from SQL view,you can _____.

Accepted Answer

A)  click the View button in the Results group 
B)  click the Run button in the Results group 
C)  right-click the query tab and then click Close on the shortcut menu 
D)  double-click the query in the Navigation Pane 
A)  click the View button in the Results group 
B)  click the Run button in the Results group 
C)  right-click the query tab and then click Close on the shortcut menu 
D)  double-click the query in the Navigation Pane

Question 8

You click the _____ button to close the Filter by Form grid.

Accepted Answer

A)  Delete 
B)  Advanced 
C)  Selection 
D)  Toggle Filter 
A)  Delete 
B)  Advanced 
C)  Selection 
D)  Toggle Filter

Question 9

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

Accepted Answer

A)  Type the values separated by periods. 
B)  Drag each value from other records to the multivalued lookup field. 
C)  Click the arrow in the field,and then click a check box for each value. 
D)  Click the record selector,and then click each value. 
A)  Type the values separated by periods. 
B)  Drag each value from other records to the multivalued lookup field. 
C)  Click the arrow in the field,and then click a check box for each value. 
D)  Click the record selector,and then click each value.

Question 10

In Table Design view,you create a lookup list of values you enter using the _____ Lookup property of a field.

Accepted Answer

A)  Limit to List 
B)  Allow Multiple Values 
C)  Field Size 
D)  Row Source 
A)  Limit to List 
B)  Allow Multiple Values 
C)  Field Size 
D)  Row Source

Question 11

If you move the source of a linked table,you must update its location using the Linked Table Manager.

Accepted Answer

A) True 
 B)False

Question 12

In the Relationships window,a _____ represents each table.

Accepted Answer

A)  primary key 
B)  field list 
C)  one-to-many line 
D)  subdatasheet 
A)  primary key 
B)  field list 
C)  one-to-many line 
D)  subdatasheet

Question 13

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

In which of the following circumstances would you copy an entire table?

Accepted Answer

A)  You want to export records to another format. 
B)  You want to create a query with a self join. 
C)  You want to make one table the parent table and the other the child table. 
D)  You want to use the same table structure as in another table. 
A)  You want to export records to another format. 
B)  You want to create a query with a self join. 
C)  You want to make one table the parent table and the other the child table. 
D)  You want to use the same table structure as in another table.

Question 16

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.

Question 17

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 18

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 19

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 20

A field's Required property determines whether users must enter a value in the field.

Accepted Answer

A) True 
 B)False

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.

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

In Report Layout view,you can set the Format property of a Number field by _____ instead of using the property sheet.

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

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

Set the _____ Form startup option to specify which form opens when the database opens.

To close a query from SQL view,you can _____.

You click the _____ button to close the Filter by Form grid.

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

In Table Design view,you create a lookup list of values you enter using the _____ Lookup property of a field.

If you move the source of a linked table,you must update its location using the Linked Table Manager.

In the Relationships window,a _____ represents each table.

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

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

In which of the following circumstances would you copy an entire table?

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

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

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

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

A field's Required property determines whether users must enter a value in the field.

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

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.

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

In Report Layout view,you can set the Format property of a Number field by _____ instead of using the property sheet.

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

What data type should you assign to a CourseHours field that stores the hours required to complete a course?

Set the _____ Form startup option to specify which form opens when the database opens.

To close a query from SQL view,you can _____.

You click the _____ button to close the Filter by Form grid.

How do you enter more than one value in a multivalued lookup field in Table Datasheet view?

In Table Design view,you create a lookup list of values you enter using the _____ Lookup property of a field.

If you move the source of a linked table,you must update its location using the Linked Table Manager.

In the Relationships window,a _____ represents each table.

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

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

In which of the following circumstances would you copy an entire table?

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

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

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

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

A field's Required property determines whether users must enter a value in the field.

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.