Weekend Class For Advanced Excel & VBA Macros Training Institute - Online Live Class | VBA Macros Classes MIS Training Course Institute in Delhi, Advanced Excel MIS Executive Jobs Training in delhi, MIS Training Delhi, MIS Course in Delhi, MIS & Analytics Training Institute in Delhi NCR, Noida, Gurgaon, Faridabad, Ghaziabad NCR, Delhi NCR, India, mumbai, noida, jaipur, chandigarh, Kolkata, bangalore, chennai, pune, lucknow, bhopal, Hyderabad, Gaziabad, Faridabad, Gurgaon, Noida, Agra Advanced Excel Training, Excel Online Training - Learn Advance Microsoft Excel?,Advanced Excel Course: Learn Expert Features Online,Microsoft Excel School - Online Advanced Excel & Dashboard,Microsoft Excel - Basic and Advanced,Best Advanced Excel Training Courses in Delhi, India,Excel 2013 training courses, Advanced Excel Online Tutorial | MS Excel Certification Course Bab Ezzouar Babol Babruysk Bacău Bacolod Bacoor Badajoz Badalona Bafoussam Bagé Baghdad Bago City Bago Baguio Baharampur Bahawalnagar Bahawalpur Bahía Blanca Bahir Dar Bahraich Baia Mare Baicheng Baidoa Baise Baishan Baiyin Bakersfield Baku Balakovo Balashikha Baleshwar Balıkesir Balikpapan Baliuag Bally Bălți Baltimore Balurghat Bamako Bamenda Banda Aceh Bandar Abbas Bandırma Bandung Bangalore Bangkok Bangui Banha Bani Suwayf Banja Luka Banjarmasin Banjul Bankura Baoding Baoji Baoshan Baotou Barakaldo Baraki Baranagar Baranovichi Barbacena Barcelona Bardhaman Bareilly Bari Barika Barinas Barisal Barnaul Barquisimeto Barra Mansa Barrackpur Barrancabermeja Barranquilla Barreiras Barretos Barrie Barueri Baruta Barysaw Basel Basirhat Basra Bat Yam Batala Batam Batangas City Bataysk Bath Bathinda Batman Batna Baton Rouge Battambang Batumi Bauru Bayambang Bayamo Bayamón Bayannur Bayawan Baybay Bazhou Beau-Bassin Beaumont Beauvais Beawar Béchar Beed Beersheba Bei'an Beihai Beijing Beipiao Beirut Béjaïa Belém Belfast Belford Roxo Belgaum Belgorod Belgrade Bellary Bellevue Bello Belo Horizonte Bengbu Benghazi Benguela Beni Mellal Benito Juárez Benoni Benxi Beppu Berbera Berdyansk Berezniki Bergamo Bergen Bergisch Gladbach Berhampur Berkeley Berlin Bern Besançon Betim Bettiah Bhadravati Bhagalpur Bhalwal Bharatpur Bharuch Bhatpara Bhavnagar Bhilai Bhilwara Bhimavaram Bhind Bhiwandi Bhiwani Bhopal Bhubaneswar Bhuj Bhusawal Białystok Bidar Bielefeld Bielsko-Biała Bihar Sharif Bijapur Bikaner Bila Tserkva Bilaspur Bilbao Billings Biñan Binangonan Binzhou Biratnagar Birjand Birmingham Bishkek Bislig Biskra Bissau Biysk Bizerte Blackburn Blackpool Blagoveshchensk Blantyre Blida Bloemfontein Blumenau Bnei Brak Boa Vista Bobo-Dioulasso Bocaue Bochum Bogor Bogota Bogra Boise Bojnord Bokaro Steel City Boksburg Bole Bologna Bolton Boma Bonn Bordeaux Bordj Bou Arréridj Bordj El Kiffan Borujerd Bosaso Boston Botoșani Botou Botshabelo Bottrop Botucatu Bou Saâda Bouaké Boulder Boulogne-Billancourt Bourg-en-Bresse Bournemouth Bozhou Bradford Braga Bragança Paulista Brăila Brampton Brasília Brașov Bratislava Bratsk Braunschweig Brazzaville Breda Bremen Bremerhaven Brescia Brest Bridgeport Brighton Brisbane Bristol Brno Brownsville Bruges Brussels Bryansk Bucaramanga Bucharest Bucheon Budapest Budaun Buenaventura Buenos Aires Buffalo Buga Bujumbura Bukan Bukavu Bukhara Bulandshahr Bulawayo Buôn Ma Thuột Burao Burbank Burewala Burgas Burgos Burhanpur Burlington Burnaby Bursa Bury Busan Bushehr Butuan Buzău Bydgoszcz Bytom Butwal  Algeria  Iran  Belarus  Romania  Philippines  Spain  Cameroon  Brazil  Iraq  Myanmar  India  Pakistan  Argentina  Ethiopia  China  Somalia  United States  Azerbaijan  Russia  Turkey  Indonesia  Moldova  Mali  Thailand  Central African Republic  Egypt  Bosnia and Herzegovina  Gambia  Venezuela  Italy  Bangladesh  Colombia  Canada   Switzerland  Israel  United Kingdom  Cambodia  Georgia  Cuba  Puerto Rico  Mauritius  France  Lebanon  Serbia  Libya  Angola  Morocco  Mexico  South Africa  Japan  Ukraine  Norway  Germany    Nepal  Poland  Kyrgyzstan  Guinea-Bissau  Tunisia  Malawi  Burkina Faso  Democratic Republic of the Congo  Ivory Coast  Portugal  Slovakia  Republic of the Congo  Netherlands  Australia  Czech Republic  Belgium  South Korea  Hungary  Burundi  Uzbekistan  Zimbabwe  Vietnam  Bulgaria

