Access and Excel 2010/13 & VBA 第一期 8:00 Sun 03/15 to 04/19, Total 24 Hou

[USA LaoTu Support Team]

Access and Excel 2010/13 & VBA 第一期 8:00  Sun  03/15 to 04/19, Total 24 Hours

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.

The teachers are Excel Access and VBA Expert with many years Database Analyst experience in USA companies.

Course Outline
Week One: Introduction -Install and Import ( 4 Hours)
•   Introduction
•   Excel &Access 2010 Integration
•   Excel: spreadsheet analysis & Reporting
•   Vlookup ( Hookups and Match Index) Function in Excel
•   Power of Access
•   Open a Blank 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- Dynamic Excel Report

Week Two: Query and Report  ( 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
•   Select command buttons opens a dialog box
•   Creating and Modifying Grouped Reports
•   Customizing Reports with Formatting
•   Page Layout Techniques
•   Pivot table and chart in Excel
•   Lab1 Join Two Tables
•   Lab2  Use The Find Duplicates Query Wizard
•   Lab3 Find UnMatched Rows

Week Three:  Export and PV Table 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
•   Lab Get real time standard Excel reports With charts from Access-- Sales and Order Analysis


Week Four: Access Forms
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:   Macro and VBA  ( 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_Databaswe SQL Server

Week Six:  Automation Report , PowerPivot and PowerView

•   Learn how to create your own VBA program for Search
•   Lab  User friendly report with Automation  chart
•   Lab  My Search Macro step by step
•   Excel Add in feature
•   Data Modeling : Excel 2013
•   PowerPivot  2013
•   Powerview and Dynamic Dashboard

Prerequsition:  None.
Price: Will publish soon.

[USA LaoTu Support Team]

Access Excel 2013 & VBA  Start on 03/15/2015
Early bird price: Register before 03/08/15


$1242 for general public
$977 for student paid $999
$415 for Core 2013 student (paid $2999)
$349  for Core 2013 + MSBI2012 student (paid $5199)

[Firedragon]

Isn't this class included in the Core Package classes?

[如月]

这个 Access and Excel 2010/13 & VBA 课程 和 Core Package classes 里的 Access 2007 不一样， 有很多新加入的内容， 所以是不包括的

[USA LaoTu Support Team]

USA LaoTu 课程设计以找工作为中心目标, 老师们把工作中最常用的技能用最直接的方法展示给学生.
2009 年, Bobcat 同学只学了Access2007 一门课, 就成功转行找到大银行的好工作.详情请看视频:242th 美国老土 专业求职辅导周会, 听Bobcat 同学给你分享经验.

After gain skills from our Access Excel VBA 2013 class, student can qualify following job in large companies.
Yes, this is a job opening right now, send your resume if you have the skills.

Access developer :  VBA

Developing  use VBA Visual Basic for Applications in both Access and Excel.
This is a project within a large company. This group is tasked with looking at all new product that is to be manufactured and running cost analysis.

1. Taking existing financial data (capital expense and labor cost) and developing a database in Access to better extract information and make it more manageable for group members.

2. Gathering data from engineering manager and supervisors on manufacturing process and cost drivers and building it in to database.

3. Developing easy to use formular and database for other managers/supervidor to run thrie numbers.

4. Working with our Sr. manufacturing database engineer to develop new database for other smaller projects.

• Use Interface forms design in Access
• Table design with referencial integrity
• Report design in both Access and Excel
• Chart design in Excel
• Export SQL knowledge
• Queries using query design grid
• Active X (formally Object Linking ans Embedding...used to control Excel through code in an Access module).
• VBA (Not Access macros...there is a difference).
• DAO (used for creating record sets and tables through code)

[胜似闲庭信步]

请问老师这个课程还开吗？要是还开，什么时候？多谢。

[USA LaoTu Support Team]

Yes, we will.
New student can access previous class video immediately.
This Sunday will have the 6th class talk about VBA, very exiting stuff.

Will open another online class later.
Please watch our class schedule later.

[USA LaoTu Support Team]

Access Excel VBA 2013 课程昨天结束,　讲课老师们很有经验,　同学们拿到了很多在工作中天天都要用的好东西.　
现在报名的同学,　立刻就可以看录像,　以后上课可以再来听.