Database Design and Programming with Access, SQL and Visual Basic

John Carter (Autor)

Buch | Softcover

450 Seiten

2000 | UK ed
McGraw-Hill Inc.,US (Verlag)
978-0-07-709585-7 (ISBN)

Titel erscheint in neuer Auflage

Artikel merken

Zu diesem Artikel existiert eine Nachauflage

Database Design and Programming with Access, SQL, Visual Basic and ASP

John Carter

2002

Buch | Softcover

CHF 79, ⁹⁵

zur Neuauflage

This work provides an introduction to all aspects of the database process, from analysis and design to programming. It enables the reader to learn how to ascertain system requirements, to design Access relational databases, SQL queries and to produce Visual Basic and associated applications. This work makes the important link between VB programs, databases and database programming. It includes many examples and exercises with solutions to reinforce learning.

Part 1 Introduction: how to develop a database application - what this book contains problem analysis; database design; query design; database programming; Visual Basic and Access; versions of Visual Basic and Access; compatibility between versions of Visual Basic and Access; exercises. Part 2 Problem analysis: the system life cycle; defining objectives; feasibility; analysis; dataflow diagramming; context diagrams; dataflow diagrams; sources and slinks of data; dataflow lines; processes; data stores; process specification; structured English and pseudo-code; business rules; decision tables and rule verification; exercises. Part 3 Database design: introduction; link to dataflow diagramming; entity modelling; entity types and relationships; replacing M - N; relationships with new entity types; replacing relationships involving more than two entity types with a new entity type; parallel relationships; mutually exclusive relationships; unnecessary relationships; relational modelling; selecting an initial set of attributes; terminology; primary keys; foreign keys; normalisation; first normal form; second normal form; third normal form; fourth normal form; fifth normal form; exercises. Part 4 Database schema design in Access: introduction; organising an application; the facilities of Access; creating a database; creating tables; in-built field; integrity checks; keys and indexing; creating relationships; referential integrity; join type; exercises. Part 5 Query design in Access: query by example - the query design Window; SQL with examples; single table queries; joins; subqueries; union queries; exercises. Part 6 Forms and reports in Access: Access form design; form Wizards; custom form design; Access report design; report Wizards; custom form design; Access report design; report Wizards; macros; modules; strengths and weakness of Access for process design; exercises. (Part contents).

Zusatzinfo	illustrations
Verlagsort	New York
Sprache	englisch
Gewicht	1072 g
Themenwelt	Mathematik / Informatik ► Informatik ► Datenbanken
	Informatik ► Office Programme ► Access
	Mathematik / Informatik ► Informatik ► Programmiersprachen / -werkzeuge
	Mathematik / Informatik ► Informatik ► Software Entwicklung
ISBN-10	0-07-709585-5 / 0077095855
ISBN-13	978-0-07-709585-7 / 9780077095857
Zustand	Neuware