VK Infotek
Office Phone: 091-80-3637381     Email:    [email protected]


Close

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.

  1. Introduction
  2. The .NET Framework
  3. 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.
  4. Visual Studio.NET Integrated Development Environment
  5. 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
  6. Steps to create a Visual basic.NET Windows Application
  7. 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
  8. 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
  9. 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 Filed
        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.

Pages : 475
Cost: US $ 19.90/-
Weight: 1.7 Pounds

Click here to place your order.






VK Infotek. Since 1993.