FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 3: Tables and Queries in Relational Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

What is not true about data types?

A) It is best to choose Short Text for all fields at first, because they can easily be changed later.
B) Every field is assigned a data type.
C) They determine what operations can be performed on the data.
D) They can be changed after the table has been created.

E) B) and C)
F) B) and D)

Correct Answer

verified

Show Answer

Question 42

Essay

Review LaterAdd Note

Review Later

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

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

When you purchase from a store several times this would be an example of what kind of table relationship?

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

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

If you add a table with 10 records to a query and add an unrelated table with 4 records to the same query, how many records will display when you run the query?

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

What field property would you use to automatically enter "PA" in a state field?

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

What is not true about field names?

The AND operator will give you the most results in a query.

When you import data, where can you not store it?

Which of the following is not a way to create a multitable query?

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

When does the validation rule check the entered data?

The Enforce Referential Integrity box should normally be checked.

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

What option automatically deletes records in related tables that match the primary key?

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

What field property would allow the user to enter two quote marks with nothing between them ("") into a field with a Short Text data type?