Develop An Inventory Management Application Using Visual Basic

book cover image title - Develop an Inventory Management Application using Visual Basic

ISBN: 81-901331-2-8
Weight: 1.6 Pounds
Pages: 362


The objective of this book is to teach the secrets of developing an inventory management application. The techniques of developing an inventory management application using Microsoft's Visual Basic are taught using Object oriented approach. The inventory domain is the next important domain to the accounting domain.

major topics covered

This book is a natural successor to the title "Develop an Accounting Software". In this book, you will learn how to develop a single class to implement all the transactions which occur in a trading firm.


Chapter 1: Materials Management

  1. Introduction
  2. Working of a Trading firm
  3. An Introduction to Accounting
  4. Important Accounts in a Trading firm
  5. Important Groups in a Trading firm
  6. Chart of Accounts for a Trading firm
  7. Double Entry System
  8. Analysis of Transactions
  9. Financial and Stock Statements for a Trading firm

Chapter 2: OOPs in Visual Basic

  1. Introduction
  2. ADO (ActiveX Data Objects)
  3. Object Oriented Programming
  4. Basic Elements of an Object Oriented System
  5. OOPs features in Visual Basic
  6. Class
  7. Creating a Class in Visual Basic
  8. Class header
  9. Class attributes
  10. Creating the services or methods
  11. Class events
  12. Creating and Using an Instance of a Class
  13. Declare the object variable
  14. Create the object
  15. Setting or getting objects properties
  16. Calling object methods
  17. Release the reference to the object
  18. Object Browser

Chapter 3: Developing the Application - I, Framework

  1. Introduction
  2. Creating a Project
  3. Menu Design
  4. Standard Modules
  5. BasicModule.bas
  6. GroupDef.bas
  7. GroupFun.bas
  8. InvFun.bas

Chapter 4: Developing the Application II, Masters

  1. Introduction
  2. Visual Data Manager
  3. Groups
  4. Groups Theory
  5. Developing the Group Class
  6. Class Header
  7. Class Atrributes or Properties
  8. Property Procredures
  9. Class Initialize event
  10. Services
  11. Class Terminate Event
  12. Programming the Group Form
  13. Connecting the Group Form to the Menu
  14. Using the Group Form
  15. Relationship between Group Form
  16. Group Class and Group Table


  1. Introduction
  2. Designing and Programming the Dialog Form
  3. Declaration Section
  4. Loading the Dialog Form
  5. Opeing the Accounts Form from the Dialog
  6. Designing and Programming the Accounts Form
  7. Declaration Section
  8. Form Load Event
  9. Form Activate
  10. Initializing the Screen Vriables
  11. Programming the New Button
  12. Saving the Account details
  13. Check for Duplication of Account
  14. Programming the Delete Button
  15. Programming the Edit Button
  16. Programming the List Box
  17. Checking for Validation of Opening Balance
  18. Programming the Cancel Button
  19. Programming the Close Button
  20. Getting Group reference from the Group table
  21. Displaying Account Details
  22. Connecting the Form to the Menu and Using the Option


  1. Designing the Unit Form
  2. Programming the Unit Form
  3. Connecting the Form to the Menu, Using the Unit Form


  1. Developing the Item Class
  2. Designing and Programming the Item Form
  3. Connecting the Form to the Menu
  4. Using the Item Form
  5. Relationship between Item Form, Item Class and Item Table

Chapter 5: Developing The Application III, Transactions

  1. Developing the Trade Class
  2. Class Header
  3. Declaration Section
  4. Class Attributes / Properties
  5. Property Procedures
  6. Class Initialize event, Services

Designing and Programming the Master Form.
  • Form Header
  • Declaration Section
  • Form_Load Method
  • Setup Method
  • Append Mode
  • EnableMultiple
  • Programming the Buttons

Programming the Transactions
  • Purchase Invoice
  • Sales Invoice
  • Purchase Returns
  • Sales Returns
  • Cash Purchase Invoice
  • Cash Sales Invoice

Chapter 6: Developing The Application - IV, Reports

  1. Microsoft Data Report
  2. Daybook
  3. Registers
  4. General Ledger
  5. Trial Balance
  6. Stock Ledger
  7. Income Statement

These steps are common to all the reports
  • Design the Report
  • Write the Code for the reports
  • Declaration Section
  • Program the Main Function
  • Program the Miscellenous Functions for the Report
  • Connect the Report to the Menu

Technical Perspective

This book adopts an object oriented approach to developing an inventory management application. The reports and transactions dealt with in this book are unique to an inventory software. You can easily port this application to a Client/Server environment with the help of the title Develop An Accounting Package Using Visual Basic.

