Quiz 3: Tables and Queries in Relational Databases

If you want the results of a query to display only those records that meet all criteria, you would use the ________ operator. A) OR B) NOT C) AND D) NOR

What data type assigns the next consecutive number to new records? A) Number B) AutoNumber C) IncreaseNumber D) Integer

What is not one of the six guidelines for designing tables? A) Store data in as large of number of parts as possible B) Determine the primary keys C) Link the tables on related fields D) Think of what needs you might have in the future

"lastName" is an example of ________. A) Camel case B) Pascal case C) a typing error D) a naming convention that is not recommended because of possible compatibility issues

What field property makes up for the limitation of the field naming rules or common practices? A) Validation Rule B) Input Mask C) Format D) Caption

What is not true about field names? A) They can be up to 64 characters in length. B) They should describe the data they will store. C) They can contain numbers. D) They can begin with a space.

What option automatically deletes records in related tables that match the primary key? A) Autodelete Related Records B) Cascade Update Related Fields C) Cascade Delete Related Records D) Delete and Update Related Records

How many characters can be stored in a field with a Short Text data type? A) 100 B) 255 C) 500 D) 256

How many characters can be stored in a field with a Long Text data type? A) 1,000 B) 12,256 C) Unlimited D) 64,000

What field property insures that all phone numbers have a consistent look? A) Caption B) Format C) Default Value D) Input Mask

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.

What is not true about the hyperlink data type? A) It can store the URL for a web page. B) It can store the path to a file. C) The hyperlink becomes active anytime you hover over it. D) It can store the path to a folder.

What field property would you use to automatically enter "PA" in a state field? A) Format B) Caption C) Default Value D) Start Value

When does the validation rule check the entered data? A) As soon as it is typed into the field B) When the user exits the field C) When the table or form is saved D) When the table of form is closed

What field property forces data to follow certain rules of data entry? A) Validation Rule B) Validation Text C) Format D) Required

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? A) Required B) Indexed C) Allow Zero Length D) Allow Null Length

What is not true about the Caption property? A) It allows labels to be more readable than field names. B) It displays at the column head instead of the field name. C) It is used in both forms and reports. D) The Pascal case is preferred in this property.

What is the suggested data type for a street address? A) Long Text B) Number C) OLE Object D) Short Text

Storing a book's title in more than one table within a database is considered data ________. A) backup B) redundancy C) duplication D) consistency

What field property increases the speed at which searches can be performed? A) Indexed B) Allow Zero Length C) Required D) Result Type

Which field property helps a user know why an entry error was generated? A) Validation Text B) Validation Rule C) Expression D) Error Code

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) List B) Short Text C) Lookup Wizard D) Long Text

What field property helps to make sure that correct data is entered? A) Validation text B) Validation rule C) Format D) Required

Which of the following cannot be imported from one Access database into another Access database? A) Tables B) Sheets C) Forms D) Reports

When you import data, where can you not store it? A) New form B) New table C) Existing table D) Linked table

Enforcing referential integrity assures that ________. A) you cannot enter a value in the foreign key if there is no corresponding value in the primary key B) you cannot enter the same value in the foreign key of the same table C) you cannot leave that field empty D) you cannot enter invalid or incorrect information

What is the most common relationship type? A) Many-to-many B) One-to-many C) One-to-one D) None-to-none (finds records with no matching primary and foreign keys)

Checking the Cascade Delete Related Records checkbox assures that ________. A) you cannot delete related records if they have more than one foreign key records B) you cannot delete a primary key record if it has related records C) all records will be deleted in related tables if you delete the primary key in the primary table D) all primary keys will be deleted if you delete related records

When you purchase from a store several times this would be an example of what kind of table relationship? A) Many-to-one (many customers - one purchase) B) One-to-one (one customer - one store) C) Many-to-many (many items purchased - many times) D) One-to-many (one customer - many purchases)

Which of the following would make a good primary key? A) AutoNumber data type B) Customer name C) Number data type D) Birthday

When you run a query, it displays in what view? A) Design B) Layout C) Print Preview D) Datasheet

To limit the number of records displayed when a query is run you add ________. A) sorting B) criteria C) less fields D) less tables

Which of the following comparison operators is not valid? A) <> B) >= C) => D) <

The ________ property provides literal characters that are typed for each entry. A) Validation Rule B) Default Value C) Validation text D) Input Mask

Which logical operator would return the fewest records? A) AND B) OR C) NOT D) NOR

Which wildcard character matches a single character in the same position as the wildcard? A) ? B) * C) [] D) [!]

Which option would this wildcard, "H[!oe]" not display? A) House B) Hat C) His D) Humming

Which of the following is not a way to create a multitable query? A) Modifying an existing query B) Using the Query Wizard C) Adding a table in the Relationships window D) Creating a query from scratch

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? A) 40 B) 10 C) 4 D) 0 (since the tables are not related)

A good way to know what fields you will need is to think of what reports you might need later.

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

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

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

Access requires that common fields be named exactly the same.

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

The primary key can only be a single field.

You can only have one primary key in a table, but you can have several foreign keys.

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

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

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

The Enforce Referential Integrity box should normally be checked.

The Cascade Update Related Fields checkbox is irrelevant if the primary key has an AutoNumber field type.

One advantage of establishing relationships between tables is so you can combine fields from more than one table in a query or report.

There might be times when you want to add the same field to a query several times.

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

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

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

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

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

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

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.

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

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

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

You should store data in their ________ parts.

The ________ key is what guarantees that a record is unique.

Storing duplicate data in more than one table is called data ________.

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

The ________ field type makes a good primary key.

When you need a query to return entries based on any of a set of criteria, then you would use the ________ condition.

Use the ________ data type when you want to store multiple pictures in your records.

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

A field's ________ determine how that field functions.

Use the ________ data type if you need to store a True or False value.

In table relationships, the foreign key of one table cannot be joined to the ________ key of another table.

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

Access uses ________ to speed up the sorting or filtering process.

The ________ relationship is used when joining two primary keys.

You cannot create a relationship between two tables unless there is at least one ________ key.

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

In table relationships, the primary key is normally joined to a ________ key.

The ________ relationship requires a junction table for it to function properly.

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

The term that can be used in a query to refer to blank cells is ________.

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

One way to fix the problem that exists if you add a table with 10 records to a query and add an unrelated table with 4 records to the same query is to add ________ lines if there are common fields.

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

You can easily ________ your data by using a multitable query.

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

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

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

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

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

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

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