Deck 2: Tables and Queries in Relational Databases

Question 1

What is the suggested data type for a street address?

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

Answer 1

D

Question 2

What table property always necessitates an entry?

A) Required
B) Number
C) AutoNumber
D) Date/Time

Answer 2

C

Question 3

What field property would you use to insure that all the phone numbers looked consistent?

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

Answer 3

D

Question 4

What view offers the most flexibility in setting the properties of a field?

A) Datasheet view
B) Page Layout view
C) SQL view
D) Design View

Question 5

"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

Question 6

Where can you not use calculated fields?

A) In a report
B) In a module
C) In a form
D) In a table

Question 7

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 8

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

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

Question 9

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

A) Macros
B) Datasheets
C) Forms
D) Reports

Question 10

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 11

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 12

What is not critical when you are first designing a database?

A) What tables you will need
B) What fields you will need
C) What the field names will be
D) What type of data will be stored in each field

Question 13

The first step to resizing a column in datasheet view is to move the pointer until it looks like a ________.

A) four-headed arrow and then click
B) two-headed arrow and then click
C) thick black line and then click
D) thick green line and then click

Question 14

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 15

What is not one of the six guidelines for creating fields?

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

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) It lists the hyperlink, but you must press the Ctrl key while you click the hyperlink for it to work
D) It can store the path to a folder

Question 18

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

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

Question 19

What field property would allow the user to enter "" into a field with a Short Text data type?

A) Required
B) Indexed
C) Allow Zero Length
D) Allow Null Length

Question 20

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

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

Question 21

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 22

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 23

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

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

Question 24

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

A) Multitable queries
B) Single table queries
C) Advanced queries
D) Basic queries

Question 25

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

Which of the following comparison operators is not valid?

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

Question 28

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 29

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 30

Which logical operator would return the fewest records?

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

Question 31

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

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

Question 32

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

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

Question 33

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

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

Question 34

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

A) January 16, 1957
B) #January 16, 1957#
C) =January 16, 1957
D) "January 16, 1957"

Question 35

What can you not import from one Access database into another Access database?

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

Question 36

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

A) Many-to-one (many purchases - one customer)
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 37

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 38

Which of the following would make a good primary key?

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

Question 39

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

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

Question 40

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 41

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

Question 42

You should store data in their ________ parts.

Question 43

Access uses ________ to speed up the sorting process.

Question 44

A field's ________ determine how that field functions.

Question 45

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

Question 46

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

Question 47

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

Question 48

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

Question 49

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

Question 50

The ________ field type makes a good primary key.

Question 51

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

Question 52

The ________ relationship is used when joining two primary keys.

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

The Enforce Referential Integrity box should normally be checked.

Question 62

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

Question 63

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.

Question 64

A person's age is often a field used in table design.

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

The primary key can only be a single field.

Question 70

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

Question 71

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

Question 72

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

Question 73

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

Question 74

The ________ sign should be put around dates so that Access knows they are dates.

Question 75

Access requires that common fields be named exactly the same.

Question 76

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

Question 77

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 another ________ that does have common fields with both existing tables.

Question 78

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

Question 79

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

Question 80

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