OCR Level 3 ITQ - Unit 20 - Database Software Using Microsoft Access 2007
by
CiA Training Ltd
This training guide has been written specifically for the OCR Level 3 ITQ unit Database Software, which requires you to use a software application to create and edit a multi table relational database.
Top page
Complete description
This training guide has been written specifically for the OCR Level 3 ITQ unit Database Software, which requires you to use a software application to create and edit a multi table relational database. Each exercise in this guide has been designed to gradually build up your knowledge of Microsoft Access using a simple, user friendly, step-by-step approach. This optional level 3 unit has a credit value of 6, and requires you to demonstrate the skills and knowledge needed to create and maintain multiple tables in a database, link them appropriately and retrieve information using queries and reports. This guide provides you with the knowledge and techniques necessary to meet these learning outcomes. Data files to accompany this title are available to download from our website, which allow you to practise the many different software features covered.
Top page
Summary
OCR Level 3 ITQ - Unit 20 - Database Software Using Microsoft Access 2007
1. Relational Database Principles 2. Database Efficiency 3. Creating a Database 4. Data Types 5. Relationships 6. Referential Integrity 7. Entering Records 8. Field Properties 9. Lookup Fields 10. Creating & Using Forms 11. Data Errors and Problems 12. Creating & Using Selection Queries 13. Creating & Using Action Queries 14. Creating & Using Reports
Top page
“Knowledge has no limits” This site is owned by DEA Mediagroup SpA.
Tel. + 39 06 852121 Fax. + 39 06 8543228 Via Pietro Boccanelli 27 00138 Roma Italy
P.Iva 00901181008 Cod.Fiscale 00469620587
Send your comments or suggestions to:
customerservice@deastore.com
If you are experiencing problems using the system, please refer to the deastore Online Help Center or inform our Technical Support at:
helpdesk@deastore.com
Free Worldwide Shipment by Mail. Click here for details 
