1 / 8

ACCESS Certification Practice Test

CertsChief products pass your IT Certification Exam with 100% money back guaranteed. Using Confirmed test practice questions and preparation material from CertsChief. Please visit at: http://www.certschief.com

certschief3
Download Presentation

ACCESS Certification Practice Test

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. http://www.certschief.comCertification Preparation Material ICDL Access ICDL the Access exam Demo Product - For More Information - Visit: http://www.certschief.com/exam/Access/ Edition = DEMO ProductFull Version Features:  90 Days Free Updates  30 Days Money Back Guarantee  Instant Download Once Purchased  24/7 Online Chat Support Page | 1 http://www.certschief.com/exam/Access/

  2. http://www.certschief.comCertification Preparation Material 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 A. Select open an existing file -> select c:\windows\desktop\car hire -> ok -> type icoffey in the name box -> ken*72 in the password box Answer: A Question: 3 Create a new blank database. Page | 2 http://www.certschief.com/exam/Access/

  3. http://www.certschief.comCertification Preparation Material A. Click on the new tool from the database toolbar -> select database -> ok Answer: A Question: 4 Use Microsoft Access Help to find information about decimal numbers. Page | 3 http://www.certschief.com/exam/Access/

  4. http://www.certschief.comCertification Preparation Material A. Help -> Microsoft access help -> type decimal numbers -> search Answer: A Question: 5 Hide the Formatting (Form/Report) toolbar. A. View -> toolbars -> select formatting (form/Report) Answer: A Question: 6 Save the above table and give it the name Sals. Page | 4 http://www.certschief.com/exam/Access/

  5. http://www.certschief.comCertification Preparation Material A. Click on the save tool from the table design toolbar -> type Sales -> ok Answer: A 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. Page | 5 http://www.certschief.com/exam/Access/

  6. http://www.certschief.comCertification Preparation Material A. Type Contact Name -> press Tab from the keyboard Answer: A 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. Page | 6 http://www.certschief.com/exam/Access/

  7. http://www.certschief.comCertification Preparation Material A. Use the back space from the keyboard to delete Lamont -> type Dawson -> press Tab from the keyboard Answer: A Page | 7 http://www.certschief.com/exam/Access/

  8. http://www.certschief.comCertification Preparation Material Demo Product - For More Information - Visit: http://www.certschief.com/exam/Access/ 20% Discount Coupon Code: 20off2016 Page | 8 http://www.certschief.com/exam/Access/

More Related