Palo Alto Networks

Free ACCESS Exam Braindumps
ICDL the Access Questions 11–15 (page: 4)

Updated On: 9-Feb-2026

Viewing Page 4 of 17 pages.

Download PDF version with 76 Questions

QUESTION: 11

The Surname field will be used in a lot of searches, so we should index it. Create a suitable index for this field.

In the indexed box -> choose yes (duplicates ok)

Answer(s): A

Show Answer Next Question

QUESTION: 12

Specify that dates of birth in this table display in the format 12 November 2000.

Put the insertion point in the Date of birth field -> in the format box -> select long date

Answer(s): A

Show Answer Next Question

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

Show Answer Next Question

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

Show Answer 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

Show Answer Next Question

1
2
3
4
5
6
…
10
17

Download PDF Next Page

Viewing page 4 of 17
Viewing questions 16 - 20 out of 76 questions

Post your Comments and Discuss ICDL ACCESS exam prep with other Community members:

Comments:

Name:

AI Tutor

AI Tutor 👋 I’m here to help!