Exam 2: 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

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?

The query wizard is best used to create what kind of query?

Access requires that common fields be named exactly the same.

A database designer needs to be concerned about what fields might be needed rather than file size.

Which logical operator would return the fewest records?

For security purposes you want to have data redundancy in your tables.

What objects will not use the caption instead of the field names?

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

What field property forces data to follow certain rules of data entry?

To have your table perform mathematical functions automatically you would use a ________ field.

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

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

Use the ________ data type when you do not know how much text space will be required.

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

How many characters can be stored in a field with a Long Text data type?

Which wildcard character matches a single character in the same position as the wildcard?

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

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

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