Question 1

________ queries allow you to take full advantage of table relationships.

Accepted Answer

The answer of ________ queries allow you to take full...

Question 2

The ________ relationship requires a junction table for it to function properly.

Accepted Answer

The answer of The ________ relationship requires a junction table...

Question 3

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

Accepted Answer

The answer of One way to fix the problem that...

Question 4

In query design, the ________ row allows you to set limits on what records are displayed.

Accepted Answer

The answer of In query design, the ________ row allows...

Question 5

Match the recommended field types with their examples:
I. AutoNumber
II. OLE
III. Hyperlink
IV. Yes/No
V. Attachment
A. An email address
B. Multiple pictures
C. An object created by another program
D. When the answer can be either True or False
E. Very useful for Primary keys

Accepted Answer

The answer of Match the recommended field types with their...

Question 6

Match the following Comparison Operators expression with their example: I. =25 II. >25 III. <25 IV. <>25 V. >=25 A. Less than 25 B. Equals 25 C. Does not equal 25 D. Greater than or equal to 25 E. Greater than 25

Accepted Answer

The answer of Match the following Comparison Operators expression with...

Question 7

Match the following terms with their description: I. "And" condition II. "Or" condition III. Null IV. Comparison Operator V. Criteria A. Blank field value B. Examples include: >, <, <>, = C. Returns only records that meet all criteria D. Determines which records are selected E. Returns records meeting any criteria

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 8

Match the following field properties with their example:
I. Default Value
II. Validation Text
III. Validation Rule
IV. Input Mask
V. Field Size
A. !\(999") "000\-0000;0;_
B. "MD"
C. 14
D. "MD" Or "PA" Or "WV"
E. "Please enter a value greater than 40."

Accepted Answer

The answer of Match the following field properties with their...

Question 9

Match the following terms with their description:
I. Caption
II. Foreign key
III. Data type
IV. Field properties
V. Wildcards
A. Used to relate tables on common fields
B. Effects what operations can be performed on data
C. Characteristic of a field
D. Special characters that can represent other characters
E. More understandable than a field name

Accepted Answer

The answer of Match the following terms with their description:
I....

Question 10

Match the recommended field types with their examples:
I. Short text
II. Long text
III. Number
IV. Data/Time
V. Currency
A. A memo of indeterminate length
B. Phone number
C. Person's birthdate
D. Years of service
E. Financial information

Accepted Answer

The answer of Match the recommended field types with their...

Question 11

What is the correct order of steps for creating a multitable query?
I. Step 1
II. Step 2
III. Step 3
IV. Step 4
V. Step 5
A. Add the tables you want
B. Click Query Design in the Queries group
C. Click Run
D. Drag the fields you want
E. Click the Create tab

Accepted Answer

The answer of What is the correct order of steps...

Question 12

You can easily ________ your data by using a multitable query.

Accepted Answer

The answer of You can easily ________ your data by...

Question 13

The ________ guides you through query design with a step-by-step process.

Accepted Answer

The answer of The ________ guides you through query design...

Question 14

In table relationships, the primary key is normally joined to a ________ key.

Accepted Answer

The answer of In table relationships, the primary key is...

Question 15

The term that can be used in a query to refer to blank cells is ________.

Accepted Answer

The answer of The term that can be used in...

Question 16

Match the following field properties with their description or something true about the property:
I. Caption
II. Format
III. Required
IV. Indexed
V. Result Type
A. Does not affect the stored value
B. Increases efficiency during searches
C. Used for calculated fields only
D. More understandable than field names
E. Cannot be Null

Accepted Answer

The answer of Match the following field properties with their...

Question 17

Match the recommended field types with their definitions or examples:
I. Calculate
II. Lookup Wizard
III. Short text
IV. Number
V. Currency
A. Can hold up to 255 characters
B. Used to force users to pick from a custom list
C. Can be set to Euros
D. References one or more existing fields
E. Used if you want to store a dollar sign ($) in your data

Accepted Answer

The answer of Match the recommended field types with their...

Quiz 3: Tables and Queries in Relational Databases

________ queries allow you to take full advantage of table relationships.

The ________ relationship requires a junction table for it to function properly.

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

In query design, the ________ row allows you to set limits on what records are displayed.

Match the recommended field types with their examples: I. AutoNumber II. OLE III. Hyperlink IV. Yes/No V. Attachment A. An email address B. Multiple pictures C. An object created by another program D. When the answer can be either True or False E. Very useful for Primary keys

Match the following Comparison Operators expression with their example: I. =25 II. >25 III. <25 IV. <>25 V. >=25 A. Less than 25 B. Equals 25 C. Does not equal 25 D. Greater than or equal to 25 E. Greater than 25

Match the following field properties with their example: I. Default Value II. Validation Text III. Validation Rule IV. Input Mask V. Field Size A. ! \(999") "000\-0000;0;_ B. "MD" C. 14 D. "MD" Or "PA" Or "WV" E. "Please enter a value greater than 40."

Match the recommended field types with their examples: I. Short text II. Long text III. Number IV. Data/Time V. Currency A. A memo of indeterminate length B. Phone number C. Person's birthdate D. Years of service E. Financial information

What is the correct order of steps for creating a multitable query? I. Step 1 II. Step 2 III. Step 3 IV. Step 4 V. Step 5 A. Add the tables you want B. Click Query Design in the Queries group C. Click Run D. Drag the fields you want E. Click the Create tab

You can easily ________ your data by using a multitable query.

The ________ guides you through query design with a step-by-step process.

In table relationships, the primary key is normally joined to a ________ key.

The term that can be used in a query to refer to blank cells is ________.