Question 1

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

Accepted Answer

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

Question 2

The ________ sign should be put around dates so that Access knows they are dates.

Accepted Answer

The answer of The ________ sign should be put around...

Question 3

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

Accepted Answer

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

Question 4

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

Accepted Answer

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

Question 5

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

Accepted Answer

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

Question 6

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

Accepted Answer

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

Question 7

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 8

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 9

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

Question 10

Match between columns
                        Premises: Cascade Update
Referential Integrity
Cascade Delete
AutoNumber
Data Redundancy

Accepted Answer

The Answer of Deletes records in related fields that match is...

Question 11

Match between columns
                        Premises: Caption
Wildcards
Field properties
Foreign key
Data type

Accepted Answer

The Answer of Used to relate tables on common fields is...

Question 12

Match between columns
                        Premises: Null
"Or" condition
"And" condition
Criteria
Comparison Operator

Accepted Answer

The Answer of Blank field value and Examples include: >,<,<>,= is...

Question 13

Match between columns
                        Premises: Step 2
Step 1
Step 5
Step 3
Step 4

Accepted Answer

The Answer of Drag the fields you want and Click is...

Question 14

Match between columns Premises: >25 =25 >=25 <>25 <25

Accepted Answer

The Answer of Less than 25 and Equals 25 and is...

Question 15

Match between columns
                        Premises: Input Mask
Validation Text
Field Size
Default Value
Validation Rule

Accepted Answer

The Answer of 14 and "Please enter a value greater is...

Question 16

Match between columns
                        Premises: Caption
Required
Result Type
Format
Indexed

Accepted Answer

The Answer of More understandable than field names and Cannot is...

Question 17

Match between columns
                        Premises: Short text
Lookup Wizard
Number
Calculate
Currency

Accepted Answer

The Answer of Used to force users to pick from is...

Question 18

Match between columns
                        Premises: OLE
Yes/No
Attachment
Hyperlink
AutoNumber

Accepted Answer

The Answer of Multiple pictures and When the answer can is...

Question 19

Match between columns
                        Premises: Number
Short text
Currency
Long text
Data/Time

Accepted Answer

The Answer of Phone number and Financial information and A is...

Quiz 3: Tables and Queries in Relational Databases

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

The ________ sign should be put around dates so that Access knows they are dates.

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

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

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

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

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

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 following terms with their description:

Match the following terms with their description:

Match the following terms with their description:

What is the correct order of steps for creating a multitable query?

Match the following Comparison Operators expression with their example:

Match the following field properties with their example:

Match the following field properties with their description or something true about the property:

Match the recommended field types with their definitions or examples:

Match the recommended field types with their examples:

Match the recommended field types with their examples: