Latest ICDL-ACCESS Practice Tests with Actual Questions

Get Complete pool of questions with Premium PDF and Test Engine

Exam Code : ICDL-ACCESS
Exam Name : ICDL the access
Vendor Name : "ICDL"






ICDL-ACCESS Dumps

ICDL-ACCESS Braindumps ICDL-ACCESS Real Questions ICDL-ACCESS Practice Test ICDL-ACCESS Actual Questions


ICDL


ICDL-ACCESS


ICDL the access


https://killexams.com/pass4sure/exam-detail/ICDL-ACCESS





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



Question: 70

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





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



Question: 71

Which two of the following statements are true?



  1. <100 will find values that are greater than 100.

  2. >= 10 will find values that are greater than or equal to 10

  3. >=Sep 30 1950 will find dates that are equal to or before Sep 30th 1950.

  4. <=Oct 31 1956 will find dates that are equal to or after Oct 31st 1956.

  5. <Jan 1 1965 And > Dec 31 1963 will find all dates in 1964




Answer: B, E



Question: 72

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.




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



Question: 73

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.




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



Question: 74

Create a new query using the Simple Query Wizard.





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



Question: 75

Which one of the following is not a database?


  1. A telephone directory

  2. A sales catalogue.

  3. A newsletter.

  4. A price list




Answer: C



Question: 76

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



  1. You can change the layout of a report in design view

  2. The order in which you add fields in the wizard sets how they display in the report

  3. If you move a Page Header control, the associated Detail control will move with it.

  4. You can change the layout of a report in Print Preview.

  5. You can rearrange the order of fields in a report using the Sorting and Grouping dialog

box.




Answer: A, B