20:00

PDF|

Guide for ICDL-Access Exam

Quiz ICDL-Access Exam

Free Test
/ 10

Quiz

1/10
Which two of these statements about referential integrity are true?
Select the answer
2 correct answers
A.
If a record in a parent table has a related child record referential integrity prevents you from deleting the parent record
B.
In Access, referential integrity is enforced by typing in a rule.
C.
You can set rules about referential integrity in a one table database.
D.
Referential integrity ensures that records in linked tables are automatically updated when changes are made.
E.
A child record cannot be entered unless it has a parent in the database if referential integrity is used

Quiz

2/10
Log on to the database named Car Hire with the username icoffey and password ken*72 Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 1-3662536689
Select the answer
1 correct answer
Select open an existing file -> select c:\windows\desktop\car hire -> ok -> type icoffey in the name box -> ken*72 in the password box

Quiz

3/10
Create a new blank database. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 3-2546414097 1
Select the answer
1 correct answer
Click on the new tool from the database toolbar -> select database -> ok

Quiz

4/10
Use Microsoft Access Help to find information about decimal numbers. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 5-1615887723
Select the answer
1 correct answer
Help -> Microsoft access help -> type decimal numbers -> search

Quiz

5/10
Hide the Formatting (Form/Report) toolbar. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 7-3263483679
Select the answer
1 correct answer
View -> toolbars -> select formatting (form/Report)

Quiz

6/10
Save the above table and give it the name Sals. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 9-235395295
Select the answer
1 correct answer
Click on the save tool from the table design toolbar -> type Sales -> ok

Quiz

7/10
Enter the field name Contact Name into the empty row. When you have finished, move the insertion point to the Data Type column. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 11-3209653254
Select the answer
1 correct answer
Type Contact Name -> press Tab from the keyboard

Quiz

8/10
Change the entry in the Surname field of this record to Dawson. Move to the next field in this record when you have finished. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 13-3552263430
Select the answer
1 correct answer
Use the back space from the keyboard to delete Lamont -> type Dawson -> press Tab from the keyboard

Quiz

9/10
Save and close this table. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 19-1661569853
Select the answer
1 correct answer
Click on save tool from the table design toolbar -> close the table

Quiz

10/10
The Surname field will be used in a lot of searches, so we should index it. Create a suitable index for this field. Certification Exam ICDL-Access Exam ICDL ICDL-ICDL-Access 21-2946623981
Select the answer
1 correct answer
In the indexed box -> choose yes (duplicates ok)
Looking for more questions?Buy now

ICDL-Access Exam Practice test unlocks all online simulator questions

Thank you for choosing the free version of the ICDL-Access Exam practice test! Further deepen your knowledge on ICDL Simulator; by unlocking the full version of our ICDL-Access Exam Simulator you will be able to take tests with over 76 constantly updated questions and easily pass your exam. 98% of people pass the exam in the first attempt after preparing with our 76 questions.

BUY NOW

What to expect from our ICDL-Access Exam practice tests and how to prepare for any exam?

The ICDL-Access Exam Simulator Practice Tests are part of the ICDL Database and are the best way to prepare for any ICDL-Access Exam exam. The ICDL-Access Exam practice tests consist of 76 questions and are written by experts to help you and prepare you to pass the exam on the first attempt. The ICDL-Access Exam database includes questions from previous and other exams, which means you will be able to practice simulating past and future questions. Preparation with ICDL-Access Exam Simulator will also give you an idea of the time it will take to complete each section of the ICDL-Access Exam practice test . It is important to note that the ICDL-Access Exam Simulator does not replace the classic ICDL-Access Exam study guides; however, the Simulator provides valuable insights into what to expect and how much work needs to be done to prepare for the ICDL-Access Exam exam.

BUY NOW

ICDL-Access Exam Practice test therefore represents an excellent tool to prepare for the actual exam together with our ICDL practice test . Our ICDL-Access Exam Simulator will help you assess your level of preparation and understand your strengths and weaknesses. Below you can read all the quizzes you will find in our ICDL-Access Exam Simulator and how our unique ICDL-Access Exam Database made up of real questions:

Info quiz:

  • Quiz name:ICDL-Access Exam
  • Total number of questions:76
  • Number of questions for the test:50
  • Pass score:80%

You can prepare for the ICDL-Access Exam exams with our mobile app. It is very easy to use and even works offline in case of network failure, with all the functions you need to study and practice with our ICDL-Access Exam Simulator.

Use our Mobile App, available for both Android and iOS devices, with our ICDL-Access Exam Simulator . You can use it anywhere and always remember that our mobile app is free and available on all stores.

Our Mobile App contains all ICDL-Access Exam practice tests which consist of 76 questions and also provide study material to pass the final ICDL-Access Exam exam with guaranteed success. Our ICDL-Access Exam database contain hundreds of questions and ICDL Tests related to ICDL-Access Exam Exam. This way you can practice anywhere you want, even offline without the internet.

BUY NOW