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.
"synopsis" may belong to another edition of this title.
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.
"About this title" may belong to another edition of this title.
Book Description McGraw-Hill Inc.,US, 2000. Paperback. Book Condition: New. book. Bookseller Inventory # 0077095855