Diploma in E-accounting and M.I.S

  Prof. MS Access (RDBMS)

Understanding Databases 

• Starting and Opening an Existing Database
• Moving Around in Access
• Understanding Datasheet View & Design View
• Using the Mouse Pointer to Navigate
• Using the Keyboard to Navigate
•  

Creating Tables

• Creating a Database
• Creating a Table Using the Wizard
• Creating and Modifying a Table
• Adding Fields to Tables
• Adding and Editing Records
• Printing Tables
• Moving and Deleting Fields
• Deleting Records
•  

Working with Tables

• Formatting a Table
• Modifying Field Properties
• Sorting Records in a Table
• Finding Records in a Table
• Using Filters with a Table
• Establishing Relationships Between Tables
• Creating Subdatasheets
• Importing Records From an External Source
•  

Designing a Form

• Creating a Form Using Auto Form
• Creating a Form Using the Form Wizard
• Adding Controls to a Form
• Modifying Control Properties
• Resizing and Moving Controls
• Entering Records into a Form
• Creating Calculated Controls
•  

Designing a Report

• Creating a Report Using Auto Report
• Creating a Report Using Report Wizard
• Adding a Control to a Report
• Formatting a Report
• Resizing and Moving Controls
• Creating Calculated Controls
•  

Creating and Using Queries

• Creating and Running a Query
• Specifying Criteria in a Query
• Using Comparison Operators
• Creating a Calculated Field
• Creating a Multiple-Table Query
• Printing a Query

Automating Tasks

• Creating an Auto Keys Macro
• Using Controls to Run a Macro
• Assigning a Macro to an Event
• Assigning a Macro to a Condition
• Testing and Debugging a Macro

 VBA MACROS

What Is Vba & How Vba Works With Excel

• Quick Review of Macros
• Introducing the Visual Basic Editor
• Uses of record Macros
• Understanding and creating modules
•  

Programming Concepts

• VBA Sub and Function Procedures
• How to create a message box
• Write a Program to update and retrieve information using Input Box
• Understanding and using Select Case statement
• How do I define a variables and Rules for defining a Variables Name and Type
• Creating And using Variables
• Working with range Objects
• How to save and Protect Modules
•  

Decision Makers

• If……Then……Else
• If……Then……Else If……If
•  

Other Kinds of Loops

• Working with Do While u. Loop Procedure
• Do…… Until Loop and Do…… Loop Until
• Do……While loop and Do…… Loop While
• For each…… Next
• For……Next
•  

Workbook Objects Create or Add Single and Multiple Workbooks

• Workbook Save and Save AS
• Open Single and Multiple Workbooks
• Close Specify and Multiple Workbooks
• Activate From one workbook to another Workbook
• Open Workbook from Specific Path
• Get Workbook Name and Paths
• Hide and Unhide for Single and Multiple Workbooks
• Protect and Unprotect Worksheets
•  

Worksheet Objects insert a single and Multiple Worksheets

• Delete Specific and multiple worksheets
• Get Count of Worksheets
• Select a Specific and all Worksheets
• Get All Worksheets Name
• Hide and Unhide For Single and Multiple Worksheets
• Rename for Single and Multiple Worksheets
• Protect and unprotect worksheets
• Sort and Move worksheets
• Calculate entire worksheet
• Using VBA and worksheet Function

Cell objects insert Single and multiple Row, Column and Cells

• Delete Single and Multiple rows, Column and Cells
• Get Range or Address of Cell and Selection
• Navigate from one Cell to another Cell
• Select specific Range, Cell, Rows and Column
• Types of Selection and Offset method
• Insert Function In cell
•  

Reading and Writing Arrays

• Defining Arrays
• Arrays as Outputs
• Arrays as inputs
• The Arrays as a Collection
• The Array as an Array
•  

Form Controls and User Forms (Create and Design an user Form)

• Working with User Forms & User Forms Events Like List Box, Combo Box, Option Buttons, Check Box, Text Box, Labels, Command Button, Toggle Button.
• How to Create Dynamic Dashboard on User Form with Different Controls
• How to Link Various User Form With Each Other To Create A Complete Interface Between User and System
•  

VBA Programming Functions

• Create a Sum Functions
• Create Multiply Function
• Create Count Function
• Extract Text & Number
• Proper Function
• Vlookup Function
• Square root Function
• Public or Private function
•  

Excel VBA Power Programming for VBA Macros

• Working with Dynamic Ranges. Protecting worksheets, Cells and Ranges. Working with Multiple Files. Opening &saving Files
• How to Analyze Data On multi Worksheets and Build Summary sheets
• how to Access the Windows File and Folder System to Open and Close Workbooks
• How to protect your code Against Errors
• How to use Excel And VBA to Create Basic Dash Boards
• How to create Your own custom Business Worksheet Function in VBA
• How to create Basic Report Generation Tools Using Excel Vba, Microsoft Word and PowerPoint
• How to use the Excel Visual Basic Macro record Excel Tasks in VBA and then Interpret the code
•  

Connection between Excel VBA & other platforms

• How to Establish Connection Between VBA And Power Presentation to Create Power Point Through VBA
• How to Establish Connection Between Excel Vba And Outlooks Through Vba
• How to Establish Connection Between Excel Vba And MS Word Through Vba

Module 4

 BUSY

General Features

• Completely Codeless
• Multi-Company Accounting
• Context-Sensitive On-Line Help
• Flexible Voucher Numbering
• Multiple Voucher Series for each Voucher Type
• Voucher entry while viewing reports and Vice-versa
• User-definable Optional Fields in Masters and Vouchers
• Unlimited level of Grouping of Accounts, Items, Material Centers and Cost Centers
• Option for adding Images & Notes in Account & Item Masters
• Draft Mode Printing for every Report and Document
• Voucher Cancellation
• Powerful Query System
• SQL Query Executor
• Print Preview
• Landscape Mode Printing
• Bird’s Eye View of Account
• ENTERPRISE FEATURES
• Voucher / Master Approval
• Message centre
•  

Financial Accounting

• All books of Accounts & Final Results
• Balance Sheet with various Schedules
• Columnar Account Registers (Configurable)
• Daily / Monthly Summaries of Accounts, Account Groups and Cost Centers
• Bill-wise Outstanding with Ageing Analysis
• Payment Reminder Letters (Configurable)
• Statement of Account (Configurable)
• Handling of Post-dated Cheques
• Broker-wise Reporting
• Royalty Calculation
• Interest Calculation (Multiple Slabs based on Amt. & Days)
• Bank Interest Calculation
• Bank Re-conciliation
• Depreciation Chart (As per Companies Act / IT Act)
• Multi-Currency Accounting
• Cost Centre-wise Reporting
•  

Multi-Location Inventory

• All books of Inventory
• Stock Status (Multi-location)
• Sales / Purchase Challans
• Columnar Inventory Registers (Configurable)
• Stock Valuation on Multiple Methods
• Separate Stock Valuation Method for each Item
• Item Serial No. Tracking
• Stock Ageing Analysis
• Allocation of Expenses to Items
• Daily / Monthly Summaries of Items and Item Groups
• Automatic Round-off in Vouchers
• Primary and Alternate Unit for each Item
• Batch-wise Inventory with Expiry Date
• Provision for Free Qty in Inventory Vouchers
• Provision for entering Sales / Purchase Return in Sales / Purchase Vouchers
• Production / Un-assemble
• BOM / Production Planning
• Critical Level Reporting
• Multiple Price-list for Items
• Multiple Price Structures (Party / Qty / Category-wise)
• Provision to update Item Prices on various Criterion
•  

Sales / Purchase Order Processing

• Pending Sales Orders (Party / Item-wise)
• Pending Purchase Orders (Party / Item-wise)
• Order Cancellation
• Invoice / Challan Generation from Orders
• USER-CONFIGURABLE INVOICING
•  

Fully User-Configurable

• Use Plain / Pre-printed Stationery
• Option for Fonts, Colors& Logos
• Option to Print Outer Box, Horizontal & Vertical Lines
• Multiple-taxes in Single Invoice
• Tax Inclusive / MRP Billing
• Point-of-Sale (POS) Billing
• Mfg. Excise Invoicing
• Trading Excise Invoicing
•  

User-Configurable Documents

• Accounting Vouchers
• Purchase Invoice
• Sales Return / Purchase Return Invoice
• Receipt / Payment Advice
• Debit / Credit Note
• Sales / Purchase Order
• Delivery Note / Goods Receipt Note
• Stock Transfer Memo
•  

Sales Tax Reports

• Sales Tax Forms Receivables / Issuable
• Sales Tax Forms Reminder Letters
• Forms Received / Issued Register
• Sales Tax / Purchase Tax Summary
• Sales Tax Surcharge
• Sales Tax Registers
•  

GST Reports

• GST Computation / Summary
• GST Invoicing (Tax / Retail)
• GST Returns (State-wise)
• GST Registers (State-wise)
• Columnar GST Registers (Configurable)
• Party-wise / Item-wise GST Summary
• Party-wise / Item-wise GST Summary
• Sales Re-conciliation as per Accounts and GST
• GST R1
• GST R2
• GST 3B
•  

Service Tax

• Input Service Tax Register
• Output Service Tax Register
• Service Tax Summary
• ST-3 (Service Tax Return)
•  

