My Account
Log in Registration
All
Cart
Highlights
Fiction Books
Non-Fiction Books
Children's Books
Rare Books
Music
DVD & Blu-Ray
Video Games
Category
Wishlists
Cart
All
Free Shipping in Australia
Trustpilot
Proud to be B-Corp

Database Design and Programming with Access, SQL and Visual Basic John Carter

Database Design and Programming with Access, SQL and Visual Basic By John Carter

Database Design and Programming with Access, SQL and Visual Basic by John Carter

Reviews:
$36.99
Condition - Very Good
Only 2 left
Very GoodGood

Summary

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.

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

Database Design and Programming with Access, SQL and Visual Basic by John Carter

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.

Table of Contents

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).

Additional information

GOR001530770
9780077095857
0077095855
Database Design and Programming with Access, SQL and Visual Basic by John Carter
John Carter
Used - Very Good
Paperback
McGraw-Hill Education - Europe
2000-03-31
450
N/A
Book picture is for illustrative purposes only, actual binding, cover or edition may vary.
This is a used book - there is no escaping the fact it has been read by someone else and it will show signs of wear and previous use. Overall we expect it to be in very good condition, but if you are not entirely satisfied please get in touch with us

Customer Reviews - Database Design and Programming with Access, SQL and Visual Basic