City & Guilds Level 3 ITQ - Unit 319 - Database Software Using Microsoft Access 2010

CiA Training Ltd. (Autor)

Buch | Spiralbindung

122 Seiten

2012
CiA Training Ltd (Verlag)
978-0-85741-033-7 (ISBN)

Infos

This training guide has been written specifically for the City & Guilds ITQ (IT Users) level 3 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 unit 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.

Inhalt

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

Produkt-Details

• Erscheint lt. Verlag: 31.7.2012
• Verlagsort: Sunderland
• Sprache: englisch
• Maße: 210 x 300 mm
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Informatik ► Office Programme ► Access
• ISBN-10: 0-85741-033-4 / 0857410334
• ISBN-13: 978-0-85741-033-7 / 9780857410337
• Zustand: Neuware