Visual Basic Properties mathods and events or features

PT. RAVISHANKAR SHUKLA UNIVERSITY, RAIPUR (C.G.)

POST GRADUATE DIPLOMA IN COMPUTER APPLICATION 2019-20

[DURATION - ONE YEAR - FULL TIME]

The duration of the course shall be one year consisting of two semesters. There shall be three theories and two practical courses in the each semester.

FIRST SEMESTER

PGDCA-101 : Introduction to software organisation

PGDCA-102 : Programming in "C"

PGDCA-103 : Office automation and Tally

PGDCA-104 : Practical based on PGDCA-103.

PGDCA-105 : Practical based on PGDCA-102.

PGDCA-103

OFFICE AUTOMATION AND TALLY

• UNIT-I : Windows Concept

Windows Concepts, Features, Structure, Desktop, Icons, Taskbar, Start Menu, My Computer, Recycle Bin, My document, creating shortcut, Accessories : Calculator, Notepad, Paint, WordPad, Character Map. Windows Explorer : Creating files & folders and other Explorer facilities, Object Linking & Embedding. Communication : Dial-up Networking, Phone Dialer. Difference among windows versions.

• UNIT-II : Word Processing & Spreadsheet

Word : Creating, Editing & Previewing Documents, Formatting, Advanced Features, Using Thesaurus, Mail Merge, Table & Charts, Handling Graphics, Converting Word Document into other Formats.
Excel : Worksheet Basics, Creating, Opening, & Moving in Worksheet, Working with Formula & Cell referencing, Absolute & Relative addressing, Working with Ranges, Formatting of Worksheet, Graphs & Charts, Database, Function and Macros.

• UNIT-III : Power Point & FoxPro

Power Point : Creating a presentation, Modifying visual Elements, Adding objects, Applying Transitions, animations and linking, Preparing handouts, presenting a slide show.
FoxPro : Preparing Database files, access & retrieval of records in a data base file, inserting & deleting of records. Programming preliminaries. Sorting & Indexing. Development of programs LOOPING, Branching, report making.

• UNIT-IV : Access

Introduction of MS Access, The Tables of a Database, Introduction to the Record of a Table, Introduction to Controls Design, Details on Controls Design, The Characteristics of a Table, The Characteristics of a Form, The Characteristics of a Window Control, Data Controls, Introduction to Data Expressions, Getting Assistance With Data Entry, Database Strings, Database Numeric Values, Database Conditional Values, Database Date and Time Values, Creating Reports, Characteristics of Reports.

• UNIT-V : Tally 

Setting up Ledger & Groups. Study of recording of transactions in the 'Voucher'. (According to Golden rules). Study of 'Final A/C preparation & displaying in different mode/format'. Study of alteration & Deletion of ledger/Groups. Study of cash & fund flow, Day book, sales register, purchase register, bills receivable/Payable etc. Study of data security & backing up data. outline of entry for Income Tax, ED, VAT, ST,/CST, PF, Gratuity, Bonus, Loans & Depreciation etc.