Visual Basic and Databases - Professional Edition
Product ID: 9570683
VISUAL BASIC AND DATABASES is a tutorial that provides a detailed introduction to using Visual Basic for accessing and maintaining databases for desktop applications. Topics covered include: database structure, database design, Visual Basic project building, ADO .NET data objects (connection, data adapter, command, data table), data bound controls, proper interface design, structured query language (SQL), creating databases using Access, SQL Server and ADOX, and database reports. Actual projects developed include a books tracking system, a sales invoicing program, a home inventory system and a daily weather monitor. VISUAL BASIC AND DATABASES is presented using a combination of over 850 pages of color self-study notes and actual Visual Basic examples. No previous experience working with databases is presumed. It is assumed, however, that users of the product are familiar with the Visual Basic environment and the steps involved in building a Visual Basic application (such training can be gained from our LEARN VISUAL BASIC course). VISUAL BASIC AND DATABASES requires a Microsoft Windows 7 or the Windows 8 operating system and Microsoft Visual Basic Professional 2012. The Visual Basic source code, databases and all needed multimedia files are available for download from the publisher's website (KidwareSoftware.com) after you register this book. Review: Buy this book from the author's site, not desertcart. - Do not purchase this book from desertcart.com. The purchase on desertcart only includes the printed version of the text. If you purchase it from the author’s website, you get the printed version and the e-book for the same price or the e-book alone at a reduced price. You will need the e-book of this text because it has no index. Searching this text without the e-book is difficult, unproductive, and time consuming. The book’s size is increased substantially by providing examples for both SQL Server and Access databases. The title of the book states that this is the Professional Edition. From a professional perspective, very few database projects include Access for essential business database applications and there is little to be gained by including Access. Professional developers will either use Oracle or SQL Server but if you’re programming in VB or C# you are most likely interested in SQL Server. The content of the book is very good. It starts with the basics and graduates in small and clear but functional increments. It makes database programming much easier to teach and learn. I have also purchase Mr. Conrod's, "Learn Visual Basic - Professional Edition". It too is an excellent book. The author is also very responsive. He has responded to questions within a couple of hours. I am recommending Mr. Conrod's VB and C# books to our faculty for consideration in our computer science curriculum. They are much better and far less expensive than our current books. Review: Best book I ever bought on the subject! - As someone who has always struggled trying to use Visual Basic with databases - this book is my savior! I LOVE the fact that it gives COMPLETE code examples for both Access and Sequel Server. I am also trying to learn how to build good databases and am currently using Access 2013 as my tool, so the Access examples are a huge plus for me. I did hit one small snag though. I am saving my Access databases in ".accdb" format. This required 2 small steps to use this file format: Downloading the small Access database engine, and using "Microsoft.ACE.OLEDB.12.0" as the Provider in the connection string. That info is not given in the section on connection strings. However, the correct info is given to use the .mdb file format. Visual Studio Data Wizard? Never again! The book gives you a quick walk through using the wizard but doesn't use it in the book. You will never learn how to program with databases, strictly relying on the wizard to do the work for you. This is where I went completely wrong - looking for the easy way. Fortunately, the authors explain everything you need to know to do the coding yourself - and everything is explained at a level that is extremely easy to understand. Queries, reporting, database management, design, distribution, and more - it's ALL there! So, as a beginner programmer who could never grasp the fundamentals to actually writing the code for database programming, I can honestly say that, for me, this book was worth every penny! Paul
| Best Sellers Rank | #9,210,443 in Books ( See Top 100 in Books ) #641 in Visual Basic Programming (Books) #751 in Desktop Database Books #7,886 in Database Storage & Design |
| Customer Reviews | 5.0 out of 5 stars 3 Reviews |
V**R
Buy this book from the author's site, not Amazon.
Do not purchase this book from amazon.com. The purchase on Amazon only includes the printed version of the text. If you purchase it from the author’s website, you get the printed version and the e-book for the same price or the e-book alone at a reduced price. You will need the e-book of this text because it has no index. Searching this text without the e-book is difficult, unproductive, and time consuming. The book’s size is increased substantially by providing examples for both SQL Server and Access databases. The title of the book states that this is the Professional Edition. From a professional perspective, very few database projects include Access for essential business database applications and there is little to be gained by including Access. Professional developers will either use Oracle or SQL Server but if you’re programming in VB or C# you are most likely interested in SQL Server. The content of the book is very good. It starts with the basics and graduates in small and clear but functional increments. It makes database programming much easier to teach and learn. I have also purchase Mr. Conrod's, "Learn Visual Basic - Professional Edition". It too is an excellent book. The author is also very responsive. He has responded to questions within a couple of hours. I am recommending Mr. Conrod's VB and C# books to our faculty for consideration in our computer science curriculum. They are much better and far less expensive than our current books.
P**L
Best book I ever bought on the subject!
As someone who has always struggled trying to use Visual Basic with databases - this book is my savior! I LOVE the fact that it gives COMPLETE code examples for both Access and Sequel Server. I am also trying to learn how to build good databases and am currently using Access 2013 as my tool, so the Access examples are a huge plus for me. I did hit one small snag though. I am saving my Access databases in ".accdb" format. This required 2 small steps to use this file format: Downloading the small Access database engine, and using "Microsoft.ACE.OLEDB.12.0" as the Provider in the connection string. That info is not given in the section on connection strings. However, the correct info is given to use the .mdb file format. Visual Studio Data Wizard? Never again! The book gives you a quick walk through using the wizard but doesn't use it in the book. You will never learn how to program with databases, strictly relying on the wizard to do the work for you. This is where I went completely wrong - looking for the easy way. Fortunately, the authors explain everything you need to know to do the coding yourself - and everything is explained at a level that is extremely easy to understand. Queries, reporting, database management, design, distribution, and more - it's ALL there! So, as a beginner programmer who could never grasp the fundamentals to actually writing the code for database programming, I can honestly say that, for me, this book was worth every penny! Paul
G**E
Five Stars
Great purchase experience! Item was exactly what I was expecting.
Trustpilot
1 month ago
4 days ago