Deck 6: Modifying the Database Structure

Question 1

The "one" field of a one-to-many relationship is never the primary key field in the table on the "one" side of the relationship.

Answer 1

False

Question 2

Modifying the Decimal Places property changes the way the data is presented.

Answer 2

True

Question 3

You can edit or delete a relationship once it has been created in the Relationships window.

Answer 3

True

Question 4

The goal of building one-to-many relationships between tables is to minimize ____ data.

A) redundant
B) textual
C) numeric
D) rarely used

Question 5

For a Date/Time field, use the Format property to display the date 1/17/2015 as January 17, 2015.

Question 6

The Field Size property is not available for Currency fields.

Question 7

The Enforce Referential Integrity button is found on the DESIGN tab of the ribbon.

Question 8

The Attachment data type is exactly the same as the OLE data type of previous versions of Access.

Question 9

In an Access relational database, to tie the information from one table to another, a(n) ____ must be common to each table.

A) record
B) field
C) object
D) property

Question 10

Each field must be given an associated field description.

Question 11

When a Caption property is not entered, the field name is used to label the field.

Question 12

A common place to use an Input Mask property would be for a Phone Number field.

Question 13

Referential integrity allows the user to delete a record from the "one" table if it has matching records in the "many" table.

Question 14

Which of the following is a clue that a database needs to be redesigned?

A) Key fields are defined for each table.
B) One-to-many relationships are defined for each table.
C) There are multiple tables in the database.
D) There is redundant data in one or more tables.

Question 15

Changing the Decimal Places property for a field does not change the actual data stored in the field.

Question 16

A relational database can best be described as a collection of related ____ designed to minimize redundant data.

A) indexes
B) tables
C) links
D) properties

Question 17

The Validation Rule property is not used with Text or Date/Time fields.

Question 18

Enforcing referential integrity guarantees that inaccurate data is not entered into any field.

Question 19

The ____ key field is the linking field on the "many" side of the relationship.

A) record
B) table
C) link
D) foreign

Question 20

A subdatasheet is used to modify field properties.

Question 21

The process of removing and fixing orphan records is often called ____.

A) scrubbing the database
B) enforcing rules
C) applying syntax
D) adding criteria

Question 22

You can enter optional field descriptions in Table ____ View.

A) SQL
B) Query
C) Design
D) Layout

Question 23

The ____ Lookup property determines whether you can enter a new value into a field with other Lookup properties.

A) Row Source
B) Limit to List
C) Allow Value List Edits
D) Display Control

Question 24

In the accompanying figure, the "one" side of a one-to-many relationship is referenced by which item?

A) 1
B) 2
C) 3
D) 4

Question 25

A field that contains unique information for each record is called a(n) ____ field.

A) text
B) data
C) linking
D) primary key

Question 26

Which of the following is NOT a problem with duplicated data?

A) It is error-prone.
B) It limits query capabilities.
C) It limits reporting capabilities.
D) It creates its own one-to-many relationships.

Question 27

Which of the following is NOT a good candidate for a primary key field for a Customer table?

A) Last Name
B) Customer Number
C) Employee Identification Number
D) Customer ID

Question 28

Which of the following is NOT defined in Table Design View?

A) field names
B) field entries
C) data types
D) field properties

Question 29

Which of the following is NOT shown on a Relationship report?

A) table names
B) field names
C) primary key field data values
D) one-to-many relationship lines

Question 30

The ____ property determines whether users can add or edit the list of items in a Lookup field.

A) Row Source
B) Limit to List
C) Allow Value List Edits
D) Display Control

Question 31

Which of the following is NOT a principle of relational database design?

A) Design each table to contain fields that describe only one subject.
B) Identify a primary key field or key field combination for each table.
C) Data should be entered before table relationships are built.
D) Build one-to-many relationships between the tables of your database using a field common to each table.

Question 32

The Field Properties pane displays information for how many fields at the same time?

A) Only the selected field.
B) However many are visible in the window.
C) All of the fields in that particular table.
D) All of the fields in the entire database.

Question 33

What property controls both the values that users can enter into a text box and provides a visual guide as users enter data?

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

Question 34

____ properties allow you to supply a drop-down list of values for a field.

A) Key
B) Relationship
C) Lookup
D) Junction

Question 35

A(n) ____ key field is the field used on the "one" side of a one-to-many relationship.

A) primary
B) first
C) foreign
D) infinity

Question 36

The table that joins to other tables that have many-to-many relationship is called the ____ table.

A) junction
B) linking
C) primary
D) relational

Question 37

What data type sequences each new record with the next available integer?

A) Yes/No
B) Memo
C) Attachment
D) AutoNumber

Question 38

In the accompanying figure, item 4 references a(n) ____.

A) infinity symbol
B) table name
C) relationship
D) link line

Question 39

In the accompanying figure, item 1 points to a(n) ____.

A) primary key field
B) foreign key
C) field property
D) table name

Question 40

