· Excel intermediate, Access ( Intermediate), VBA Basic
· Good to Have Excel Adv , Access ( Adv ), VBA Intermediate, SQL language basic VBA
· Knowledge of DAO/ADO connectivity from Excel to Access or SQL.
· Should be able to run Insert/Update/Delete commands in Access/SQL data base from Excel interface.
· Should be able to use Access/SQL queries/store procedures from Excel.
· Should be aware of most of the Visual basic components/Controls available in Excel.
· Access/SQL
· Well conversant with how to create tables/queries/Store procedures/Forms/Reports/modules/Macros in Access.
· Should be able to create Excel based reports from Access/SQL server.
· Should be aware of Import/Export utilities in Access/SQL
