carolsmith62's picture
From carolsmith62 rss RSS  subscribe Subscribe

ICDL-ACCESS Practice Tests & Exams 




CertMagic.com is a place where you can find various types of ICDL-ACCESS exam certifications preparation material. CertMagic’s full range of study material for the ICDL-ACCESS exam helps you to be prepared for the ICDL-ACCESS exam fully and enter the exam centre with full confidence.We provide you easy, simple and updated study material. After preparing from the ICDL-ACCESS exam material prepared by us we guarantee you that you will be a certified professional. We guarantee that with CertMagic ICDL-ACCESS study material, you will pass the Certification exam.

 

 
 
Tags:  ICDL-ACCESS Exams  ICDL-ACCESS Certification  ICDL-ACCESS Training  ICDL-ACCESS Practice Exams  ICDL-ACCESS Tests  ICDL-ACCESS Exam Materials  ICDL-ACCESS download 
Views:  362
Published:  November 19, 2009
 
0
download

Share plick with friends Share
save to favorite
Report Abuse Report Abuse
 
Related Plicks
642-542 Practice Tests & Exams

642-542 Practice Tests & Exams

From: carolsmith62
Views: 2641 Comments: 0
CertMagic.com is a place where you can find various types of 642-542 exam certifications preparation material. CertMagic’s full range of study material for the 642-542 exam helps you to be prepared for the 642-542 exam fully and enter the exam centr (more)

 
640-802 Practice Tests & Exams

640-802 Practice Tests & Exams

From: carolsmith62
Views: 2807 Comments: 0

CertMagic.com is a place where you can find various types of 640-802 exam certifications preparation material. CertMagic’s full range of study material for the 640-802 exam helps you to be prepared for the 640-802 exam full (more)

 
4h0-100 Exam

4h0-100 Exam

From: Seal.heart
Views: 503 Comments: 0
CertMagic.com is a place where you can find various types of 4h0-100 exam certifications preparation material. CertMagic’s full range of study material for the 4h0-100 exam helps you to be prepared for the 4h0-100 exam fully and enter the exam centr (more)

 
1T6-511 Exam

1T6-511 Exam

From: Seal.heart
Views: 477 Comments: 0
CertMagic.com is a place where you can find various types of 1T6-511 exam certifications preparation material. CertMagic’s full range of study material for the 1T6-511 exam helps you to be prepared for the 1T6-511 exam fully and enter the exam centr (more)

 
See all 
 
More from this user
MB7-221 Practice Tests & Exam

MB7-221 Practice Tests & Exam

From: carolsmith62
Views: 1349
Comments: 0

000-301 Practice Tests & Exams

000-301 Practice Tests & Exams

From: carolsmith62
Views: 1468
Comments: 0

4H0-100 Practice Tests & Exams

4H0-100 Practice Tests & Exams

From: carolsmith62
Views: 1011
Comments: 0

650-175 Practice Tests & Exams

650-175 Practice Tests & Exams

From: carolsmith62
Views: 1060
Comments: 0

000-743 Practice Tests & Exams

000-743 Practice Tests & Exams

From: carolsmith62
Views: 1014
Comments: 0

HP0-763 Practice Tests & Exams

HP0-763 Practice Tests & Exams

From: carolsmith62
Views: 1339
Comments: 0

See all 
 
 
 URL:          AddThis Social Bookmark Button
Embed Thin Player: (fits in most blogs)
Embed Full Player :
 
 

Name

Email (will NOT be shown to other users)

 

 
 
Comments: (watch)
 
 
Notes:
 
