Deck 5: Modifying the Database Structure Question

Question 1

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

Answer 1

True

Question 2

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 2

False

Question 3

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

Answer 3

True

Question 4

A subdatasheet is used to examine field properties.

Question 5

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

Question 6

The Field Size property is not available for Currency fields.

Question 7

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

Question 8

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

Question 9

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

Question 10

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

A)Record
B)Field
C)Object
D)Property

Question 11

Each field must be given an associated field description.

Question 12

The Enforce Referential Integrity button is found on the Database toolbar.

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

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

A)Text
B)Data
C)Linking
D)Primary key

Question 16

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

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

Question 17

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

Question 18

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 19

Use the Format property for a Date/Time field to display the date 1/17/2010 as January 17, 2010.

Question 20

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 21

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

A)Field names
B)Field entries
C)Data types
D)Field properties

Question 22

This data type sequences each new record with the next available integer.

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

Question 23

Where do you modify field properties?

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

Question 24

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

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

Question 25

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

A)Referential integrity symbol
B)Orphan record symbol
C)Subdatasheet symbol
D)Infinity symbol

Question 26

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

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

Question 27

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 28

If the Products and Sales tables were joined in a one-to-many relationship, which field would most likely be the linking field?

A)ProductID
B)CustomerID
C)EmployeeID
D)SalesID

Question 29

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

A)One
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 30

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

A)Redundant
B)Textual
C)Numeric
D)Rarely used

Question 31

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

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 33

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

A)Primary key field
B)Foreign key
C)Field property
D)Table name

Question 34

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 35

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

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

Question 36

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

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

Question 37

In the figure above, item 4 references a ____.

A)Field name
B)Table name
C)Relationship
D)Link line

Question 38

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

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

Question 39

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

A)Record
B)Table
C)Link
D)Foreign

Question 40

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 41

>=#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 42

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

Question 43

List three principles of relational database design.

Question 44

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

Question 45

In the figure above, the ____________________ field is the key field.

Question 46

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 47

Explain the term "orphan record" and how to avoid creating one in an Access relational database.

Question 48

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

Question 49

In the figure above, the ____________________  field's properties are displayed in the Field Properties pane.

Question 50

____________________  is the name of the table in the figure above.

Question 51

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 52

The file extension for a database created in Access 2010 is:

A).acc
B).accdb
C).mdb
D).mda

Question 53

Explain why using an employee's last name as the primary key field in an employee table does not constitute good database design.

Question 54

In the figure above, the Data Type for the Phone field is ____________________ .

Question 55

The good Field Size property value for a State field is ____.

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

Question 56

In the figure above, the Data Type of the CustNo field is ____________________ .

Question 57

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 58

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 59

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

A)09/06/2009
B)9/6/2009
C)9/6/9
D)09/06/09

Question 60

The Input Mask property contains how many parts?

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

Question 61

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

Question 62

In the figure pictured above, the Duration field is given a Number data type.Explain why this is better than a Text data type for this field.

Question 63

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

Question 65

After creating the table pictured above, Grant wants to allow only dates on or after January 1, 2008, in the TourStartDate field. What entries would he use for the Validation Rule and Validation Text properties for this field?

Question 66

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

Question 67

Field descriptions are entered in Table Design View.

Question 68

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

Question 69

.j p g file extension is short for J P E G, an acronym for the Joint Photographic Experts Group.

Question 70

Grant enters a tour date of May 14, 2013 in the TourStartDate field pictured above. In what way will the date appear when he tabs out of the field in Datasheet View?

Question 71

A Number data type is used to store values that represent money.