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

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

(Multiple Choice)
4.7/5
(69)

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

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

(Multiple Choice)
4.9/5
(88)

Each field must be given an associated field description.

(True/False)
4.8/5
(93)

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

(True/False)
4.8/5
(73)

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

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

(Multiple Choice)
4.9/5
(82)

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

(True/False)
5.0/5
(82)

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

(True/False)
4.8/5
(81)

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

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

(Short Answer)
4.9/5
(85)

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

(Multiple Choice)
4.9/5
(69)

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

(True/False)
4.7/5
(78)

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

(Short Answer)
4.8/5
(83)

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

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

Filters

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