ICDL access practice test

ICDL the Access Exam


Question 1

Which two of the following statements about the layout of data field and headers are true:

  • A. You can change the layout of a report in design view
  • B. The order in which you add fields in the wizard sets how they display in the report
  • C. If you move a Page Header control, the associated Detail control will move with it.
  • D. You can change the layout of a report in Print Preview.
  • E. You can rearrange the order of fields in a report using the Sorting and Grouping dialog box.
Answer:

A, B

Discussions

Question 2

Which one of the following is not a database?

  • A. A telephone directory
  • B. A sales catalogue.
  • C. A newsletter.
  • D. A price list
Answer:

C

Discussions

Question 3

Create a new query using the Simple Query Wizard.

  • A. Select Queries from the object pane -> double click on create query by using wizard
Answer:

A

Discussions

Question 4

The Product code field contains a unique reference for each product. This field will be used in a lot of
searches, so we should index
it.

Create a suitable index for this field.

  • A. Put the cursor in the indexed box -> from the drop down list select yes (No Duplicates)
Answer:

A

Discussions

Question 5

Select the data type that will automatically assign a unique Customer ID number to each new
customer.

Move to the next cell when you have finished.

  • A. In the data type column -> use the drop down list and select Auto number -> press tab from the keyboard
Answer:

A

Discussions

Question 6

Which two of the following statements are true?

  • A. <100 will find values that are greater than 100.
  • B. >= 10 will find values that are greater than or equal to 10
  • C. >=Sep 30 1950 will find dates that are equal to or before Sep 30th 1950.
  • D. <=Oct 31 1956 will find dates that are equal to or after Oct 31st 1956.
  • E. <Jan 1 1965 And > Dec 31 1963 will find all dates in 1964
Answer:

B, E

Discussions

Question 7

Access the option that would enable you to create a new query without the help of the Simple Query
Wizard.

  • A. Select Queries from the objects pane -> double click on create query in design view
Answer:

A

Discussions

Question 8

Carry out the necessary steps to ensure that you can enter half-days in the Days leave field.

  • A. In the field size box use the drop down list -> select single
Answer:

A

Discussions

Question 9

Print 1 copy of the first 5 records in this table using the default printer.

  • A. Select the first five records -> file -> print -> select selected records -> ok
Answer:

A

Discussions

Question 10

Open the Payments by Patient report in Print Preview.

  • A. Select the payments by patient -> click on preview
Answer:

A

Discussions
To page 2