chapter 3

Question 1

Null

Answer 1

Used in access to define blank fields.

Question 2

AND Condition

Answer 2

Specifies two criteria in different fields. query will only display the records that match the criteria.

Question 3

OR Condition

Answer 3

Query results will display records that match any of the specified criteria.

Question 4

Multi table Queries

Answer 4

Contains two or more tables and enables you to take advantage of the relationships that have been set in your database.

Question 5

Calculated Field

Answer 5

A field that displays the result of an expression rather than data stored in a field.

Question 6

Expression

Answer 6

A combination of elements that produce a value

Question 7

Constant

Answer 7

A value that does not change.

Question 8

Order of Operation

Answer 8

Determines the sequence by which operations are calculated in a mathematical expression.

Question 9

PEDMAS

Answer 9

Parentheses 
Exponentiation
Multiplication
Division
Addition
Subtraction

Question 10

Property Sheet

Answer 10

Enables you to change the way a field appears.