Exam 2: Tables and Queries in Relational Databases

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

(Essay)

4.7/5

(37)

Question 81

Although you can link to external data, it is not recommended.

(True/False)

4.8/5

(38)

Question 82

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

(Essay)

4.9/5

(27)

Question 83

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

(True/False)

4.9/5

(33)

Question 84

Having common fields is important when you begin to build ________ between the tables.

(Short Answer)

4.9/5

(40)

Question 85

What is not true about field names?

(Multiple Choice)

4.8/5

(28)

Question 86

When does the validation rule check the entered data?

(Multiple Choice)

4.7/5

(48)

Question 87

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

(Essay)

4.8/5

(46)

Question 88

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.

(True/False)

4.8/5

(39)

Question 89

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

(True/False)

4.8/5

(27)

Question 90

The ________ relationship is used when joining two primary keys.

(Short Answer)

4.8/5

(33)

Question 91

Which option would this wildcard, "H[!oe]" not display?

(Multiple Choice)

4.9/5

(36)

Question 92

What view offers the most flexibility in setting the properties of a field?

(Multiple Choice)

4.9/5

(44)

Question 93

What field property increases the speed at which searches can be performed?

(Multiple Choice)

4.9/5

(34)

Question 94

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

(Essay)

4.9/5

(38)

Question 95

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

(Multiple Choice)

4.9/5

(31)

Question 96

A field's ________ determine how that field functions.

(Short Answer)

4.8/5

(36)

Question 97

What can you not import from one Access database into another Access database?

(Multiple Choice)

4.9/5

(41)

Question 98

________ view is normally used when you want to change the structure of an object.

(Short Answer)

4.8/5

(35)

Question 99

Showing 81 - 99 of 99

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

Although you can link to external data, it is not recommended.

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

Having common fields is important when you begin to build ________ between the tables.

What is not true about field names?

When does the validation rule check the entered data?

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

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

The ________ relationship is used when joining two primary keys.

Which option would this wildcard, "H[!oe]" not display?

What view offers the most flexibility in setting the properties of a field?

What field property increases the speed at which searches can be performed?

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

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

A field's ________ determine how that field functions.

What can you not import from one Access database into another Access database?

________ view is normally used when you want to change the structure of an object.

Introduction to Access

Using Queries to Make Decisions

Creating and Using Professional Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Using Macros and Sql in Access

Microsoft Office Basics and Functions

Filters