Question 1

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

Question 2

When you split an Access database, what do you call the database containing all the tables?

Accepted Answer

A)  Front-end database 
B)  File-server database 
C)  Back-end database 
D)  Back-up database 
A)  Front-end database 
B)  File-server database 
C)  Back-end database 
D)  Back-up database C

Question 3

Where can you set a field's Default Value in Table Design view?

Accepted Answer

A)  in the Description column 
B)  in the Validation dialog box 
C)  on the Lookup tab 
D)  in the Field Properties pane 
A)  in the Description column 
B)  in the Validation dialog box 
C)  on the Lookup tab 
D)  in the Field Properties pane D

Question 4

You can select a particular form, such as a Navigation form, to display when Access starts.

Accepted Answer

A) True 
 B)False

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

You use an action query's the Invisible property to hide the query in the Navigation Pane.

Accepted Answer

A) True 
 B)False

Question 8

The Lookup Source property stores the values that are provided in the list for a Lookup field.

Accepted Answer

False 
- R

Question 9

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 10

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 11

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 12

A front-end database contains _____ to the tables in the back-end database.

Accepted Answer

A)  updates 
B)  links 
C)  relationships 
D)  maps 
A)  updates 
B)  links 
C)  relationships 
D)  maps

Question 13

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 14

Where do you set the Allow Multiple Values property of a field in Table Design view?

Accepted Answer

A)  in the Data Type column of the upper pane 
B)  on the Lookup tab of the Field Properties pane 
C)  in the property sheet for the table 
D)  in the Description column of the upper pane 
A)  in the Data Type column of the upper pane 
B)  on the Lookup tab of the Field Properties pane 
C)  in the property sheet for the table 
D)  in the Description column of the upper pane

Question 15

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

Question 16

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Accepted Answer

A)  the Field List 
B)  Datasheet View 
C)  the Navigation Pane 
D)  Design View 
A)  the Field List 
B)  Datasheet View 
C)  the Navigation Pane 
D)  Design View

Question 17

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

Accepted Answer

A)  Suggestion 
B)  Idea 
C)  Issue 
D)  Recommendation 
A)  Suggestion 
B)  Idea 
C)  Issue 
D)  Recommendation

Question 18

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

Accepted Answer

A)  Null OR Not "New York" 
B)  Is Not Null OR "New York" 
C)  Not "New York" 
D)  Is Null OR Not "New York" 
A)  Null OR Not "New York" 
B)  Is Not Null OR "New York" 
C)  Not "New York" 
D)  Is Null OR Not "New York"

Question 19

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 20

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

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

When you split an Access database, what do you call the database containing all the tables?

Where can you set a field's Default Value in Table Design view?

You can select a particular form, such as a Navigation form, to display when Access starts.

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

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

You use an action query's the Invisible property to hide the query in the Navigation Pane.

The Lookup Source property stores the values that are provided in the list for a Lookup field.

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

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

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.

A front-end database contains _____ to the tables in the back-end database.

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

Where do you set the Allow Multiple Values property of a field in Table Design view?

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

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

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

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

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

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

When you split an Access database, what do you call the database containing all the tables?

Where can you set a field's Default Value in Table Design view?

You can select a particular form, such as a Navigation form, to display when Access starts.

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

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

You use an action query's the Invisible property to hide the query in the Navigation Pane.

The Lookup Source property stores the values that are provided in the list for a Lookup field.

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

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

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.

A front-end database contains _____ to the tables in the back-end database.

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

Where do you set the Allow Multiple Values property of a field in Table Design view?

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

To copy a table, you right-click it in _____ and then click Copy on the shortcut menu.

Which of the following are types of advice the Performance Analyzer gives regarding performance? Select all the options that apply.

Which of the following criteria selects records for customers except those who live in New York, even if the City field is blank?

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

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

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