Exam

Name___________________________________

MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)	Another term for an expression is:	1) ______

	A)  function.
	B)  query.
	C)  formula.
	D)  precedence.

2)

In the example NewPrice: [Price] *1.5, the text in brackets would be a(n):

2) ______

	A)  expression.
	B)  field.
	C)  result.
	D)  constant.

3)

A set of rules used to correctly arrange the content of an expression is known as:

3) ______

	A)  format.
	B)  calculation.
	C)  syntax.
	D)  formula.

4)

Which of the following does NOT describe the Expression Builder?

4) ______

	A)  It is necessary to scroll to see a long expression.
	B)  The brackets around fields are added by clicking on the bracket symbol button.
	C)  The field names are selected from a list of possible fields.
	D)  The arithmetic and logic choices are available through buttons.

5)

The example, [Employees]![HireDate] indicates:

5) ______

	A)  data from a record, from a field.
	B)  data from table, called HireDate.
	C)  data from a field.
	D)  data from a field, from a specified table.

6)

After running a query, it will display in __________ View.

6) ______

	A)  Datasheet
	B)  Query
	C)  Design
	D)  Table

7)

In the following example, the hyphen: Payment: PMT(0.65/12, 30*12, -[AmtFinance], 0, 0),

7) ______

	A)  deletes the field AmtFinance.
	B)  displays values as a negative.
	C)  subtracts the value of the field.
	D)  display values as a positive.

8)

Which statement is NOT correct about a query?

8) ______

	A)  Instructions on which data to display are saved within a query.
	B)  Data is not saved within a query.
	C)  Instructions on the format to display data are saved within a query.
	D)  Changing data values in a query will not change in a table.

9)

Which of the following expressions is NOT correct?

9) ______

	A)  Sales:[Price]*[Qty]
	B)  Cost=[Price]*1.25
	C)  Cost:[Price]*.5
	D)  PrPerSqFt:[SalePr]/[SqFt]

10)

If an expression contains a misspelled field name, the query will not return the correct result. To check and correct the error,:

10) ______

	A)  return to the table view to edit.
	B)  click and type on the query view shown on the screen.
	C)  delete the query and type again.
	D)  return to Design View to edit.

11)

To avoid errors and efficiently create formulas in the Expression Builder,:

11) ______

	A)  cut and paste fields from Design View.
	B)  use search to find fields in Design View.
	C)  click on fields from the list to select.
	D)  type fields directly into the work space.

12)

In the example, which part identifies the interest per period of a loan? Pmt(.070/12, 25*12, 130000,0,0)

12) ______

	A)  .070/12
	B)  0
	C)  130000
	D)  25*12

13)

In the following expression, which represents the true part of the formula? IIf(Balance >= 130000, .033, .0158)

13) ______

	A)  >=
	B)  .0158
	C)  Balance
	D)  .033

TRUE/FALSE. Write 'T' if the statement is true and 'F' if the statement is false.
14)	A well designed database will keep calculations stored within tables as data instead of queries, forms, and reports.	14) ______

15)

It is a good practice to always check calculation results on a calculator or in Excel to compare answers.

15) ______

16)

When saving a query, both the data and instructions about the data are saved.

16) ______

SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
17)	Match the following five terms to their meanings: I. table A. set of rules to correctly write an expression II. query B. values from fields used in an expression III. calculated field C. a set of instructions that retrieve specific data IV. syntax D. data resides here permanently V. field E. contains a value	17) ______

18)

Match the following five terms to their meanings: I. run A. toggles between design and table II. query B. data items within a table III. design C. update query IV. field D. based on two tables V. view E. a view used to edit and update

18) ______

19)

Match the following five terms to their meanings: I. parameter box A. tool to create formulas that perform calculations II. backup database B. looks for a specific value in a table III. Expression Builder C. two copies of same file IV. pre-built expression D. assigned to expressions created V. placeholder name E. a function already created

19) ______

20)

Match the following five terms to their meanings: IIf(Sales >= 50000, Excellent, Fair) I. Sales A. True condition II. 50000 B. part of condition as a constant III. .Excellent C. part of condition containing a value IV. .Fair D. False condition V. >= E. compares two values

20) ______