QUESTION: 13

Which one of the following statements about setting the field size property in a table is True?

If you change the Stock Ref field size property to 15, existing data will not change
If you decrease the Stock Ref field size, data will not be lost.
You cannot change the Stock Ref field size because the table contains data.
If you increase the field size for the Stock Ref field, the data will be processed faster.

Answer(s): A

QUESTION: 14

Enter a validation rule to ensure that entries into this field must be numbers greater than 10.
Press Enter when you have finished.

In the validation Rule box type >10 -> press enter from the keyboard

Answer(s): A

Reveal Solution Next Question

QUESTION: 15

Each author has written a number of books. Set up a one-to-many relationship between the Book and Author tables.

Exhibit A:

Exhibit B:

The answer is Exhibit B.

Answer(s): A

Reveal Solution Next Question

QUESTION: 16

The Payment table contains biling details for each patient. Edit the relationship between the Payment and Patient tables to prevent a patient who has made a payment from being deleted.

Right click on the line between Patient table and Payment table -> select Edit Relationship ... - > check the Enforce Referential Integrity -> ok

Answer(s): A

Reveal Solution Next Question

Free ACCESS Exam Braindumps (page: 5)

QUESTION: 13

QUESTION: 14

QUESTION: 15

QUESTION: 16