Deck 3: Access: Tables and Queries in Relational Databases

Question 1

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

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

Answer 1

C

Question 2

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

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

Answer 2

A

Question 3

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

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

Answer 3

B

Question 4

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

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 6

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 7

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 8

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 9

What is the suggested data type for a street address?

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

Question 10

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 11

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

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

Question 12

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

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

Question 13

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 14

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

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

Question 15

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

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

Question 16

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 17

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 18

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 19

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 20

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 21

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

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

Question 22

Which logical operator would return the fewest records?

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

Question 23

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

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

Question 24

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 25

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 26

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 27

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

Question 28

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

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

Question 29

Which of the following comparison operators is not valid?

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

Question 30

Which of the following would make a good primary key?

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

Question 31

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 32

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

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

Question 33

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 34

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

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

Question 35

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

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

Question 36

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 37

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

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

Question 38

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 39

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 40

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 41

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

Question 42

The Enforce Referential Integrity box should normally be checked.

Question 43

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

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

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

Question 51

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

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

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

Question 54

Access requires that common fields be named exactly the same.

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

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

Question 60

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

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

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

A field's ________ determine how that field functions.

Question 70

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

Question 71

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

Question 72

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 73

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 74

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

Question 75

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

Question 76

The ________ relationship is used when joining two primary keys.

Question 77

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

Question 78

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

Question 79

The ________ field type makes a good primary key.

Question 80

You should store data in their ________ parts.