Verified Test Bank Ch3 Tables And Queries In Relational

Exploring Microsoft Office 365, Access 2019 Comprehensive (Poatsy)

Chapter 3 Tables and Queries in Relational Databases

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

Diff: 2

Objective: A2.07 Specify Query Criteria

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

A) Number

B) AutoNumber

C) IncreaseNumber

D) Integer

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.01 Design a Table

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

Diff: 3

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

6) 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.

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.04 Establish Table Relationships

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

A) 100

B) 255

C) 500

D) 256

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 3

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) Caption

B) Format

C) Default Value

D) Input Mask

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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.

Diff: 3

Objective: A2.02 Create and Modify Tables and Work with Data

12) 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.

Diff: 3

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) Format

B) Caption

C) Default Value

D) Start Value

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) Validation Rule

B) Validation Text

C) Format

D) Required

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

17) 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.

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

18) What is the suggested data type for a street address?

A) Long Text

B) Number

C) OLE Object

D) Short Text

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) backup

B) redundancy

C) duplication

D) consistency

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) Indexed

B) Allow Zero Length

C) Required

D) Result Type

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) Validation Text

B) Validation Rule

C) Expression

D) Error Code

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) Validation text

B) Validation rule

C) Format

D) Required

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

A) Tables

B) Sheets

C) Forms

D) Reports

Diff: 2

Objective: A2.03 Import Data From External Sources

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

A) New form

B) New table

C) Existing table

D) Linked table

Diff: 1

Objective: A2.03 Import Data From External Sources

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

Diff: 2

Objective: A2.04 Establish Table Relationships

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

Diff: 2

Objective: A2.04 Establish Table Relationships

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

Diff: 3

Objective: A2.04 Establish Table Relationships

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

Diff: 3

Objective: A2.04 Establish Table Relationships

30) Which of the following would make a good primary key?

A) AutoNumber data type

B) Customer name

C) Number data type

D) Birthday

Diff: 3

Objective: A2.04 Establish Table Relationships

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

A) Design

B) Layout

C) Print Preview

D) Datasheet

Diff: 2

Objective: A2.05 Create a Single-Table Query

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

A) sorting

B) criteria

C) less fields

D) less tables

Diff: 3

Objective: A2.05 Create a Single-Table Query

33) Which of the following comparison operators is not valid?

A) <>

B) >=

C) =>

D) <

Diff: 2

Objective: A2.07 Specify Query Criteria

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

A) Validation Rule

B) Default Value

C) Validation text

D) Input Mask

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

35) Which logical operator would return the fewest records?

A) AND

B) OR

C) NOT

D) NOR

Diff: 2

Objective: A2.07 Specify Query Criteria

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

A) ?

B) *

C) []

D) [!]

Diff: 1

Objective: A2.07 Specify Query Criteria

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

A) House

B) Hat

C) His

D) Humming

Diff: 3

Objective: A2.07 Specify Query Criteria

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

Diff: 1

Objective: A2.10 Create a Multitable Query

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

Diff: 3

Objective: A2.11 Modify a Multitable Query

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

Diff: 1

Objective: A2.01 Design a Table

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

Diff: 2

Objective: A2.01 Design a Table

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

Diff: 2

Objective: A2.01 Design a Table

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

Diff: 3

Objective: A2.01 Design a Table

44) Access requires that common fields be named exactly the same.

Diff: 2

Objective: A2.01 Design a Table

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

Diff: 3

Objective: A2.07 Specify Query Criteria

46) The primary key can only be a single field.

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.03 Import Data From External Sources

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

Diff: 1

Objective: A2.03 Import Data From External Sources

51) The Enforce Referential Integrity box should normally be checked.

Diff: 1

Objective: A2.04 Establish Table Relationships

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

Diff: 3

Objective: A2.04 Establish Table Relationships

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

Diff: 1

Objective: A2.04 Establish Table Relationships

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

Diff: 3

Objective: A2.05 Create a Single-Table Query

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

Diff: 3

Objective: A2.05 Create a Single-Table Query

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

Diff: 2

Objective: A2.05 Create a Single-Table Query

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

Diff: 2

Objective: A2.05 Create a Single-Table Query

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

Diff: 2

Objective: A2.07 Specify Query Criteria

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

Diff: 3

Objective: A2.08 Specify Query Sort Order and Run a Query

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

Diff: 1

Objective: A2.09 Copy and Modify a Query

61) 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.

Diff: 2

Objective: A2.09 Copy and Modify a Query

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

Diff: 2

Objective: A2.10 Create a Multitable Query

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

Diff: 3

Objective: A2.11 Modify a Multitable Query

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

Diff: 2

Objective: A2.11 Modify a Multitable Query

65) You should store data in their ________ parts.

Diff: 2

Objective: A2.01 Design a Table

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

Diff: 2

Objective: A2.01 Design a Table

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

Diff: 1

Objective: A2.01 Design a Table

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

Diff: 1

Objective: A2.01 Design a Table

69) The ________ field type makes a good primary key.

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.07 Specify Query Criteria

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

73) A field's ________ determine how that field functions.

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 3

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 3

Objective: A2.04 Establish Table Relationships

78) The ________ relationship is used when joining two primary keys.

Diff: 3

Objective: A2.04 Establish Table Relationships

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

Diff: 3

Objective: A2.04 Establish Table Relationships

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

Diff: 1

Objective: A2.04 Establish Table Relationships

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

Diff: 1

Objective: A2.04 Establish Table Relationships

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

Diff: 3

Objective: A2.04 Establish Table Relationships

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

Diff: 2

Objective: A2.05 Create a Single-Table Query

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

Diff: 3

Objective: A2.07 Specify Query Criteria

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

Diff: 2

Objective: A2.07 Specify Query Criteria

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

Diff: 2

Objective: A2.10 Create a Multitable Query

87) 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.

Diff: 3

Objective: A2.11 Modify a Multitable Query

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

Diff: 2

Objective: A2.06 Use the Query Wizard

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

Diff: 3

Objective: A2.11 Modify a Multitable Query

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

Diff: 2

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.02 Create and Modify Tables and Work with Data

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

Diff: 1

Objective: A2.07 Specify Query Criteria

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

Diff: 2

Objective: A2.10 Create a Multitable Query

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

Diff: 1

Objective: Multiple Objectives

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

Diff: 1

Objective: Multiple Objectives

99) Match the following terms with their description:

I. AutoNumber

II. Cascade Delete

III. Cascade Update

IV. Referential Integrity

V. Data Redundancy

A. Increases by one each time a record is added

B. Rules which preserve table relationships when key values change

C. Deletes records in related fields that match the primary key

D. When the same data is stored in two or more tables

E. Changes key value in related tables if key value in primary table is changed

Diff: 1

Objective: Multiple Objectives