FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 5: Using Reports

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

True/False

Review LaterAdd Note

Review Later

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

A) True
B) False

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

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

E) C) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 33

True/False

Review LaterAdd Note

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

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

Kelsey wants to create queries to answer management questions from a relational database she does not have much experience with. Why might a Relationships report help her create the queries?

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

The . J p g file extension is short for JPEG , an acronym for the Joint Photographic Experts Group.

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

In the accompanying figure, explain how two tables are being joined. Mention which tables are being joined, the relationship that is being created, and the fields used to make the connection.

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

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

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

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

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.

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

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

Which of the following is NOT true about field properties?

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

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

A subdatasheet is used to modify field properties.