Item description for Learn to Program Visual Basic Databases (Learn to Program) by John Smiley...
In "Learn to Program Visual Basic Databases," John Smiley provides a solid foundation for the beginning or intermediate user interested in working with database theory and uses this knowledge to create a fully database-enabled Visual Basic application. Smiley's simple, conversational style is entertaining even when he is explaining the most difficult programming principles. The book is classroom-based, and his question and answer format often addresses commonly-asked student queries. Smiley also provides step-by-step instructions for each exercise and handy online references for more information.
Outline Review Well-known computer author John Smiley has written Learn to Program Databases with Visual Basic 6, which features a very friendly approach to learning the basics of database programming with Visual Basic. Aimed at the novice Visual Basic programmer, this patient tutorial may be just what you've been waiting for to help you master databases within VB.
The most distinctive feature here is the format of this book, which features Q&A dialogues between the hypothetical students and the author as he works through the basics of database design with VB6. With an exceedingly patient presentation style, this approach will work best for the novice VB programmer. The book starts from square one, with the fundamentals of databases, before it proceeds to VB's database components, such as the Data Control. The book makes use of a single case study for a product catalog for a dishware shop. Readers will learn how to add tables using Microsoft Access and then build forms that access data within Visual Basic.
Besides the fundamentals, the author does mention key Visual Basic technologies, such as an ADO primer on the syntax of SQL for querying databases. The goal of this book isn't so much a comprehensive tour as much as a how-to for demystifying databases within Visual Basic.
In all, this book's format makes it an ideal choice for the novice programmer who's had trouble making the leap into the world of database development. Learn to Program Databases with Visual Basic 6 can put the powers of a VB database into the hands of virtually any reader who's willing to spend a few hours reading and working through its effective code examples. --Richard Dragan
Topics covered: Visual Basic database tutorial, database basics, tables, records, fields, field types, primary and foreign keys, referential integrity, using Microsoft Access, the Visual Basic Data Control ( properties and methods), ActiveX Data Objects (ADOs), Recordsets (properties and methods, record navigation, and updating records), queries, SQL basics, updating records, the DBGrid control, and form design.
Promise Angels is dedicated to bringing you great books at great prices. Whether you read for entertainment, to learn, or for literacy - you will find what you want at promiseangels.com!
Est. Packaging Dimensions: Length: 9.02" Width: 7.8" Height: 1.35" Weight: 2.66 lbs.
Release Date Jan 1, 2001
Publisher Course Technology PTR
ISBN 1929685173 ISBN13 9781929685172 UPC 752187429913
Availability 0 units.
More About John Smiley
John Smiley has been programming and teaching for over 20 years. He is the president of John Smiley and Associates, a computer consulting firm which serves clients in the Philadelphia Metropolitan area. He teaches computer science at Penn State University, the Philadelphia College of Textiles and Science, Holy Family College, and he currently teaches popular online courses on SmartPlanet.
John Smiley currently resides in Philadelphia, in the state of Pennsylvania.
Reviews - What do customers think about Learn to Program Visual Basic Databases (Learn to Program)?
A great update of off and on learning May 19, 2005
I took an online class with John Smiley several years ago using the Beginning Programming with VB 6.0. I then took a live course using VB.net with XML along with others who have been programming for some time, and could almost keep up with them. It would have been better if I'd gotten through all the Smiley books first.
I tried doing this book on my own a couple of years ago, but got bogged down. However I sent him an email with my problems, which he replied to immediately, remembering me from the class. He suggested a work around, so when I took up the book this time I could work through all the exercises. This was a great review of VB and databases, and now I am really understanding connectivity, which I hope to use with websites some day.
Don't use this book as a starter. It continues where the Introductory book leaves off. I noticed that someone complained that it wasn't introductory enough. They just didn't start the right place.
Next step will be to try his Java book.
I would hope that John Smiley would revise these books for .net and newer versions of Access, as they are very worthwhile beginner books!
Different from What the Other Books I have Read Mar 31, 2005
Unlike any other books, this book is presented in a manner where readers would feel as though the he / she is sitting in a class lecture room and listening to Professor Smiley's lecture.
The reader / prospective reader i.e. YOU will be in class with Valerie, Peter, Kate, Rhonda, Kevin, Tom, Melissa, Rachel, Steve, Kathy, Dave, Ward, Blaine, Linda, Mary, Chuck, Lou and Bob. (If your name is not in the roll, perhaps Professor Smiley missed you out! :) )
Readers will be presented with the China Shop Project Database Project. Professor Smiley starts off with simple problems and ascends to more not-so-simple problems.
While reading the exercises, sufficient Windows diagrams are presented and it is as if you were doing a hands-on on Visual Basic Database.
I personally feel that readers should have some knowledge on Visual Basic before attempting this book.
Learn to Program Visual Basic Databases Feb 2, 2005
John Smiley's book is supposed to be an introductory level book for novice level programmers. At the time it was written, I'm sure it was. However, the book is written around Access 97 and a lot has changed since then. The code simply will not work without patches, work arounds and lots of digging. It takes far more than a novice programmer to figure this one out. It defeats the purpose. If you don't like frustration, find a more recent book..
Excellent Book Jan 31, 2005
If ever you need a book to take you step by step into database programming, this is it. Professor Smiley takes his students slowly and very carefully into the subject of Database programming. This book is focused on depth rather than covers a whole bunch of topics and at the end you learn all of none. I particularly like the classroom setting. You really feel an environment of learning and- who knows? You may even make a few new friends. This book is so well explainde, that you do not need to read over and over to make sense of what he is explaining. I must complement him for writing a really great book. If you have not yet already gotten copies of his other titles. I think you should do so, He makes learning fun.
Personal service, immediate response May 12, 2004
I don't usually write reviews of books but this book is exceptional. I consider myself a near expert with Microsoft Office VBA but struggled with Visual Basic (the application). The unusual classroom setting of this book made me feel as if I were in the classroom with John Smiley teaching. I was finally being taught by someone who knew how to teach. In chapter 4 I finally ran into a problem I couldn't figure out. John Smiley was gracious enough to post his email address in the front of the book so, at half past midnight I sent him a note discussing my problem. I recieved a response from John at 8:30 that morning. John knew exactly what my problem was and gave me instructions on how to fix it. Once applied, my project worked perfectly. I can't express enough how much I appreciate this kind of customer service. Thanks, John.