Slide 1: ICDL-ACCESS ICDL The Access Exam Exam: ICDL-ACCESS Demo Edition CERT MAGIC 1 http://www.certmagic.com
Slide 2: ICDL-ACCESS QUESTION: 1 Which two of these statements about referential integrity are true? 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 Answer: A, E QUESTION: 2 Log on to the database named Car Hire with the username icoffey and password ken*72 2 http://www.certmagic.com
Slide 3: ICDL-ACCESS 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 QUESTION: 3 Create a new blank database. Answer: Click on the new tool from the database toolbar -> select database -> ok QUESTION: 4 Use Microsoft Access Help to find information about decimal numbers. 3 http://www.certmagic.com
Slide 4: ICDL-ACCESS Answer: Help -> Microsoft access help -> type decimal numbers -> search QUESTION: 5 Hide the Formatting (Form/Report) toolbar. 4 http://www.certmagic.com
Slide 5: ICDL-ACCESS Answer: View -> toolbars -> select formatting (form/Report) QUESTION: 6 Save the above table and give it the name Sals. 5 http://www.certmagic.com
Slide 6: ICDL-ACCESS Answer: Click on the save tool from the table design toolbar -> type Sales -> ok QUESTION: 7 Enter the field name Contact Name into the empty row. When you have finished, move the insertion point to the Data Type column. 6 http://www.certmagic.com
Slide 7: ICDL-ACCESS Answer: Type Contact Name -> press Tab from the keyboard QUESTION: 8 Change the entry in the Surname field of this record to Dawson. Move to the next field in this record when you have finished. 7 http://www.certmagic.com
Slide 8: ICDL-ACCESS Answer: Use the back space from the keyboard to delete Lamont -> type Dawson -> press Tab from the keyboard QUESTION: 9 Navigate quickly to the last record in this table. 8 http://www.certmagic.com
Slide 9: ICDL-ACCESS Answer: 9 http://www.certmagic.com
Slide 10: ICDL-ACCESS QUESTION: 10 Save and close this table. Answer: Click on save tool from the table design toolbar -> close the table 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. 10 http://www.certmagic.com
Slide 11: ICDL-ACCESS Answer: In the indexed box -> choose yes (duplicates ok) QUESTION: 12 Specify that dates of birth in this table display in the format 12 November 2000. 11 http://www.certmagic.com
Slide 12: ICDL-ACCESS Answer: Put the insertion point in the Date of birth field -> in the format box -> select long date QUESTION: 13 Which one of the following statements about setting the field size property in a table is True? 12 http://www.certmagic.com
Slide 13: ICDL-ACCESS A. If you change the Stock Ref field size property to 15, existing data will not change B. If you decrease the Stock Ref field size, data will not be lost. C. You cannot change the Stock Ref field size because the table contains data. D. If you increase the field size for the Stock Ref field, the data will be processed faster. Answer: A 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. 13 http://www.certmagic.com
Slide 14: ICDL-ACCESS Answer: In the validation Rule box type >10 -> press enter from the keyboard QUESTION: 15 Each author has written a number of books. Set up a one-to-many relationship between the Book and Author tables. 14 http://www.certmagic.com
Slide 15: ICDL-ACCESS Answer: 15 http://www.certmagic.com
Slide 16: ICDL-ACCESS QUESTION: 16 The Payment table contains biling details for each patient. Edit the relationship between the Payment and Patient tables to prevent a patient who has made a payment from being deleted. 16 http://www.certmagic.com
Slide 17: ICDL-ACCESS Answer: Right click on the line between Patient table and Payment table -> select Edit Relationship .. -> check the Enforce Referential Integrity -> ok QUESTION: 17 Access the option that would enable you to create a new form without the help of a Wizard. 17 http://www.certmagic.com
Slide 18: ICDL-ACCESS Answer: Select forms from the objects pane -> double click on the create form in Design view QUESTION: 18 The book in record 5 is no longer available Delete this record from the database. 18 http://www.certmagic.com
Slide 19: ICDL-ACCESS Answer: Click on the Delete Record tool from the form view toolbar -> yes QUESTION: 19 Alter the header text to Patient details and press the Enter key when you have finished. 19 http://www.certmagic.com
Slide 20: ICDL-ACCESS Answer: Click on the Patient box and type details -> press enter from the keyboard QUESTION: 20 Use the search tools provided by Access to find the book with the unique (ISBN) code 3546-1236-7. 20 http://www.certmagic.com
Slide 21: ICDL-ACCESS Answer: Edit -> find -> type 3546-1236-7 in the find what box -> click find next button 21 http://www.certmagic.com

   
Time on Slide Time on Plick
Slides per Visit Slide Views Views by Location