In the accompanying figure, item 2 points to a(n) ____.

A) referential integrity symbol
B) orphan record symbol
C) subdatasheet symbol
D) primary key field symbol

Question 41

In the accompanying figure, the data type of the PaymentDate field is ____________________.

Question 42

In the accompanying figure, the ____________________ field would be the best candidate for the primary key field.

Question 43

A good Field Size property value for a state abbreviation field is ____.

A) 2
B) 10
C) 50
D) 255

Question 44

Which of the following is NOT true about field properties?

A) Modifying them helps ensure database accuracy.
B) Some are required, and some are optional.
C) They are the same for each data type.
D) They can be used to change the way data is displayed.

Question 45

The ____________________ property provides an easy-to-use visual pathway to facilitate accurate data entry.

Question 46

(999)000-000;1;_ would be a possible entry for which field property?

A) Format
B) Input Mask
C) Caption
D) Validation Rule

Question 47

A(n) ____________________ record is a record in the "many" table that doesn't have a matching entry in the linking field of the "one" table.

Question 48

____________________ is the data type for the SalesNo field in the accompanying figure.

Question 49

Which Short Text field property should you use to specify whether an entry was required for the field?

A) Default Value
B) Default
C) Required
D) Test

Question 50

Byte, Long Integer, Single, and Double are examples of entries for which property?

A) Field Size
B) Format
C) Input Mask
D) Validation Rule

Question 51

Which of the following is NOT a possible entry for the Field Size property of a Number field?

A) Currency
B) Byte
C) Long Integer
D) Single

Question 52

The Input Mask property contains how many parts?

A) 1
B) 2
C) 3
D) 4

Question 53

Where do you modify field properties?

A) In Table Layout View.
B) In Table Design View.
C) In Database Design View
D) As you are entering data in a form.

Question 54

The ____ property provides a label used to describe the field.

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

Question 55

>=#1/1/93# is an example of an entry for which property for a Date/Time field?

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

Question 56

Use the ____ property to display an explanatory message when a user tries to enter data that breaks a validation rule.

A) Validation Rule
B) Description Rule
C) Input Mask
D) Validation Text

Question 57

The entry mm/dd/yyyy in a Date/Time field's Format property would display September 6, 2016 as: ____.

A) 09/06/2016
B) 9/6/2016
C) 9/6/16
D) 09/06/16

Question 58

In the accompanying figure, the data type for the PaymentAmt field is ____________________.

Question 59

A printout of the Relationships window is called the ____________________ report.

Question 60

The Row ____________________ Lookup property stores the values for the drop-down list of a Lookup field.

Question 61

Using the accompanying figure, list three principles of relational database design. Use the specific table and field names in your explanation.

Question 62

Anne Michael is working with the table in the accompanying figure. Explain what will happen when she works with the PaymentNo field in Datasheet View.

Question 63

A(n) Number data type is used to store values that represent money. _________________________

Question 64

Match the following common Number field properties with the correct description.
a.Long integer
d.Field size
b.Single
e.Double
c.Byte
Stores numbers times 10 to the -38th to +38th power

Question 65

To quickly remove all Lookup properties, change the Display Control property to Combo Box.
_________________________

Question 66

You can modify the Field Size property of a Short Text field. _________________________

Question 67

In the accompanying figure, explain why using an employee's last name as the primary key field in the Employees table does not constitute good database design.

Question 68

If the primary key field on the "one" side of a one-to-many relationship has an AutoNumber data type, then the data type on the foreign key field must be set to AutoNumber. _________________________

Question 69

In the accompanying figure, how does the Enforce Referential Integrity option relate to the creation of orphan records?

Question 70

Match the following common Number field properties with the correct description.
a.Long integer
d.Field size
b.Single
e.Double
c.Byte
Stores numbers from 0 to 255

Question 71

To move a field list in the Relationships window, drag the table's primary key field. _________________________

Question 72

Using the accompanying figure, explain the term "orphan record" and how to avoid creating one in the Donations table.

Question 73

To edit the list of values for a Lookup Field in Datasheet View, click the Edit List Items button.
_________________________

Question 74

You can modify the Field Size property of a Number field. _________________________

Question 75

Match the following common Number field properties with the correct description.
a.Long integer
d.Field size
b.Single
e.Double
c.Byte
Stores numbers in the range of 10 to the -324th to +324th power

Question 76

The . jpg file extension is short for JPEG, an acronym for the Joint Photographic Experts Group. _________________________

Question 77

Match the following common Number field properties with the correct description.
a.Long integer
d.Field size
b.Single
e.Double
c.Byte
Determines the largest number that can be entered in a field

Question 78

Field descriptions may be entered in Table Design View. _________________________

Question 79

Match the following common Number field properties with the correct description.
a.Long integer
d.Field size
b.Single
e.Double
c.Byte
Stores numbers from -2,147,483,648 to 2,147,483,647

Question 80

The Input Mask property provides a pattern for data to be entered using three parts.