刘杰Access课程介绍LP

Access - 数据分析及处理的原动力及发动机:

【Access & VBA 实战班】

深入、全面、翔实、专业的数据知识,可以助你在数据求职中脱颖而出、赢得offer!

5/5

课 程 特 色

刘杰老师的Access & VBA课程讲的深入浅出,适合所有层面、所有背景、所有目标的朋友深入学习数据知识及掌握数据本质

授 课 老 师 :JAY LIU

维多利亚数据学院 – 刘杰院长:计算机软件专业毕业,MCITP-DBA 2005/2008,拥有多年大型信息系统设计开发经验。曾经在中国主持设计开发超过1000个用户的大型政府部门办公自动化系统,AT&T全美联机系统的Senior Consultant,加拿大著名金融公司、银行及政府部门的Senior SQL Server DBA Consultant。擅长大型系统的设计,复杂数据结构的应用,企业级数据库系统的维护和开发。对于数据库系统理论及应用有精辟及独到的见解,所教授的SQL Server DBA及Access VBA 课程一直受到众多学员的好评。

COURSE OUTLINE

Class 1. Creating Access Database
1.1. Course Objectives
1.2. Database Fundamentals
1.3. Sample Data
1.4. Designing Tables
1.5. Access Database Data Types
1.6. Creating Tables
1.7. Primary Key
1.8. Building Relationships

 

Class 2. Handling Data in Access
2.1. Entering Data
2.2. Importing Data
2.3. Querying Data with SQL
2.4. Update, Insert and Delete
2.5. More Queries – Joining Tables

 

Class 3. Starting with VBA in Access
3.1. What is VBA – VBA Overview
3.2. Objects, Controls and Properties
3.3. Variables and VBA Data Types
3.4. Events and Action Procedures
3.5. If Blocks
3.6. Select Case Structures
3.7. Looping Structures
3.8. Dialog Boxes, List and Combo Boxes

 

Class 4. Forms
4.1. Creating and Modifying Forms
4.2. Unbound Controls
4.3. Graphics

4.4. Calculated Fields
4.5. Combo Box
4.6. Tab Controls
4.7. Subforms

 

Class 5. More Coding in VBA
5.1. VBA Coding Basics
5.2. Calculations and Data Manipulation
5.3. Presenting Data
5.4. Handling Errors, Logs and Messages
5.5. Debugging and Troubleshooting
5.6. Complete Data Maintenance
5.7. User-Defined Procedures and Types
5.8. Code Reusable
5.9. Using Array


Class 6. Using ADO in Access VBA
6.1. What Is ADO
6.2. How ADO Works
6.3. Managing Access Database by ADO
6.4. Manipulating Data with ADO
6.5. Accessing SQL Server
6.6. Managing Excel from Access


Class 7. Access Reporting
7.1. What is Access Reporting
7.2. Creating/Modifying/Printing Reports
7.3. Header, Footer and Grouping Data
7.4. Calculated Values Using Functions
7.5. Subreport
7.6. Delivery


Class 8. Introduction to Excel VBA
8.1. Excel VBA Basics
8.2. Macro v.s VBA
8.3. How VBA Works in Excel
8.4. Access VBA v.s Excel VBA

8.5. Making Calculations
8.6. Moving Data in and out
8.7. Conditions
8.8. Driving Events
8.9. Other Microsoft Office Controls

【学数据分析,就来维多利亚!实习就业有保障!】​


【维多利亚教育集团】Victoria Training Center

您的成功就业 从这里开始!

电话:416-665-1888

地址:250 Consumers Road, Suite 901, Toronto M2J 4V