ECDL Database Software (BCS ITQ L2), Access 2010

Beschreibung

Approved by BCS and ICS Skills. This training guide has been written specifically for the new ECDL unit Database Software (BCS ITQ level 2, syllabus 5.0). Each exercise has been designed to gradually build up your knowledge of Microsoft Access using a simple, step-by-step approach. You will learn how to create and maintain a database, retrieve information from it using queries, and produce simple reports. Data files to accompany this title allow you to practise the many different software features covered.

Contents

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

1. Understanding Database Principles
2. Using the Menus Toolbars and Task Pane
3. Help
4. Opening a Database
5. Closing Tables and Databases
6. Moving Around a Table
7. Planning and Creating a Database and Table
8. Defining Field Properties
9. Primary Key and Indexes
10. Creating Validation Rules
11. Previewing and Printing from Tables, Forms and Reports
12. Editing Data
13. Adding and Deleting Records
14. Sorting and Filtering Data
15. Creating Editing and Deleting Queries
16. Saving and Printing Queries
17. Creating Forms
18. Sorting and Editing Form Data
19. Database
20. Administration

Sample Section: ECDL Database Software (BCS ITQ L2)