Exam 2: Access: Tables and Queries in Relational Databases

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

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

In query design, the ________ row allows you to set limits on what records are displayed.

Although you can create calculated fields in a query, most prefer to add them the table instead.

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

"lastName" is an example of ________.

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

You can save time and help prevent errors when you ________ data from another an external source.

What is the most common relationship type?

When you run a query, it displays in what view?

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

If you wanted to add January 16, 1957 as text criteria, how would you enter it?

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

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

Which field property helps a user know why an entry error was generated?