Database Design and Programming with Access, SQL and Visual Basic - Softcover

Carter, John

Softcover

ISBN 10: 0077095855 ISBN 13: 9780077095857

Publisher: McGraw-Hill Inc.,US, 2000

Synopsis

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.

About this title

From the Author

This book will teach you database design, SQL, Access and VB
I wrote this book to answer numerous questions from my second year degree and HND students on how to implement their database applications in Access, and then how to produce workable input and update forms and reports using VB. I identified three problems: 1) incorrect database table and relationship design 2) insufficient knowledge of SQL - the main database language 3) too much reliance on Access wizards. So the three key themes in this book are entity modelling and normalisation to obtain the correct database design, SQL to perform core queries and updates on the database, and Visual Basic database programming in its three forms: data control, DAO and ADO. The feedback from my two previous database books led me to include lots and lots of examples of the things typical database applications will have to do. I have also tried to make the lecturer's life easier by including lots of exercises. If you want to contact me on my email address, please feel free to do so.

Edition details

• Publisher: McGraw-Hill Inc.,US
• Publication date: 2000
• Language: English
• ISBN 10: 0077095855
• ISBN 13: 9780077095857
• Binding: Paperback
• Number of pages: 450