Master of Access & Excel VBA


(更多资料和具体参加方法)
COURSE DESCRIPTION
This course is designed for beginning Access users to gain essential and practical skills of Database Application and Database Programming that can be used in day to day Business activities.
 
This course concentrates on basic Access concepts including tables, queries, forms, reports, basic VBA statements and programming skills, Jet SQL and ADO, and Microsoft Office Objects.
 
Upon completion of this course, students will be able to create, modify and work with tables, queries, forms and reports within Microsoft Access 2003; and build simple VBA projects to associate their special needs in Database development.
 
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
2.4. Update, Insert and Delete
2.5. More Queries - Joining Tables
 
Class 3. Starting with VBA
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. Coding in VBA
5.1. VBA Coding Basics
5.2. Calculations
5.3. Data Manipulation
5.4. Working Log
5.5. Presenting Data
5.6. Handling Errors
5.7. Error Logs and Messages
 
Class 6. More VBA Coding
6.1. Debugging and Troubleshooting
6.2. Complete Data Maintenance
6.3. User-Defined Procedures and Types
6.4. Code Reuse
6.5. Array
 
Class 7. Using ADO
7.1. What Is ADO
7.2. How does ADO Work
7.3. Managing Access Database by ADO
7.4. Manipulating Data with ADO
7.5. Accessing SQL Server
 
Class 8. Access Reporting
8.1. What is Access Reporting
8.2. Creating/Modifying/Printing Reports
8.3. Customizing Headers and Footers
8.4. Grouping Data
8.5. Calculated Values Using Functions
8.6. Embedded Subreport
8.7. Delivery
 
Class 9. Introduction to Excel VBA
9.1. Excel VBA Basics
9.2. How Does VBA Work in Excel
9.3. Making Calculations
9.4. Moving Data in Excel
9.5. Conditions
9.6. Driving Events
9.7. Data Transfer in and out
9.8. Other Microsoft Office Controls
 
Class 10. Maintaining Access Database
10.1. More Access Controls
10.2. Security and Permissions
10.3. Backup and Restore
10.4. Local-Standalone and Sharing
10.5. Considering Performance - Index
10.6. Clean-up
10.7. Automation
10.8. Course Review & What is Next
 
(更多资料和具体参加方法)
本页最后更新: | -- | 网站设计和虚拟主机服务 WECAN.ca CMS