ICDL the Access ACCESS Dumps in PDF

Free ICDL ACCESS Real Questions (page: 6)

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

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

Answer(s): A



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

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

Answer(s): A



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

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

Answer(s): A



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

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

Answer(s): A



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:

  1. The answer is Exhibit B.

Answer(s): A



Share your comments for ICDL ACCESS exam with other users:

V
VoiceofMidnight
12/17/2023 4:07:00 PM

Delayed the exam until December 29th.

U
Umar Ali
8/29/2023 2:59:00 PM

A and D are True

V
vel
8/28/2023 9:17:09 AM

good one with explanation

G
Gurdeep
1/18/2024 4:00:15 PM

This is one of the most useful study guides I have ever used.

AI Tutor 👋 I’m here to help!