S P SHARMA CLASSES

MIS/VBA/Macros
Duration: 02-03 Months, Fee: Rs. 9000

Content:



  1. Advanced Excel
    • Conditional Formatting
    • Advanced Sorting
    • Filter
    • Advanced Filter
    • Pivot Table/Pivot Chart
    • Advanced Chart
    • All Formulae
    • VLookup/HLookup
    • Relative and Absoulte Address
    • Goal Seek
    • Data Table
    • What if Analysis
    • Array Functions
  2. VBA Application
    • Overview
    • Excel Macros
    • Excel Terms
    • Macros Comments
    • Message Box
    • Input Box
    • Variables
    • Constants
    • Operators
    • Decisions
    • Loops
    • Strings
    • Date and Time
    • Arrays
    • Functions
    • Subprocedure
    • Events
    • Error Handling
    • Excel Objects
    • Text Files
    • Programming Charts
    • ActiveX Controls
    • Userforms
  1. Access with VBA
    • Introduction to Access Programming
    • Developing with Procedures and Functions
    • Utilising Intrinsic Functions, Variables and Expressions
    • Controlling Program Execution
  2. Theory, Terminology and Concepts of Database
    • Client/Server Concepts
    • Database and Database Objects
  3. Data Definition using SQL
    • Databases
    • Data Types
    • Tables
    • Constraints and Indexes
    • Views
  4. Basic Data Manipulation using SQL
    • Recurring SQL Constructs
    • Adding data
    • Modifying data
    • Removing data
    • Searching data
  5. Advanced Data Manipulation using SQL
    • Expressions
    • Grouping and Aggregate Functions
    • Joining Tables
  6. Transactions
    • Transaction Concepts
    • SQL for working with Transaction
  7. Import/Export
    • Tools for Import/Export
    • SQL for Import/Export