Question 1

When creating a multitable query from scratch only include related tables in your query.

Accepted Answer

Including unrelated tables in a multitable query can cause unnecessary complexity, slow down the query's performance, and potentially return inaccurate results. Therefore, it is best practice to only include tables that are related to each other in the query. Including only related tables in a multitable query ensures that the results are accurate and relevant to the query being performed. Including non-related tables can lead to confusion and incorrect results.

Question 2

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 3

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships window to make any changes.

Accepted Answer

In SQL, multitable queries (joins) allow you to define the relationships between tables directly in the query, without needing to modify the relationships predefined in the database schema.

Question 4

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

Accepted Answer

Changing data in a query can indeed alter the underlying data in the table if the query is designed to update, delete, or insert data.

Question 5

Logical operators only work with text and numbers, not dates.

Accepted Answer

Logical operators can also work with dates by comparing them for equality, greater than or less than relationships, and by using functions like YEAR, MONTH, and DAY. Logical operators can work with dates in programming languages such as SQL, but not in Excel. In Excel, dates must be converted to numerical values to be used with logical operators.

Question 6

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 7

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 8

It is best when designing a query to add all the fields from a table in case you need them later.

Accepted Answer

It is not necessary to include all fields from a table in a query. Only include the fields that are relevant to the question being asked in the query. Including unnecessary fields can make the query slower and harder to read. It is best practice to only include the fields you need in your query to improve performance and reduce the amount of data that needs to be processed. Including all fields in the query can lead to unnecessary data being returned and can slow down the query.

Question 9

Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results.

Accepted Answer

In most database systems, including SQL-based systems like Microsoft Access, the criteria used in queries are not case sensitive by default. This means that the query will treat uppercase and lowercase letters as equivalent when matching text values.

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

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 12

The first step in creating a query is selecting the fields you need.

Accepted Answer

The answer of The first step in creating a query...

Question 13

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.

Accepted Answer

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

Question 14

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

Accepted Answer

Copying a query and modifying the criteria is a more efficient way to create similar queries than starting from scratch. It saves time and reduces the risk of errors. Copying a similar query and modifying its criteria saves time and reduces the chances of errors, compared to starting from scratch.

Question 15

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 16

Data entered in a query is actually stored in the underlying table(s).

Accepted Answer

The answer of Data entered in a query is actually...

Question 17

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

Accepted Answer

In a query, when sorting on multiple fields, the sort order is determined by the field order from left to right. This means that the first field listed will be the primary sort field, followed by the second field listed, and so on. When sorting on multiple fields in a query, the sort order is determined by the field order from left to right. The leftmost field is considered first, and ties are broken by the next field to the right, and so on.

Question 18

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 19

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

Quiz 2: Tables and Queries in Relational Databases

When creating a multitable query from scratch only include related tables in your query.

Multitable queries inherit their relationships and you cannot change those in the query. You need to open the Relationships window to make any changes.

It is safe to change data in a query since you are only changing a temporary copy of the data, not the underlying data in the table.

Logical operators only work with text and numbers, not dates.

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

It is best when designing a query to add all the fields from a table in case you need them later.

Text you add to the criteria row in a query is case sensitive, so be careful or you may get unexpected results.

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

The first step in creating a query is selecting the fields you need.

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.

It is best to copy a query if you need a similar query, but with different criteria, rather than to start from scratch.

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

Data entered in a query is actually stored in the underlying table(s).

In a query, the sort order, when sorting on multiple fields, is determined by the field order from left to right.

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

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