Question 1

Access provides a wizard for easily importing Excel data into Access.

Accepted Answer

Access does provide a wizard for importing Excel data into Access, making it a quick and easy process.

Question 2

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 3

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 4

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 5

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 6

Access does not require that every table has a primary key.

Accepted Answer

In Microsoft Access, while it is highly recommended to have a primary key for each table to ensure each record is uniquely identified, it is not a strict requirement for table creation.

Question 7

Access requires that common fields be named exactly the same.

Accepted Answer

In Access, common fields between tables do not need to be named exactly the same for relationships or queries to work, as long as the field types are compatible and properly linked or referenced.

Question 8

A person's age is often a field used in table design.

Accepted Answer

The answer of A person's age is often a field...

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

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 11

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 12

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

Question 14

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 recommended to add all fields from a table in a query as it may slow down the query and return unnecessary data. Instead, only include the fields that are necessary for the specific task at hand.

Question 15

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 errors and unnecessary processing time. It is important to only include tables that are related to each other through keys or common fields.

Question 16

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 17

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 18

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

Question 20

Match between columns
                        Premises:  Live Layout
WordArt
Live Preview
Style
 Document theme

Accepted Answer

The Answer of Enables you to select text and point is...

Quiz 2: Access: Tables and Queries in Relational Databases

Access provides a wizard for easily importing Excel data into Access.

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

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

Access does not require that every table has a primary key.

Access requires that common fields be named exactly the same.

A person's age is often a field used in table design.

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

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

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

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

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

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.

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

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

Match each of the following terms to their meanings: