Application Series Books to Master Accounting and Inventory Software Package development using Microsoft's Visual Basic.

Application Series books cover both Technology and Domains and reveal the secrets of Software Product development.

Technology Visual Basic, VB.Net, SQL Server 2000, VB, ADO.Net, ADO, OOPs Database Programming, Relationship between Table and Class, Class Template, Attributes, Members, Functions, Procedures, Forms, Connections, Tables, Fields, Indexes, Keys, Creating Multiple levels of grouping of data.

Domain Accounting, including Double Entry Rules, Assets, Liabilities, Loans, Payable, Receivable, Cash Account, Salary Account, Vouchers, Journal, Receipts, Sale, Purchase, Invoices, Trial Balance, Stock Ledger, Daybook, Goods, Credits, Debits, Accounts, Groups, Chart of Accounts.

Home

Contact Us

Order

FAQ

Links

Develop an Accounting Package using Visual Basic   ISBN: 81-901331-5-2   Price: $19.90   Weight: 1.9 Pounds   Pages: 448

Database Programming using VB.Net and SQL Server 2000. ( Secrets of Developing an Accounting Package revealed. ) (ISBN:: 81-901331-5-2) Objective The objective of this book is to teach the secrets of developing an accounting software package on the .Net platform using VB.Net, ADO.Net, SQL Server 2000 and Crystal Reports. The techniques of developing an accounting package are taught using business logics, programs, flow charts, and other tools to make learning easy and comprehensive. You will learn how to create stored procedures and triggers, secrets of developing all the transactions of an Accounting Package, program the reports using CR, about disconnected architecture, MDI applications, how to create T SQL, and many more. Contents Chapter 1: Visual Basic.Net. Introduction The .NET Framework Components of the .NET Frame work NameSpaces Assemblies Common Language Runtime Features Provided by the CLR Automatic memory management Common Type System Language interoperability Platform Independence Security management Type Safety Compiling and Execution steps in .NET framework. Visual Studio.NET Integrated Development Environment Creating a Project in Visual Studio.Net a. Windows application b. Class Library c. Windows Control Library d. ASP.NET Web Application e. ASP.NET Web service f. Web Control Library g. Console Application h Windows Service i. Empty Project j. Empty Web Project Steps to create a Visual basic.NET Windows Application User Interface elements of Visual Studio.Net IDE a. The Start Page b. Windows Forms Designer c. The Solution Explorer Window d. The Properties Window e. Toolbox f. The Output Window g. The Task list window h. The Server Explorer Window i. The Dynamic Help Window j. The Class View Window k. The Code and Text Editor Window Windows Forms 1. Windows forms properties 2. Windows Forms Events 3. Windows Form Methods The StartUp Form 4. Windows Form Controls and Events a. The Text box Control b. The Label Control c. The LinkLabel Control d. The List box Control e. Check box Control f. Combo box Control g. Radio button Control h. The Group box Control i. The Status bar Control j. The Button Control Control Events Keyboard Events Mouse Events Control-specific events Visual Basic.Net language features 1. Data Types 2. Variables Declaring Variables Variable naming conventions Variable Initialization Variable Scope Block Scope Procedure Scope Module Scope NameSpace Scope Life time of a variable 3. Constants 4. Arrays Declaring an Array Multidimensional Arrays Assigning values to array elements Dynamic Arrays Preserve Keyword 5. Operators Arithmetic Operators Comparison Operators Logical Operators Concatenation Operators 6. Control flow constructs Decision structures If-Then-Else The Select Case Construct Loop structures While-End While Do - Loop For - Next Nested Control Statements 10. Introduction to procedures a. Sub Procedures Access Modifiers used with Sub Procedures Access Modifier and Access Scope Argument Declaration in a Sub Procedure Passing Arguments to a Sub Procedure Calling a Sub Procedure General procedures Event-handling procedures b. Function Procedures Return values of a Function Procedure Calling a Function Procedure c. Property Procedures Property Declaration Argument Declaration in a Property Procedure Calling a Property Procedure d. Procedure Overloading e. Procedure Overriding f. Parameter Array Rules to be followed while using a Parameter Array Passing Arguments of a Parameter Array g. Built in functions in Visual Basic.Net 11. Implementing object oriented programming in Visual Basic.Net a. Class b. Object c. Advantages of using Classes and Objects d. Abstract classes in Visual Basic.Net e. Interfaces in Visual Basic.Net 1 Declaring an Interface 2. Interface Inheritance f. Creating a class in Visual Basic.Net with example Constructors Destructors Write the code to store and retrieve data from the class. Implementing inheritance with example 12. Creating Menus and working with MDI applications a. Menus in Visual Basic.NET b. Context Menus c. MDI Applications d. Integrating the parts of an application Chapter:-2. Accounting. 1. Introduction 2. Business Transactions 3. Financial Position and Accounting Equation 4. Accounts 5. Commonly used Accounts a. Asset Accounts b. Liability Accounts c. Owner's Equity Accounts 6. Chart of Accounts 7. Groups 8. The Double Entry System a. The T - Account 9. Analysis of Transactions 10. The Voucher System a. Journal Voucher Specimen b. Cash Voucher Specimen c. Cash Receipt Specimen d. Purchase Voucher Specimen e. Sales Voucher Specimen 11. Typical Transactions 12. Financial Statements a. Typical Daybook b. Typical Registers c. Typical Trial Balance d. Typical Cash Book e. Typical P & L Account Chapter 3:SQL Server 2000. 1. Introduction to SQL Server 2. SQL Server Tools 3. SQL Server Service Manager 4. Enterprise Manager a. Database Diagrams Tables Views Stored Procedures Users Roles Rules Defaults User-defined data types User Defined Functions b. Data Transformation services(DTS) c. Management d. Replication e. Security f. Support Services g. Meta Data Services 5. The Query Analyzer 6. Object Browser 7. Object Search 8. Fundamentals of Database Design a. Organization b. Integrity c. Optimization d. Relational Databases e. Exploring the FinAccounting Database GroupTable Accounts Table TranTable 9. Understanding relations 10. Creating Tables a. Entering Data into tables b. Null Values c. Indexes d. Views 11. Structured Query Language (SQL) a. Selection and Action Queries b. Executing SQL Statements, Query Analyzer 12. Transact -SQL a. Stored Procedures b. Creating and Executing Stored Procedures c. Using Parameters with Stored Procedures 13. T-SQL the Language a. T-SQL Variables b. Control of Flow Statements 14. Triggers a. Creating a Trigger 15. Transactions Chapter 4:ADO.Net. 1. An Introduction to ADO.NET Types of Application Architectures a. Single-tier Architecture b. Two-tier Architecture c. Three-tier Architecture d. n-tier Architecture 2. The Architecture of ADO.NET 3. The ADO.NET Object Model 4. .Net Data Providers a. Connection Object b. Command Object c. Data Reader d. Data Adapter 5. Dataset Object a. Typed Vs. Untyped Datasets b. Navigating through Datasets c. Updating the Database using Datasets 6. Creating a Stored Procedure 7. Calling Stored Procedure from ADO.NET 8. Calling Stored Procedure with Argument Chapter 5: Developing the Application - I, Framework. 1. Introduction 2. Creating the Project 3. Menu Design 4. Standard Modules Chapter 6: Developing the Application - II, Masters. 1. Introduction 2. Steps to Program the Masters Designing the Database using SQL Server Designing and Programming the Accounts form 1. Declarations a. Imports Namespace b. Declaring connection object, Instantiating the connection object and Set up connection string c. Build Query strings d. Declaring the Command objects e. Declaring DataAdapter object f. Declaring DataSet objects g. Declaring DataRow object h. Declaring SqlParameter object i. Declaring a Public variable 2. Programming the frmAccounts_Load event() procedure a. Opening a Connection b. Instantiate the Commands c. Instantiate the DataAdapter d. Setting the DataAdapter command properties e. Add Select Command parameters f. Add Insert Command parameters g. Add Update Command parameters h. Add Delete Command parameters i. Instantiate the DataSets j. Populate the DataSet k. Traverse the DataSet, Filter the Dataset and populate the list box with Groups l. Traverse the DataSet, Filter the Dataset and populate the list box with Accounts m. Display the first Account details in the respective textboxes n. Enable and disable controls 3. Initializing controls of the Accounts form 4. Function IsDuplicate() 5. Private Function GetGroupCode () 6. Closing the AccountsForm 7. Saving Account details into the DataSet 8. Programming the Cancel button 9. Validating the data entered in the Amount textbox control 10. Moving to a particular row in the DataSet 11. Private Function Appendmode() 12. Achieving error free/rapid data entry by enable/disable controls 13. Programming the Newbutton_Click() 14. Programming the Editbutton_Click() 15. Private Sub mParentGroup_SelectedIndexChanged 16. Programming the Deletebutton_Click() 17. Programming the Closebutton_Click() 18. Private Sub mAmount_Leave() 19. Programming the UpdateDatabaseButton_Click() Connecting the Accounts form to the Menu and using the option Chapter 7: Developing the Application - III, Transactions. 1. Introduction. 2. Developing the Tran Class. 3. Designing and Programming the Journal form. 4. Designing and Programming the VouRec form. 5. Designing and Programming the PurSal form. 6. Programming the Transactions. a. Purchase b. Sale c. Cash Voucher d. Cash Receipt e. Cheque Voucher f. Cheque Receipt g. Credit Note h. Debit Note i. Journal Voucher Chapter 8: Developing the Application - IV, Reports. 1. Introduction 2. Designing and Programming the Trial Balance a. The format in which the data is to be displayed is decided b. Create the rpt file and design the format Procedure to create a Formula Fields Creating Running Total Fields c. Host the rpt in the windows application d. Connect the report to the menu 3. Designing and Programming the DayBook 4. Designing and Programming the Registers 5. Designing and Programming the Income Statement Technical Perspective This book adopts an object oriented approach to developing an Accounting application. You will see why an object oriented application is used in many cases. The reports and transactions dealt with in this book are unique to an Accounting application. Click here to place your order. VK Infotek. Since 1993.