Deck 3: Tables and Queries in Relational Databases

Question 1

"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

Answer 1

A

Question 2

What field property insures that all phone numbers have a consistent look?

A) Caption
B) Format
C) Default Value
D) Input Mask

Answer 2

D

Question 3

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

A) Indexed
B) Allow Zero Length
C) Required
D) Result Type

Answer 3

A

Question 4

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

Question 5

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

Question 6

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

A) Validation Rule
B) Validation Text
C) Format
D) Required

Question 7

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

A) 100
B) 255
C) 500
D) 256

Question 8

What data type assigns the next consecutive number to new records?

A) Number
B) AutoNumber
C) IncreaseNumber
D) Integer

Question 9

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

Question 10

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

Question 11

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.

Question 12

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.

Question 13

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.

Question 14

What is the suggested data type for a street address?

A) Long Text
B) Number
C) OLE Object
D) Short Text

Question 15

Storing a book's title in more than one table within a database is considered data ________.

A) backup
B) redundancy
C) duplication
D) consistency

Question 16

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

A) Format
B) Caption
C) Default Value
D) Start Value

Question 17

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

Question 18

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.

Question 19

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

Question 20

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

Question 21

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

Question 22

To limit the number of records displayed when a query is run you add ________.

A) sorting
B) criteria
C) less fields
D) less tables

Question 23

Which of the following comparison operators is not valid?

A) <>
B) >=
C) =>
D) <

Question 24

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

A) House
B) Hat
C) His
D) Humming

Question 25

Which logical operator would return the fewest records?

A) AND
B) OR
C) NOT
D) NOR

Question 26

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

A) Validation Text
B) Validation Rule
C) Expression
D) Error Code

Question 27

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)

Question 28

The ________ property provides literal characters that are typed for each entry.

A) Validation Rule
B) Default Value
C) Validation text
D) Input Mask

Question 29

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

A) ?
B) *
C) []
D) [!]

Question 30

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

Question 31

What field property helps to make sure that correct data is entered?

A) Validation text
B) Validation rule
C) Format
D) Required

Question 32

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)

Question 33

Which of the following cannot be imported from one Access database into another Access database?

A) Tables
B) Sheets
C) Forms
D) Reports

Question 34

Which of the following would make a good primary key?

A) AutoNumber data type
B) Customer name
C) Number data type
D) Birthday

Question 35

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

A) Design
B) Layout
C) Print Preview
D) Datasheet

Question 36

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

A) New form
B) New table
C) Existing table
D) Linked table

Question 37

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

Question 38

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)

Question 39

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

Question 40

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

Question 41

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

Question 42

Access requires that common fields be named exactly the same.

Question 43

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

Question 44

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

Question 45

The Enforce Referential Integrity box should normally be checked.

Question 46

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

Question 47

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

Question 48

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

Question 49

The primary key can only be a single field.

Question 50

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

Question 51

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

Question 52

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

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

The ________ relationship is used when joining two primary keys.

Question 63

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.

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

You should store data in their ________ parts.

Question 70

A field's ________ determine how that field functions.

Question 71

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

Question 72

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

Question 73

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

Question 74

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

Question 75

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

Question 76

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

Question 77

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

Question 78

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

Question 79

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

Question 80

The ________ field type makes a good primary key.