Exam 16: Access 2013 : Modifying the Database Structure

arrow
  • Select Tags
search iconSearch Question
flashcardsStudy Flashcards
  • Select Tags

A subdatasheet is used to modify field properties.

(True/False)
4.9/5
(25)

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

(Multiple Choice)
4.7/5
(33)

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

(Short Answer)
4.8/5
(34)

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

(Multiple Choice)
4.9/5
(35)

Each field must be given an associated field description.

(True/False)
4.8/5
(44)

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

(True/False)
4.8/5
(28)

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.

(True/False)
4.7/5
(36)

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

(Multiple Choice)
4.9/5
(31)

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

(True/False)
4.9/5
(31)

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

(True/False)
4.8/5
(39)

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

(True/False)
4.9/5
(47)

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

(Short Answer)
4.9/5
(40)

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

(Multiple Choice)
4.9/5
(30)

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

(True/False)
4.7/5
(37)

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

(Short Answer)
4.7/5
(42)

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

(Short Answer)
4.9/5
(41)
Showing 61 - 76 of 76
close modal

Filters

  • Essay(0)
  • Multiple Choice(0)
  • Short Answer(0)
  • True False(0)
  • Matching(0)