Training Course:Access 2003 VBASchool/Trainer:Complete Computing Inc.
Little Rock, Arkansas, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This four-day instructor-led course begins with the programming life cycle, the Visual Basic Editor environment, and essential programming concepts. Each day, students will move through object-oriented programming concepts, learn to retrieve and update data with ADO, use VBA to create reports programmatically, export Access data to various Web formats, and migrate an existing Access database to an Access project that uses SQL Server®. Students will also learn advanced topics such as working with external DLLs, handling security, creating transactions, and creating custom code libraries. Students will also learn how to distribute their applications by studying two case studies - a project tracking application and a customer service application.
Audience
This course is designed for Access users and programmers who have created databases that include tables, forms, and possibly macros. No prior experience with VBA is required.
At Course Completion
After completing this course, students will be able to:
Object-oriented programming techniques using VBA
How to use built-in objects and create your own
How to use ActiveX Data Objects (ADO) to retrieve and update data
Methods for creating reports and Web content from the database
Techniques for integrating with Office applications
How to build SQL Server solutions with Access projects
Prerequisites
Students taking this course should be familiar with personal computers and the use of a keyboard and mouse. Furthermore, this course assumes that students have completed the following courses or have equivalent experience:
Operation understanding of Microsoft Windows XP
Understanding of Microsoft Access 2003
Course Materials
The student kit includes a comprehensive and award-winning textbook and other necessary materials for this class.
Course Outline
Chapter 1: Introduction to Access 2003 VBA
Chapter 2: The Basics of Writing and Testing VBA Code
Chapter 3: Programming Applications Using Objects
Chapter 4: Creating Your Own Objects
Chapter 5: Interacting with Data Using ADO and SQL
Chapter 6: Building Interactive Forms
Chapter 7: Importing, Linking, and Exporting Using External Data Sources
Chapter 8: Creating Reports and Web-Enabled Output
Chapter 9: Building SQL Server Applications with Access Projects
Chapter 10: Advanced Access Programming
Chapter 11: Finishing the Application
Chapter 12: Case Study 1 �Project Tracking Application
Chapter 13: Case Study 2 �Customer Service Application
...''
Please go to the school's official website for training price and schedule:
http://www.complete.com
http://www.complete.com/Training
Phone:(800) 880-2949
School Address:
Complete Computing, Inc.
400 West 7th Street
Little Rock, AR USA 72201
Jobs & Resumes: Little Rock
Houses & Roommates: Little Rock
Other training courses offered by Complete Computing Inc.:
Adobe Acrobat 7.0 Combo
Adobe Acrobat 7.0 Lev 1
Adobe Acrobat 7.0 Lev 2
Adobe Illustrator CS
Adobe InDesign CS
Adobe PageMaker 7.0 Lev 1
Adobe PageMaker 7.0 Lev 2
PhotoShop CS
Microsoft Access 2003
Microsoft Excel 2007
Excel 2003
Outlook 2003
PowerPoint 2003
Microsoft Word 2003
CorelDraw 11: Lev 1
CorelDraw 11: Lev 2
Crystal Reports XI
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
ASKEDU jobs and talents message board can help you find jobs related to your experience in a specific city, or hire somebody in place with particular knowledges. |
|
|