Questions you will easily answer after reading.
  1. Explain what is ADO ?
  2. What are recordsets ? How many types of recordsets are present ?
  3. Explain how to navigate a recordset ?
  4. What are the elements of an object oriented system ?
  5. What are the OOPs features in Visual Basic ?
  6. What is a class and draw the diagram of a class template ?
  7. What is an object ?
  8. What is a service? What are the types of services ?
  9. How do we create a class in Visual Basic ?
  10. List the steps to create an instance of a class.
  11. What is an object browser ? Explain it's features ?
  12. Which statement is used to create an object based on a class ?
  13. How do we use a class in the program ?
  14. How do we create a method for a class ?
  15. Which property procedure is used to retrieve the value of a property ?
  16. What are the three property procedures that can be created for a class ?
  17. If we do not specify the cursor type ADO uses which of the following as a default.
  18. adUseNone, adUseBatch, adUseServer, adUseClient.
  19. Which of the following cursor types support database updates ?
  20. static, dynamic, keyset, forward only.
  21. Which statement is used to create an object based on Group class ?
  22. How do we create the method for the Item class ?
  23. Which property procedure is used to retrieve the value of Group Name ?
  24. What are the property procedures that are created for the Group class ?
  25. What is a data file and what are the types of data files ?
  26. What is a foreign key and what is a primary key ?
  27. How do we create a table using Visual Data Manager ?
  28. List all the tables and the fields we need to develop for an Inventory management application ?
  29. When does the class initialize event occur in a Visual Basic Inventory Software ?
  30. What are the methods of ADO we use, while saving transactions ?
  31. Which method of group class checks the duplication of group name ?
  32. Which method of group class saves group details ?
  33. How to create a property procedure for attributes ?
  34. In which event is an object of a group class created ?
  35. Which method of list box is used to add contents to the list box ?
  36. Show with an example the statement used to call the service of a group class ?
  37. How do we connect a dialog form to a account form ?
  38. Which statement is used to create an object based on the Trade class ?
  39. How do we create a method for the Trade class Inventory Software?
  40. Which property procedure is used to retrieve the value of Party Name ?
  41. What are the property procedures created for the Trade class ?
  42. The Setup procedure is called before form is shown. Explain why ?
  43. How do we identify whether a new record is being added or a existing record is being modified ?
  44. What is a transaction and what are the important transactions in a trading firm ?
  45. How do we implement a date control in a form using control array ?
  46. Summarize the credit and debit updations for all transactions ?
  47. List commonalities of transactions.
  48. What are the parts of a class ? List all the members and services of the trade class.
  49. List all the services of the trade class and their purpose.
  50. How do we build a class using a class builder ?
  51. Write the diagram which shows the relationship between the master form and trade class.
  52. How do we display data from the master tables before opening the master form ?
  53. How do we check for the duplication of items in the grid in the master form ?
  54. Where do we use the Zap procedure ?
  55. How do we check for duplication of transaction number in an Inventory Software?
technologies used to write erp books are .net, sql server and C#


Pack Offers

cover image of azure cloud book

Develop Azure Applications

Azure Cloud is gaining popularity and is competing with Amazon Elastic Cloud and Google Cloud for a spot in the billion dollar Cloud computing space.

With this book learn how to use - Table (an Azure Table is different from a SQL Server Table), Queue, Blob storage services, use your local machine to create an Application and a Service, how Azure splits a Table to achieve Load Balancing, Scalability based on the Partition Key, AppFabric Service Bus, Access Control Service, role of Fabric Controller, features of Azure SQL Database and Content Delivery Network.

Many have mastered Cloud Programming and are enjoying the benefits. Why not you?

View Highlights » View Contents »
cover image of foundation database programming book

Create your Own Accounting Software

A foundation book to Master Accounting Software Development, VB.Net, C# and OOPs programming. Detailed explanation of the Accounting domain for programmers is included. SQL and ADO.Net is also covered in detail.

This book gives you a strong foundation in Application Development.

A thorough understanding of the contents will enable you to grasp the topics covered in the accompanying books quite easily. This is because, the accounting domain is dealt with great detail in this book.

The ideal book to get started with application development in the .Net world.

View Highlights » View Contents »

cover image of book

Create your Own WEB ERP Software using ASP.Net

This book opens you to the Web. Using ASP.Net, C# and SQL Server as the tools, you will learn to build a Multi Tier Web Application as recommended by Microsoft. You will learn implementing inline GridView control, Transaction Management for a layered Web Application, build Data Access component and a Business Layer component.

Opens you to a world of opportunities. You will be able to develop a Web ERP application including all the five modules and learn how to use the TreeView control and GridView control to implement transactions such as Purchase Invoice, Sales Order and Sales Invoice.

View Highlights » View Contents »
cover image of entity framework book

ASP.Net MVC 5 Application Development Using Entity Framework 6 and VS 2015

Entity frameworks is the latest buzz in .Net programming and is the data access technology for Microsoft OS based hand held devices and web applications. Learn to integrate EF into an ASP.Net Application and MVC application. Create, explore and query the Entity Data Model. Learn how to use ObjectDataSource control and GridView control in an ASP.Net Application.

Also, learn to build Three-Tier ASP.Net application, create a business-class, implement methods in the class to perform CRUD operations and bind a GridView to the ObjectDataSource control. Learn how to handle concurrency and managing Transactions.

View Contents »