ECDL Advanced Database Software (BCS ITQ L3), Access 2010

Sprache: Englisch
Office-Version: MS Office 2010
Produktform: Buch
Hersteller CiA Training
Menge:
  CHF 26.00

Beschreibung

Approved by BCS and ICS Skills. This training guide has been written specifically for the ECDL unit Advanced Database Software (BCS ITQ level 3, syllabus 2.0). Each exercise has been designed to build upon and extend your knowledge of Microsoft Access using a simple, step-by-step approach. You will learn how to create and maintain multiple tables in a database, link them appropriately, and retrieve information using queries and complex reports. Data files to accompany this title allow you to practise the many different software features covered.

Contents

This product contains approximately 152 pages and covers the following topics:

  1. Database concepts and developments
  2. SQL
  3. Creating a database
  4. Lookup fields
  5. Setting a mandatory field
  6. Input masks
  7. Performing various queries
  8. Query wizards
  9. Action queries
  10. Wildcards in queries
  11. Applying relationships
  12. Applying joins
  13. Referential integrity
  14. Forms and subforms
  15. Calculated fields
  16. Command buttons
  17. Combo boxes
  18. Other form controls
  19. Creating and printing reports
  20. Grouped reports
  21. Subreports
  22. Importing and linking data
  23. Creating and using macros

Sample Section: ECDL Advanced Database Software (BCS ITQ L3)