好用的手机公司, 新年大促销: 3 month FREE! $15/Month 5GB data and text

Author Topic: Access and Excel 2010/13 & VBA 第三期 (Core Package class) 16:00 - 20:00 Sat 11/12  (Read 9114 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
Access and Excel 2010/13 & VBA 第三期 (Core Package class)  16:00 - 20:00 Start Sat 11/12/16 to 12/17/16 

Excel, Access, VBA skills are used in every companies, specially in large bank and insurance companies.
This course is opening to meet students demand.

After you find a high pay job as a database analyst, you want yourself to be armed with advanced Excel, Access and VBA skills as well.

Stunning reports and visualizations with Excel Power BI Desktop, advanced VBA programming and Basic Access  database are used  in most of big companies, especially in large bank and insurance enterprises.
 
Week One : Introduction - Install Access and Import Data ( 4 Hours)

•   Introduction
•   Excel &Access (2010, 2013) Integration
•   Excel: Spreadsheet Analysis & Reporting
•   Vlookup ( Hookups and Match Index) Function in Excel
•   Power of Access
•   Open a Blank New Access Database
•   Table Datasheet  View
•   Different Types of Data
•   Import an Excel Worksheet to Access
•   Linking an Excel Worksheet to Access
•   Lab1:Importing a Worksheet into a New Table
•   Lab2: Interview Test-How to Design a Dynamic Financial Quarterly Result Report by Using Excel Formula

Week Two: Query and Report in Access  ( 4 Hours)

•   Access Query
•   Select One Single Query From One Table
•   Select Query From Multiple Tables
•   Query Operation For Calculation
•   Define a Query For Report
•   Export a Access Report to Excel
•   Creating and Modifying Grouped Reports
•   Customizing Reports with Formatting
•   Page Layout Techniques
•   Lab1 Join Two Tables
•   Lab2 Use The Find Duplicates Query Wizard
•   Lab3 Find Unmatched Rows

Week Three:  Export & Data Connection in Excel ( 4 Hours)

•   From Excel link to Access
•   Exporting the Data from Access
•   Using the Get External Data Menu
•   Using Microsoft Query
•   From Excel link to SQL server, Oracle
•   Pivot Table and Chart in Access and  Excel
•   Lab1 Get Real Time Standard Excel Reports With Charts From Access-- Sales and Order Analysis

Week Four: Access Forms   (Video only for this Term)
Access Form
1.  Create a single form (bound/unbound). (Lab 1)
•   Create a form by from design.
•   Create a form by wizard.
•   Create a form by copy and paste
2.   Set a combo box control with a list of values (Lab 2)and a calculated text box control on a form (Lab 3).
3.   Create a form with an embedded sub-form (Lab 4).
•   Manually
•   By sub-form wizard
•   By form wizard
4.   Create a navigation form.
•   Three ways to set up a navigation form. (Lab 5)
•   Set the navigation from as default displayed form.
•   Add more mechanism for exploring purpose (Lab 6).

Week Five:  Design Macros and VBA Programming  ( 4 Hours)

•   Use Macros in Excel and Access
•   Lab1  Excel Macro for Absolute Reference
•   Lab2  Recording Macros with Relative References
•   Lab3: Excel Macro for DashBoard
•   Lab4  Macro for Formatting
•   Lab5  Macro for TopRep
•   Lab6  Lab Dashboard
•   VBA Code: Introduction -Basic for Applications (VBA)
•   What is VBA Procedure
•   Using VBA to Move Data Between Excel and Access
•   Module is an Object that Houses Code For The Workbook.
•   Lab7 VBA-Get Access Data into Excel
•   Lab8 VBA_GetData_from_Excel_sheet.
•   Lab9 VBA-Get Data_With_Database SQL Server

Week Six:  Automation Report , Power Query and Power BI Desktop

•   Learn How to Create VBA Programming for Search
•   Lab1  User Friendly Report with Automation  Chart
•   Lab2  Create My Search Macro Step by Step
•   Excel Add In Feature
•   Data Modeling : Excel 2013
•   PowerPivot  2013
* Power Query 
•  * Visual Analytic Dashboard and Visualization Tool by Using Power BI Desktop


(* The Most Popular Technology in Current Job Market)

Prerequsition:  None

Click here to register.
 


USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 4803
  • Karma: +35/-11
This webinar meets 5 times.
Sat, Nov 12, 2016 4:00 PM - 8:00 PM PST
Sat, Nov 19, 2016 4:00 PM - 8:00 PM PST
Sat, Dec 3, 2016 4:00 PM - 8:00 PM PST
Sat, Dec 10, 2016 4:00 PM - 8:00 PM PST
Sat, Dec 17, 2016 4:00 PM - 8:00 PM PST