Learn Advanced Excel, VBA Macros or MS Access

Join Weekend 4 Hours Class for Excel,VBA or Access 2016

Microsoft Access 2016 Training with VBA or SQL

MS Access 2016 Database used for SME and easy Connect or Analysize of larg Database in MNC use access to help Report Automation Excel . In this Course you will learn Complete Database creation using Table,Form,Query or Report also include SQL Query and VBA Programming in MS Access 2016..

Enrol This Course Now

PART=3

     1. Basic MS Access 2016 Database ( Table Creation)

        1. Introduction of MS Access 2016

        2.How Can Create and Set Data Type in Table

        3.Copy Data From Excel Sheet and Apply Filter Sort and Foumulas in Table

        4. Use Macros in Data Table

        5.SubDataSheet in Table

        6.OLE Object for Show Pivot Chart on Table Form

        7. Import Data From Excel,Access,Ocale or Outlook Inbox

        8.Export MS Access Data to XL,XLM,PDF,Work

     2.Query in MS Access 2016

        1. Simpal Query form Query wizard

         2.Cross Tab,Find Duplicat and Unmatch Query from Query Wizard

        3.Designe Query and Apply Condition and or like

        4.Designe Query - Apply Mathematics Calculation in Query

        5.Desine Query In-Build Math formulas in Query

        6.Inspection Formulas in Desine Query

        7.PMT Formulas in Query In-BildFunction

        8.PV,FV,IPMT,PPMT and more Financial Formulas in Query

        9.Make a Table,Append,Update,Delete Query

        10. Relationship One table to Another Table using Query

    3.Query with SQL Statment

        1. Simple Select Query in MS Access 2016 SQL Query in Hindi

        2.use And,OR,Between,NOT in MS Acces SQL Query in Hindi

        3.Group by with SQL Function (Sum,Count,Max,Min,avg) in MS Access SQL Query in Hindi

         4.DISTINCT Function in SQL in MS Access 2016 in Hindi

        5.LIKE,IN,Exists and NOT Condtiontion in MS Access SQL Query

        6. Having Command in SQl MS Access 2016 in hindi

        7.UNION ,UNION ALL in SQL in MS ACCESS 2016 in hindi

        8.INNER Join in MS Acess SQl in Hindi

        9.Insert Command in MS Access SQL in Hindi

        10.Update Comand in Access SQL in Hindi

        11.DELETE Command in MS Access SQL 2016 in Hindi

        12.Create Table,Drop Table and Alter Table in MS Access SQL in Hindi

    4.Form with MS Access 2016

        1. Create a Simple From with Botton in Ms Access 2016 in Hindi

        2.Modify and Choose Field in Simple Form in MS Access 2016 in Hindi

        3.Format ur Form in MS Access 2016 in Hindi

         4.From with 3 and more table in MS Access 2016 in Hindi

        5.Form Wizard in MS Access 2016 in Hindi

        Live Project with MS Access 2016

     5.Form_with_SQL

        1.Form Connect Query in Ms Access 2016

        2.use INSERT SQL Query in Form Button

         3.Show Data on Combo Box relavent State

        Live Project with Form

     6. VBA Macros Programming

        1. Introduction of VBA Macros in MS Access

        2. Data Type in MS Access VBA Macros

         3. Calculation with MS Access VBA Macros

         4.Functiona and Formulas in MS Access 2016

         Other Application Connectvity via VBA Macros

        New Formulas Creation with VBA Programming in Ms Access 2016

     5.Form_with_VBA in MS Access 2016

        1. Apply VBA Code in Form in MS Access 2016 in Hindi

        Event Handle in Form

         Picture and Object In Form

         Show Data on Form using Listbox

         Combo Box Automation

         Live Project

     6. Advanced Form in MS Access

        Concept of Userform in VBA

        TextBox , Lable, and Combo Box in VBA

         List Box Automation

         Filter Duplicate and Multi-Connection Listbox

         Multi Page, PDF and FLV , MediaPlayer and Other type of Emmbed Application

         Live Project

     7. Picture / Image Automation with VBA Macros

        Show Picure in Userform

        Chart Triks as image on Userform

         Show Google Image on Userform

         Dynamic Picture Automation

         Live Project with Picture Automation

     8. Database Conectvity and Other Application with VBA

        MS Excel Connectvity

        Notepad and Webdata Connectvity

         Embed Other Application

         SQL or Oracle Connectvity

         SQL Query in MS Excel 2016

         File & Folder Directory Access

         Live Project For Final Certification

     9. Report Creation

        Report with PDF

        Report With MS Word

         Report with HTML

         Live Project For Final Certification

     Course Duration & Fees

         6 to 8 Hours ( 4 Hours Sat to Sun)

        One to One Live Online Class

         Fees : - 3500/- (for 6 Hours) * This is Fast Track Course Fees if you want Expert Level Course the Choose Daily Class

* In Fast Track Course Not possible cover Details and Expart Leble Training

Enrol This Course Now

Sample Videos

Watch More

Advanced Excel & MIS Training Institute

Part of IPT (Institute of Professional of Training)
This is Group of Working Professianal Do Frelance with Us you can join our Class from your Computer using Gotomeeting

Operational Office : - Dakshinpuri, New Delhi - 110062
E-Mail - Kumar@iptindia.com, sujeetkumar.ipt@gmail.com, Skype ID - AdvExcel1

Mobile - +91 8802579388, +91 8826828093, +91 9968811487

         

Book Demo Class