Develop An Inventory Management Application Using Visual Basic

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

Objective

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.



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.

Contents

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

Accounts

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

Units

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

Items

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?