TDS Reports

• TDS Calculation
• TDS Warning Alarms
• TDS Challans
• TDS Certificate (Form 16-A)
• TDS Return (Form 26-Q)
• Annexures to Form 26-Q
• e-TDS with TDS 27-A
• TDS Audit Report
• TDS Deduction Details Report
•  

Fringe Benefit Tax

• Mark Expenses as FBT
• Expense-wise Taxable Value
• Option to charge FBT on Account Groups
• Fringe Benefit Tax Report
•  

MIS Reports

• Cash Flow / Funds Flow
• Budgets / Targets / Credit Limits
• Ratio Analysis
• Sales / Purchase Analysis on various combinations
• Issue / Receipt Analysis
• Consumption Analysis
• Data Check List
• Profitability Reports (Item / Bill / Party / Batch / MC wise)
• Multi-Company Final Results / Reports
•  

Utilities

• Data Freezing
• Pop-up Calculator
• Notes / Task Manager
• User-definable Access Rights

Module 5

 TALLY

Introduction of Tally

• Company information
• Create a new company
• Current period, current date
• Company creation (accounts maintain, financial year, security control, tally vault)
• Accounts info
• Group ledger
• Ledger

Book Keeping

• Entries with dr. And cr.
• Using cash account in journal
• Debit & Credit note
• Voucher types
• Select company
• Shut company
• Alter company
• Delete company
• Group company
• Change tally vault

Financial Reports & Consolidate Ledger Accounts

• Balance sheet
• Profit & loss a/c
• Ratio analysis

Fund management with list of account

• Trial balance
• Accounts book
• Statement of account
• Cash/fund flow
• Day book
• List of account
•  

Mode of Invoice Punching/billing

• Bill wise detail with (new reference, against ref, advance, on account)
• Display (statement of a/c
• Bills payable, Receivables
• outstanding ledger, group)

Inventory Management

• Stock group
• Stock item
• Unit of measure
• Voucher entries –goods in, goods out
• Alternate unit and standard rate
• Opening balance, stock summary

Purchase & Sales Order Processing

• Purchase and sale order
• Create purchase order
• Alter purchase order
• Delete purchase order
• Create sale order
• Alter sale order
• Delete sale order
• How can we do reject in reject our entry & use option
• Delivery note & Receipt note
• Give challan number in item
• How can we do reject in reject our entry & use option
• Delivery note & Receipt note
• Give challan number in item
•  

Internal Report of Finance

• Display (inventory books, day book, list of account)
• Accounts with inventory (balance sheet. P&l a/c, stock summary, ratio display)

Controlling (Cost Center & Cost Categories)

• Cost centre
• Creation of cost centre
• Alteration of cost centre
• Cost categories
• Create cost categories
• Alter cost categories

Multi godown creation

• Godown/location
• Create godown
• Alter godown
• Removing companies
• Copy company
•  

Tax Deducted at Source (TDS)

• Tds
• Transaction of tds
• Ledger for tds
• Payment voucher
• Preparing tds challan
• Deposit of tds to govt
•  

Tax Collected at Source (TCS)

• Understanding TCS
• Creating TCS Masters & Practical Examples
• TCS Payment, Reports, & Forms
•  

Goods and Services Tax (GST)

• GST
• Ledger for GST
• Transaction of GST
• Adjustment of GST
• Payment of GST

Budgets and Controls in Tally

• Budget
• Types of budget
•  

Scenarios and Optional Vouchers

• Creation of scenario
• Alter or display scenario information
•  

Export, Backup and Splitting company data

• Splitting company data
• Steps of splitting
• From tally to excel
• Importing into MS-excel
• Removing companies
• Copy companies

Printing Reports

• Printout of balance sheet, p&l a/c, ledger
• Printing Different Reports
• Sales Invoice
•  

Multi-Currency

• Currency creation (How to create
• New currency & how to set the price Lists.

Point of Sales

• POS (Point of Sale)

Payroll Accounting Functions

• Payroll (payroll info)
• Employees and salary detail
• Maintain attendance register of employees
• Employees group
• Create attendance type
• Unit of leave (payroll)

Manufacturing Vouchers

• BOM (bill of material)
• Create Item of BOM
• How to create voucher after
• Ledger of BOM
• Transaction of BOM
• Alter of BOM
• After ledger for excise duty

Batch wise Details

• Batchwise Inventory
•  

Interest Calculations

• Interest Calculations

Credit Limit Price List

• Creation of Price level
• Create of Price group
• Maintain Price list on items
•  

Voucher Types and Class

• Voucher Type
• Voucher Class-Sales
• Inclusive Tax Class
• Customer pay their payment
• How to create voucher with discount & freight charg