OCR Level 3 ITQ - Unit 20 - Database Software Using Microsoft Access 2016

Buch | Spiralbindung

2016
CiA Training Ltd (Verlag)
978-0-85741-215-7 (ISBN)

Infos

This training guide has been written specifically for the OCR ITQ (IT User Skills) level 3 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.

Inhalt

Relational Database Principles; Database Efficiency; Creating a Database; Data Types; Relationships; Referential Integrity; Entering Records; Field Properties; Lookup Fields; Creating & Using Forms; Data Errors and Problems; Creating & Using Selection Queries; Creating & Using Action Queries; Creating & Using Reports;

Produkt-Details

• Erscheinungsdatum: 08.07.2016
• Verlagsort: Sunderland
• Sprache: englisch
• Maße: 210 x 300 mm
• Themenwelt: Mathematik / Informatik ► Informatik ► Datenbanken
• Themenwelt: Informatik ► Office Programme ► Access
• Themenwelt: Informatik ► Weitere Themen ► Zertifizierung
• ISBN-10: 0-85741-215-9 / 0857412159
• ISBN-13: 978-0-85741-215-7 / 9780857412157
• Zustand: Neuware