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 2017 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 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. This training can be gained from our LEARN VISUAL BASIC ​2019 course.

VISUAL BASIC AND DATABASES requires the Microsoft Windows operating system and Visual Studio 2019 Community or Professional Edition. We also use the free Microsoft SQL Express 2017 Edition for database management. 

TEACHER CLASSROOM LICENSE BUNDLE

This tutorial is available in a PDF and Word E-Book format. The entire E-Book and/or selected chapters can be printed on your local printer and/or viewed on your computer screen. The E-Books can be downloaded from our website immediately after purchase .  We compress all these files using a .zip format to help reduce the size for faster downloading.

This E-Book Tutorial textbook in an Annual Unlimited User Classroom License Teacher Edition. Our Teacher Edition allows you to distribute the tutorial and source code to any of the students who attend your computer science class.  You can customize and personalize the tutorial and the associated source code to fit your unique teaching style whether the class is self study or instructor led. Since this Tutorial is distributed in an editable Microsoft Word format you can add your own teaching text and/or notes around our teaching text.  You can add your own diagrams and/or personalize the E-Book tutorial to fit your specific teaching needs.  Unlike other Tutorials that are only Paper or PDF based, you can modify our teaching narrative and source code inside the tutorial and reprint as needed.  This unique flexibility sets us apart from all other tutorials on the market. 

We also sell special large scale multi-teacher site license agreements for School Districts and Online Schools. Please contact us directly if you are interested in a large scale license agreement via the Contact Us button below. These special large scale licenses are not sold via this web page.

________________________________________________

VISUAL BASIC AND DATABASES TEXTBOOK REVIEW BY DAVID B. TAYLOR, FORMER PROFESSOR & DEPARTMENT CHAIR:



“Most computer programs in use today require some interaction with information stored in a database so learning to program with databases increases the marketability of a developer exponentially.

This book is structured as a self-study guide but it is easily adapted to classroom lectures and discussion. The content of the book is excellent. It starts with the basics and graduates in small and clear but functional increments. It makes database programming much easier to teach and learn.

“Visual Basic and Databases” provides a complete, thorough, and easy to understand explanation of database program development from two people who came up through the ranks as software developers. Their examples reflect real-world applications that will help new developers quickly master database software development. Students can easily convert and expand the examples for their own applications. For example, the Books Database in Chapter 4 could easily be modified to search a similar database of cars, bikes, or passwords, etc.

Examples are created using Microsoft’s Access database management system (DBMS) and SQL Server. This makes it easy for the student to compare their capabilities and syntax.

I have sincerely enjoyed reading and working through the examples in, “Visual Basic and Databases”. The examples are clear and easy to follow. If I had any questions or if my code did not work I could simply peek at the authors’ completed code examples to get back on track.

Throughout the book the authors bring attention to the importance of user interface (UI) design. This is more important than may be obvious at first but developers tend to focus on the code and forget about the UI but eventually someone needs to use this program so a functional and attractive presentation of the program can be the difference between success and failure of the end product.

A major plus for this text is how the authors include additional and very useful parallel topics such as the On-Line Help system created in HTML in Chapter 5 and the Graphics Methods in Chapter 7. The book is not about HTML or graphics but the coincidental inclusion give the student a valuable glimpse at other topics of importance. These are just two examples that didn’t have to be included but they are added as part of other chapters and will ultimately benefit the student. This took a lot of forethought by the authors and demonstrates the real value of the book.

As a programmer, a long-time college professor, and as the former head of the Computer, Engineering, and Business Department, I have reviewed countless programming books for most of the popular programming languages. “Visual Basic and Databases” by Conrod and Tylee is my favorite text for helping developers make the leap into the rewarding field of database development. I highly recommend this book for anyone who is serious about becoming a professional software developer/engineer. “ – David B. Taylor, B.S.E.T., M.A.Ed., Ed.S., Former Professor and Department Chair Computer, Engineering, and Business Seminole State College Sanford, Florida

________________________________________________

WHAT OTHERS HAVE BEEN SAYING ABOUT OUR VISUAL BASIC & DATABASES TESTBOOKS AND TUTORIALS:​​

“I just want to thank you for the many tutorials that I have ordered from your company over the past decade. Your tutorials have been instrumental in allowing me, a secondary school teacher in Ontario, to learn what I need to know in order to conduct my own High School Computer Science Classes in Visual Basic and Visual C#.  I thank you, and urge you to keep up the excellent work. It has been instrumental in helping me learn and grow as a teacher.” - Alan Payne, TA, Blakelock High School, Oakville, ON

“Visual Basic and Databases was well organized and the various projects that I had to create in order to learn the material was exhaustive and intensive (which is good!). The course was fun, entertaining and rewarding.” - Ray Torres, Developer, Miami, FL

“The Visual Basic & Databases Tutorial was the best tutorial and samples I found to use Visual Basic” - Lester Torres Rivera, Teacher, Puerto Rico, USA

“I really enjoyed the Visual Basic & Databases tutorial, the database connection examples really helped me.” - Bruce Chin, Amateur Developer, Toronto, Ontario

“​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.  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

“I have to congratulate you on your excellent and very professionally written tutorial [VISUAL BASIC AND DATABASES]. It is very clear, concise and to the point. Well done – it is money well spent.” - TM, Brisbane, Australia.

“Your notes have helped me tremendously in figuring out Visual Basic 2005. I was able to find a lot of the information that I wasn’t able to find elsewhere. I had spent hours searching for information, trying something out, cussing when it didn’t work, and then repeating the cycle. That alone was worth the price of the course.” - TS, Bloomington, Illinois

“Working with my daughter, she is having fun grasping this stuff. Your documents are written in plain speak and are straightforward. She is an accelerated reader and I have been translating the technical stuff. Kids are sponges.” - PT, Orland Park, Illinois

“There are many tutorials on the internet, but those by KidwareSoftware.com are easy to follow. There is no confusing technobabble, but clear explanations. These are high quality and you come away with new skills and better understanding.” - RM, Espanola, New Mexico

“I really love these courses. They keep me going when I’m housebound.” - CO, London, England

“I want to commend you on the quality of these materials. I have recommended the course to several of my friends.” - SM, Reno, Nevada

“I have both your VB6 and VB6 database courses and they have both been excellent tools for learning.” - GO, Otaki, New Zealand

“I thought your VISUAL BASIC AND DATABASES was great. I’ve learned more from your book than my college text book. Clear, concise and it works!” - MC, Tampa, Florida

“After buying over 15 books, I think this is probably the best. It is a fabulous product, and I have referred back to it even after studying the “deeper” texts I’ve purchased.” - JM, Oradell, New Jersey

“I wish to thank you for providing a straight forward guide to what can be a complex subject.” - IS, Somersby, Australia

“I really appreciate your wonderful resource . You are a fantastic company.” - DW, Albany, New York

“I love this course. The way you go about teaching is great.” - RW, Prescott Valley, Arizona

“Your notes and lessons are more meaningful than the professional looking books by Microsoft experts.” - BT, Gladstone, Missouri

“I am writing to inform you that not only was the tutorial most satisfactory, but helped me finish my project at work.” - SJ, Tamworth, United Kingdom

“May I thank you for your great work in this course. I am enjoying reading it.” - ML, Cairo, Egypt.

“Your tutorial VISUAL BASIC AND DATABASES is quite good. It’s to the point and the no-nonsense explanations are a breath of fresh air. Thank you! ” - KM, Connellsville, Pennsylvania

“I have learned more in the last 5 days from your tutorial than reading other books for a month. It is well-written and easy to follow. ” - WZ, Toronto, Ontario, Canada.

“I am pleased to find a product that does not have errors in it like other books I have used. You should publish it as a book.” - JR, Oamaru, New Zealand

“After having purchased several volumes of training materials, I downloaded your VISUAL BASIC AND DATABASES and have learned more than from all the others, at a fraction of the cost. ” - DG, Morris, Oklahoma

“VISUAL BASIC AND DATABASES is very clear and the style is learner-centered. It is very kind to the reader.” - JM, Roxas City, Philipines

“The most intelligently written training [VISUAL BASIC AND DATABASES] I’ve seen. Concise with an element of common sense.” - JR, La Grange Park, Illinois

“VISUAL BASIC AND DATABASES is exactly what I was looking for and provided me with a thorough grounding in database applications.” - AR, New York, New York

“This [VISUAL BASIC AND DATABASES] is an excellent tutorial on the subject of databases, probably the best.” - WB, Midland, Texas

“I learned more in two hours with VISUAL BASIC AND DATABASES than with any of the several hundreds of dollars worth of books I have purchased. ” - TB, Southaven, Mississippi

“I was impressed by the clarity, simplicity and fluency with which you are able to approach so delicate topic [VISUAL BASIC AND DATABASES]. ” - OB, Havana, Cuba

“VISUAL BASIC AND DATABASES is more thorough and understandable than the other books. We will use this as a part of our curriculum. ” - DT, Newtown, Connecticut

“Your book VISUAL BASIC AND DATABASES is great! ”

VV, Buenos Aires, Argentina

“Many thanks for your VISUAL BASIC AND DATABASES. I love it! ” - SK, Melbourne, Australia

“I’ve begun VISUAL BASIC AND DATABASES and just want to say – Nice Job! ” - DR, Kenosha, Wisconsin

“Excellent work [VISUAL BASIC AND DATABASES]! Your presentation is one of the best I have seen. I loved reading your tutorial. ” - RV, Brussels, Belgium.

“VISUAL BASIC AND DATABASES is very good!” - MG, London, England.

“At last – someone has explained database management in understandable terms. Thanks for a great piece of work!” - GS, Seattle, Washington.

“There are many tutorials on the internet, but those by KidwareSoftware.com are easy to follow. There is no confusing technobabble, but clear explanations. These are high quality and you come away with new skills and better understanding.” - RM, Espanola, New Mexico.

“I really love these courses. They keep me going when I’m housebound.” - CO, London, England.

“I want to commend you on the quality of these materials. I have recommended the course to several of my friends.” - SM, Reno, Nevada.

“I have both your VB6 and VB6 database courses and they have both been excellent tools for learning.” - GO, Otaki, New Zealand.

“I thought your VISUAL BASIC AND DATABASES was great. I’ve learned more from your book than my college text book. Clear, concise and it works!” - MC, Tampa, Florida.

“After buying over 15 books, I think this is probably the best. It is a fabulous product, and I have referred back to it even after studying the “deeper” texts I’ve purchased.” - JM, Oradell, New Jersey.

“I wish to thank you for providing a straight forward guide to what can be a complex subject.” - IS, Somersby, Australia

“I really appreciate your wonderful resource. You are a fantastic company.” - DW, Albany, New York.

“I love this course. The way you go about teaching is great.” - RW, Prescott Valley, Arizona.

“Your notes and lessons are more meaningful than the professional looking books by Microsoft experts.” - BT, Gladstone, Missouri.

“I am writing to inform you that not only was the tutorial most satisfactory, but helped me finish my project at work.” - SJ, Tamworth, United Kingdom

“May I thank you for your great work in this course. I am enjoying reading it.” - ML, Cairo, Egypt.

“Your tutorial VISUAL BASIC AND DATABASES is quite good. It’s to the point and the no-nonsense explanations are a breath of fresh air. Thank you! ” - KM, Connellsville, Pennsylvania.

“I have learned more in the last 5 days from your tutorial than reading other books for a month. It is well-written and easy to follow. ” - WZ, Toronto, Ontario, Canada.

“I am pleased to find a product that does not have errors in it like other books I have used. You should publish it as a book. ” - JR, Oamaru, New Zealand

“After having purchased several volumes of training materials, I downloaded your VISUAL BASIC AND DATABASES and have learned more than from all the others, at a fraction of the cost. ” - DG, Morris, Oklahoma.

“VISUAL BASIC AND DATABASES is very clear and the style is learner-centered. It is very kind to the reader.” - JM, Roxas City, Phiippines

“The most intelligently written training I’ve seen. Concise with an element of common sense.” - JR, La Grange Park, Illinois.

“VISUAL BASIC AND DATABASES is exactly what I was looking for and provided me with a thorough grounding in database applications.” - AR, New York, New York.

“This is an excellent tutorial on the subject of databases, probably the best.” - WB, Midland, Texas.

“I learned more in two hours with VISUAL BASIC AND DATABASES than with any of the several hundreds of dollars worth of books I have purchased. ” - TB, Southaven, Mississippi

“I was impressed by the clarity, simplicity and fluency with which you are able to approach so delicate topic. ” - OB, Havana, Cuba.

“VISUAL BASIC AND DATABASES is more thorough and understandable than the other books. We will use this as a part of our curriculum. ” - DT, Newtown, Connecticut

“Your book VISUAL BASIC AND DATABASES is great! ” - VV, Buenos Aires, Argentina.

“Many thanks for your VISUAL BASIC AND DATABASES. I love it! ” - SK, Melbourne, Australia.

“I’ve begun VISUAL BASIC AND DATABASES and just want to say – Nice Job! ” - DR, Kenosha, Wisconsin

“Excellent work! Your presentation is one of the best I have seen. I loved reading your tutorial. ” - RV, Brussels, Belgium.

“VISUAL BASIC AND DATABASES is very good!” - MG, London, England.

“At last – someone has explained database management in understandable terms. Thanks for a great piece of work!” - GS, Seattle, Washington