ECDL Advanced Database Software (BCS ITQ L3), Access 2010
Sprache: | Englisch |
Office-Version: | MS Office 2010 |
Produktform: | Buch |
Hersteller | CiA Training |
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:
- Database concepts and developments
- SQL
- Creating a database
- Lookup fields
- Setting a mandatory field
- Input masks
- Performing various queries
- Query wizards
- Action queries
- Wildcards in queries
- Applying relationships
- Applying joins
- Referential integrity
- Forms and subforms
- Calculated fields
- Command buttons
- Combo boxes
- Other form controls
- Creating and printing reports
- Grouped reports
- Subreports
- Importing and linking data
- Creating and using macros
Sample Section: ECDL Advanced Database Software (BCS ITQ L3)