Question 1

You create a calculated field using the ____.

Accepted Answer

A)  Expression Builder 
B)  Expression Wizard 
C)  Calculation Builder 
D)  Calculator Wizard 
A)  Expression Builder 
B)  Expression Wizard 
C)  Calculation Builder 
D)  Calculator Wizard A

Question 2

Using the Lookup Wizard to set lookup properties allows you to have more than one ____ of data appear in the list.

Accepted Answer

A)  color 
B)  column 
C)  section 
D)  type 
A)  color 
B)  column 
C)  section 
D)  type B

Question 3

The primary objects comprising a database are ____.

Accepted Answer

A)  tables, indexes, and forms 
B)  forms, charts, and reports 
C)  tables, keys, and reports 
D)  tables, forms, and reports 
A)  tables, indexes, and forms 
B)  forms, charts, and reports 
C)  tables, keys, and reports 
D)  tables, forms, and reports D

Question 4

A(n) ____________________ appears in a field containing an input mask before the value is entered.

Accepted Answer

The answer of A(n) ____________________ appears in a field containing...

Question 5

Access 2010 has a new feature that allows you to create a(n) ____________________ field in a table.

Accepted Answer

The answer of Access 2010 has a new feature that...

Question 6

Setting lookup properties can help prevent data validation errors.

Accepted Answer

A) True 
 B)False

Question 7

The ____ button starts the Input Mask Wizard dialog box.

Accepted Answer

A)  Required 
B)  Build 
C)  Try It 
D)  Next 
A)  Required 
B)  Build 
C)  Try It 
D)  Next

Question 8

You can set lookup properties using the Input Mask Wizard to take you step by step through the process.

Accepted Answer

A) True 
 B)False

Question 9

Match between columns
                        Premises: Allows you to enter a value or select a value from a list.
Offers a list of values from another field or query that you can select.
An arithmetic formula that performs a calculation.
Allows you select more than one value.
Used when you want to enter data.

Accepted Answer

The Answer of expression and list box and lookup property is...

Question 10

____ determine the type of calculation in the expression.

Accepted Answer

A)  Operators 
B)  Links 
C)  Symbols 
D)  Formulas 
A)  Operators 
B)  Links 
C)  Symbols 
D)  Formulas

Question 11

To which of the following items is an input mask commonly applied?

Accepted Answer

A)  last name 
B)  street address 
C)  city 
D)  ZIP code 
A)  last name 
B)  street address 
C)  city 
D)  ZIP code

Question 12

A lookup property can only be in the form of a combo box.

Accepted Answer

A) True 
 B)False

Question 13

Validation text is entered in the Field Properties pane.

Accepted Answer

A) True 
 B)False

Question 14

When setting up lookup properties, the ____ Type lets you select from where the items in the list will come.

Accepted Answer

A)  Field Source 
B)  Field Input 
C)  Row Source 
D)  List 
A)  Field Source 
B)  Field Input 
C)  Row Source 
D)  List

Question 15

You can create a(n) ____ field in a table for the purpose of showing actual calculations between fields in the table.

Accepted Answer

A)  pop up 
B)  calculated 
C)  dynamic 
D)  embedded 
A)  pop up 
B)  calculated 
C)  dynamic 
D)  embedded

Question 16

You can set lookup properties in the ____ tab in the Field Properties pane.

Accepted Answer

A)  Field 
B)  Lookup 
C)  Modify 
D)  Insert 
A)  Field 
B)  Lookup 
C)  Modify 
D)  Insert

Question 17

The input mask places the symbols in the data automatically when it is entered.

Accepted Answer

A) True 
 B)False

Question 18

A lookup property list of values can be from another field or in a query.

Accepted Answer

A) True 
 B)False

Question 19

A validation rule is entered as a(n) ____ in the Expression Builder.

Accepted Answer

A)  formula 
B)  expression 
C)  operation 
D)  lookup 
A)  formula 
B)  expression 
C)  operation 
D)  lookup

Question 20

Case AC 7-1 Ed Brown is the chief financial officer of a medium-sized business distributing geological surveying meters and associated equipment to engineering companies and government agencies. Ed has noticed that the company sales and receipts are not matching properly, and he suspects inadvertent human error in Access database data entry. For the date issue of immediate concern, you decide to use ____ to increase accuracy and efficiency of data entry.

Accepted Answer

A)  validation masks 
B)  lookup boxes 
C)  placeholder symbols 
D)  validation rules 
A)  validation masks 
B)  lookup boxes 
C)  placeholder symbols 
D)  validation rules

Exam 7: Enhancing Table Design

You create a calculated field using the ____.

Using the Lookup Wizard to set lookup properties allows you to have more than one ____ of data appear in the list.

The primary objects comprising a database are ____.

A(n) ____________________ appears in a field containing an input mask before the value is entered.

Access 2010 has a new feature that allows you to create a(n) ____________________ field in a table.

Setting lookup properties can help prevent data validation errors.

The ____ button starts the Input Mask Wizard dialog box.

You can set lookup properties using the Input Mask Wizard to take you step by step through the process.

____ determine the type of calculation in the expression.

To which of the following items is an input mask commonly applied?

A lookup property can only be in the form of a combo box.

Validation text is entered in the Field Properties pane.

When setting up lookup properties, the ____ Type lets you select from where the items in the list will come.

You can create a(n) ____ field in a table for the purpose of showing actual calculations between fields in the table.

You can set lookup properties in the ____ tab in the Field Properties pane.

The input mask places the symbols in the data automatically when it is entered.

A lookup property list of values can be from another field or in a query.

A validation rule is entered as a(n) ____ in the Expression Builder.

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Entering Worksheet Formulas

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters