Author Topic: USALaoTu 核心课 最佳入门课之一: Access and Excel 2010/13 & VBA 第四期 3/12 - 4/9  (Read 10953 times)

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3928
  • Karma: +35/-11
USALaoTu 核心课 最佳入门课之一: Access and Excel 2010/13 & VBA 第四期 (Core Package class)  8:00 - 12:00  Sunday 3/12 - 4/9
Dr. Laotu will teach you Access database.
北美在职业界Excel, VBA expert will show you skills of Excel, VBA.

This class will cover Access, Excel and VBA skills. Many Large Finance Institute and Banks are heavily using these skills.

This webinar meets 5 times.
Sun, Mar 12, 2017 8:00 AM - 12:00 PM PDT
Sun, Mar 19, 2017 8:00 AM - 12:00 PM PDT
Sun, Mar 26, 2017 8:00 AM - 12:00 PM PDT
Sun, Apr 2, 2017 8:00 AM - 12:00 PM PDT
Sun, Apr 9, 2017 8:00 AM - 12:00 PM PDT

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3928
  • Karma: +35/-11
First two classes will teach Access 2013/2016.
Third class will teach Excel 2013.
Fourth and fifth classes will focus on excel VBA.


Here is the outline of Excel and VBA class part:

EXCEL

Chapter 1. Introduction : Excel in a Nutshell

Introducing Excel objects

Chapter 2. Excel Fromula and Formmatting: Tricks and Techniques
   2.1 use Formulas
   2.2 Formatting basics
   2.3 Recording Marcos
   2.4 Project 1

Chapter 3. Excel Visual Basic for Applications (VBA) Fundamental
   3.1 Introducing VBE
   3.2 Variables, Data type and Constants
   3.3 Working with Sub Procedures
   3.4 Createing Function procedures
   3.5 VBA Programming Examples and Techniques
   3.6 Project 2 : A real project.

Chapter 4. Advance VBA: UserForms, Excel Utilities, Pivot Tables, Charts and Events.
   4.1 Working with UserForm (important)
   4.2 Advanced UserForm Techniques
   4.3 Excel Utilities        
   4.4 Working with Pivot Tables
   4.5 Working with Charts
   4.6 Understanding Excel's Events
   4.7 Interacting with Other Application
   4.8 Project 3

Starging with VBA to walk through the application developing process which hopefully will benefit you in the future when you decided to learn anohter programming language.

Excel is still a very useful tool for a lot of companies.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3928
  • Karma: +35/-11
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, 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 (2013, 2016) Integration
•   Open several  Access Databases
•   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
•   Configure ODBC for SQL Server Database connections
•   Import data from remote SQL Server database to Access tables
•   Create table relations, concept of table constraints
•   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 Two: Access and SharePoint, Reports, Forms  ( 4 Hours)
•   Introduction of SharePoint
•   Upload files to SharePoint Site
•   Link Access tables to SharePoint List
•   Export Access table date to SharePoint Lst
•   Import SharePoint List to Access Table
•   Move Access database tables to SharePoint Lists
•   Create Access Web Applications
•   Publish Access Web Application on Web
•   Access Reports
•   Import data from Remote SQL Server Database
•   Access Forms for different businesses
•   Develop a Patient Navigation Forms

Week Three: Excel in a Nutshell  ( 4 Hours)

Chapter 1. Introduction : Excel in a Nutshell

Introducing Excel objects

Chapter 2. Excel Fromula and Formmatting: Tricks and Techniques
   2.1 use Formulas
   2.2 Formatting basics
   2.3 Recording Marcos
   2.4 Project 1

Week Four: Excel Visual Basic for Applications (VBA) Fundamental  ( 4 Hours)

Chapter 3. Excel Visual Basic for Applications (VBA) Fundamental
   3.1 Introducing VBE
   3.2 Variables, Data type and Constants
   3.3 Working with Sub Procedures
   3.4 Createing Function procedures
   3.5 VBA Programming Examples and Techniques
   3.6 Project 2 : A real project.

Week Five: Advanced Excel VBA  ( 4 Hours)

Chapter 4. Advance VBA: UserForms, Excel Utilities, Pivot Tables, Charts and Events.
   4.1 Working with UserForm (important)
   4.2 Advanced UserForm Techniques
   4.3 Excel Utilities       
   4.4 Working with Pivot Tables
   4.5 Working with Charts
   4.6 Understanding Excel's Events
   4.7 Interacting with Other Application
   4.8 Project 3

Starging with VBA to walk through the application developing process which hopefully will benefit you in the future when you decided to learn anohter programming language.

Excel is still a very useful tool for a lot of companies.

USA LaoTu Support Team

  • Administrator
  • Hero Member
  • *****
  • Posts: 3928
  • Karma: +35/-11
Content of SharePoint is added into Access Excel VBA class:

Week Two: Access and SharePoint, Reports, Forms  ( 4 Hours)
•   Introduction of SharePoint
•   Upload different files to SharePoint Site
•   Link Access tables to SharePoint List
•   Export Access table date to SharePoint Lst
•   Import SharePoint List to Access Table
•   Move Access database tables to SharePoint Lists
•   Create Access Web Applications
•   Publish Access Web Application on Web
•   Access Reports
•   Import data from Remote SQL Server Database
•   Access Forms for different businesses
•   Develop a Patient Navigation Forms