USA LaoTu 高薪转行做数据第一平台
只要你有颗求变的心并愿意行动，到这里来，必使你得改变！成千聪明华人循此捷径高薪进入大公司！ => 注重实战的教学作风 新开课程 时间内容 => Topic started by: USA LaoTu Support Team on June 09, 2015, 06:29:09 PM
-
Access and Excel 2010/13 & VBA 第二期 (Core Package class) Feb 2016 Total 24 Hours
Total 24 Hours 8:00 to 12:00 Noon (USA PST) Sunday
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
$1242 for general public
$977 for student paid $999
(http://www.usalaotu.com/student/register.php)
-
老师，我看您写的Core Package Class，现在是CorePack的同学可以修的吗？因为看到第一期是不包括在CorePack里面的。
-
New student can see the class name listed on their log in page.
-
How new is considering "new"? I am a core package student and have not take the live class yet. Am I qualify for the live class? :)
-
Core Package student suppose to watch class video. NOT join online class.
We had Access Excel 2013 & VBA class in 2015-03-15, student wanted to join online class had registered and took that class.
-
I registered core package class in 2014,can I watch this video?
-
I registered core package class in 2014,can I watch this video?
I guess we all cannot, and we don't have the video for this class. :'(...
-
Laoshi, when will the class start?
-
Plan to start in October.
-
Access &Excel 2013 VBA 第二期, (Core Package class) Feb.2016
-
课程试听: Our real class video use our own video server with bigger screen, not use Youtube.
试听 Access 2013 第一堂课:
http://www.usalaotu.com/forum/index.php?topic=5867.0
-
老师，这个课改日期了吗？ 昨天看是11月的
-
Yes