Skip to content
  • +91 96 88 678 111
  • support@vivegroups.com

New : Learn yourself in an easy way...

Quick Links
  • Tutorial Index
  • Software Demo
  • Online Services
  • Like Us
ViVe Groups

ViVe Groups

Live as if you were to die tomorrow. Learn as if you were to live forever.

  • Home
  • System Solutions
  • IT Education
    • Tutorials
    • CSC Arcot Results
  • Easy English
    • Picture Dictionary
  • CSC-IBT
  • To Do
  • Products
    • Saveji
    • 1site.online
    • NG Developer
    • Mirth Bees
    • Dr.Mathavan Heartcare
    • Active Heart Foundation
    • Software Google
  • For a Job

Tag: Backup and Restoration

HDCA (Tally) Honours Diploma in Computer Application

April 26, 2013March 28, 2019 RVS

WINDOWS

Computer  Fundamentals  –  Introduction to OS/GUI  – WordPad  –  Notepad  – Paintbrush –  Windows Explorer – Control Panel.

MS OFFICE

Word Creating Text and Documents  –  Indexes and    Tables  –  Embedding Picture  –  Table Manipulation –   Mail Merge  –  Macro.

Excel Formatting Cells  –  Charts  – Pivot table –Data Table- Forms  – Scenarios  –  Goal seek  –  Macros and Models.

PowerPoint Creating Presentation –  OLE – Enhancing Presentations  –  Adding Audio & Video – Special Effects.

INTERNET

Introduction to Internet,  www , http &  E-mail  –  Creating E-mail ID  – Receiving  & Sending E-mail  –  Chatting  – Locating Information  –  Downloading.

II .Client / Server Technology

VISUAL BASIC

Controls – User Controls – Properties and Events – Control statements and Loops – Procedures and Functions – Error Handling – Creating Instances of Objects – Menu Editors – MDI Applications – Sequential, Random and Binary File Handling – Data Manager – ODBC – OLEDB- Data Controls and SQL – Active x – RDO – ADO – Data Report- DHTML.

MySQL

Client / Server Concepts – Relational Model – Data Definition Using SQL – Modify Tables – Using ALTER TABLE Queries, Add a Column, Add an Index, Add a Primary Key – INSERT and DELETE Queries – UPDATE Queries – Using Select Queries – SELECT, WHERE, LIMIT, ORDER BY, GROUP BY, JOIN -Constraints  and Indexes – Views – Expressions – Grouping -Using Functions – Math Functions, Compare String values, Work with Dates – JOIN and Subqueries – Advanced MySQL Query Processing – Database Management, Stored Procedures, Triggers, etc.

PROJECT*

With our guidance students will undertake one Client- Server Project.

III. FINANCIAL ACCOUNTING   

TALLY.ERP 9

Principles of Accounting –  Tally fundamentals – Maintaining Company Data – F11 Features, F12 Configure.

TALLY VOUCHERS

Accounting Vouchers / Inventory – Accounting and item invoicing.

Reports

Balance Sheet – P & L A/c – Ratio Analysis – Cash flow, Fund flow Statements – Ageing Analysis – Movement Analysis.

ADVANCED ACCOUNTING

Bill wise Details – Cost Centres and Cost Categories – Voucher Classes and Cost Centre Classes – Multiple Currencies – Bank  reconcilliation -interest Calculation – Budgets & Scenario – Job  Costing.

ADVANCED INVENTORY

Order Processing – Recorder Levels – Tracking Numbers -Batch wise Details – Additional cost Details -Bill of  Materials – Price List.

SYSTEM ADMINISTRATION AND OTHER  UTILITIES

Consolidation of Accounts  –  Tally   Vault   –  Security Control  – Tally Audit  –  Back  up  and  Restore   –  Split company Data  –  Export  and  Import   of Data   –  ODBC   Compliance.

POINT  OF  SALES

Predetermination  of   invoice  – Multi  Payment  Modes  – Small  & Smart Bills – POS Sales   Register.

MULTI LANGUAGE 

Supporting OS  – Translation  or Transliteration  –  System  &  Phonetic Keyboard   –  Sourcing  from  Other Software.

GOODS  & SERVICE TAX (GST)

Accounting  of purchase or   Sales  returns   –  inter  state Trade Accounting  –  Accounting  of   Exempted   Items  – Accounting   Purchases  from Unregistered  Dealers – Accounting  Input   Credit on  Capital Goods  – GST  Computation  & Forms.

TDS  & TCS 

Entry – calculator   – Reports   – e Returns.

PAYROLL

Introduction  to  Payroll  –   Configuring   Tally  for  payroll   –  Creation of  payroll  Masters  – Recording of Attendance –  Preparation  of  payroll Vouchers  based  on attendance  – of  a salary Disbursement Voucher   – Payroll  Reports.

PROJECT 

Live  simulated projects are given to students.

IV. ELECTIVE I : Web Programming

HTML

Tags – Links  – Anchor – Adding Pictures – Lists – Tables – Frames – Forms – Menu Controls.

FRONT PAGE

Tables –  Frames – Forms – DHTML effects.

VB SCRIPT

Functions –Procedures – Objects – Event Handling – Forms and Frames.

ASP

Forms – Cookies- ActiveX Server Components – Database Support – Reading and writing to Files – Security.

XML

Element – Attributes – Creating & Designing Tags Document Type Definition.

PROJECT

Development of Website.

IV. ELECTIVE II :

ADVANCE EXCEL & VBA PROGRAMMING

ADVANCE EXCEL

Introduction to MS Excel and Understanding Basic Working with it – Formatting Worksheet – Working with Formulas/Functions (Lookup and Reference Functions, Logical Function, Database Functions, Math and Trigonometry Functions, Statistical Functions, Text functions) – Conditional Formatting – Connect to other database – Data Sorting and Filtering – Pivot Tables & Charts.

VBA PROGRAMMING

VBA Overview – VBA Programming Variables – Conditional Logic – String and String Functions – Programming Loops – Programming Arrays – subs and Functions – Creating your first Macro – Excel VBA Error Handling – Excel VBA and User forms – Connect with an external data – Work on automation project. 

 

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
CSCAccess, Active x, Active x Server Components, Adding Audio & Video, Adding Pictures, ADO, Anchor, Arrays, ASP, Attributes, Backup and Restoration, Balance Sheet, Bank Reconciliation Statement –VAT, C LANGUAGE, Cash Flow, Charts, Chatting, Circular Linked List –Bit Manipulation, Classes & Objets, Classification of Ledgers, Client, Client Configuration Utility, Computer Fundamentals, Concept of Inventory Groups, Concepts of Relational Database, Concurrent Multilingual, Conditional Compilation, Constructor & Destructor, Control Panel, Control statements and Loops, Controls, Cookies, Creating & Designing Tags Document Type Definition, Creating & Maintaining Database, Creating E, Creating Form, Creating Instances of Objects, Creation of Godowns, Data Controls and SQL, Data Integrity, Data Manager, Data Modeling, Data Report, Data Types, Database Foxpro 2.6, Database MS, Database Support, Development of System, DHTML, DHTML effects, Double Linked List, Downloading, Dynamic Memory Allocation, Elective I, Elective II, Element, Embedding Picture, end, end and Visual Basic as Front, Enhancing Presentations, Error Handling, Event Handling, Excel Formatting Cells, expressions, File Handling, File handling using Stream Classes, Forms, Forms and Frames, Foxpro, Frames, Friend Functions & Classes, FRONT PAGE, Function Overloading, Functions, Fund s Flow, Goal seek, Graphical Utility, Groups Comparison, HDCA, Honours Diploma in Computer Application, HTML, http & E, Indexes and Tables, Inheritance, Input & Output Streams, Instance, INTERNET, Introduction to Data Structure, Introduction to Internet, Introduction to OOPS, Introduction to OS/GUI, Inventory control, Linked List, Links, Lists, Locating Information, Looping & Branching, Macro, Macros and Models, mail, mail ID, Mail Merge, MDI Applications, Member Functions, Menu Controls, Menu Editors, MIS Reports, Movement Analysis, MS Access, MS-Office, Multi Stock Valuation, Multiple Financial Years, Notepad, Objects, ODBC, OLE, OLEDB, OOPS Using C++, Operator Overloading, Operators, Outstanding Statements, P&L A/c, P&L Account, Paintbrush, Pivot table –Data Table, Pointers, Polymorphism, PowerPoint Creating Presentation, Principles of Accounting, Procedures, Procedures and Functions, Programming Concepts, PROGRAMMING TOOL, Project, Properties and Events, Random and Binary File Handling, RDO, Reading and writing to Files, Receiving & Sending E, Reminders, Report, Report and Queries, Reports, Scenarios, Security, Sequential, Server Project using SQL Server as Back, Server Technology, Service Tax, Service Tax Report, Sort and Index, Special Effects, SQL Enterprises Manager, SQL SERVER, Stock Items, Storage Classes, Stored Procedures, Structures and Unions, students will develop Financial Accounting System, Table Manipulation, Tables, Tags, Tally ERP 9, TDS, Templates, Trial Balance, Triggers, TSQL and ANSI SQL, User Controls, VAT Reports, VB Script, Views and Index, VISUAL BASIC, Voucher Types, Web Programming, windows, Windows Explorer, With our guidance, With our guidance students will undertake one Client, Word Creating Text and Documents, WordPad, www, XML2 Comments

Posts navigation

Older posts

Blog Categories

open all | close all

Today’s Top Posts & Pages

  • Welcome to ViVe Groups Educational Site...
  • ADJP Advanced Diploma in Java Programming
  • HDCP Honours Diploma in Computer Programme
  • MOU / CONSULTING AGREEMENT FORMAT
  • Reports
  • Chapter 1: Introduction to Accounting & Tally
  • Chapter 10: Voucher Type & Class
  • Chapter 4: Accessing Information
  • Chapter 8: Printing
  • Tutorial Index

Categories

  • Answer these questions (42)
    • Tally ERP 9 (36)
    • Windows & Internet (6)
  • Blog (76)
  • Business Collection (19)
  • CSC (26)
    • Ad Video (1)
    • CSC Arcot Results (2)
  • CSC-IBT (1)
    • TNPSC Group 4 (1)
  • Online Exams (8)
  • Reports (1)
  • Social (12)
    • Health (1)
    • Tamilnadu Government (7)
  • Speak Easy (43)
    • Comfort (12)
    • Command (5)
    • Connect (12)
    • Contact (13)
  • System Solutions (47)
    • Software Demo (9)
  • Tutorials (131)
    • ASP (52)
    • Basics (1)
    • English (1)
    • Html (12)
    • Internet (1)
    • RMI (5)
    • SQL (59)
  • Videos (32)

Like our Facebook Page here:

Like our Facebook Page here:

Subscribe your email id:

Enter your email address:

Copyright © 2018 ViVe Groups. All rights reserved.
Proudly powered by WordPress | Education Hub by WEN Themes