 |
Please contact us
for GSA pricing
and CMAS pricing.
Contract #
GS-35F-0307T
Contract #
3-09-70-2645A
Recent Training Venues Accelebrate has recently trained for clients in the following cities:
- Huntsville, Alabama
- Montgomery / Birmingham, Alabama
- Anchorage, Alaska
- Edmonton & Calgary, Alberta
- Phoenix, Arizona
- Tucson, Arizona
- Fayetteville / Little Rock, Arkansas
- Amsterdam, The Netherlands / Brussels, Belgium
- Kamloops / Vancouver, British Columbia
- Oakland / San Jose / San Francisco, California
- Sacramento, California
- Oceanside / San Diego, California
- Pasadena / Orange County / Los Angeles, California
- San Bernardino / Riverside, California
- Boulder / Colorado Springs / Denver, Colorado
- Washington, DC
- Wilmington, Delaware
- Manchester / London, England
- Orlando, Florida
- Fort Lauderdale / Miami, Florida
- Gainesville / Jacksonville, Florida
- Saint Petersburg / Tampa, Florida
- Titusville & Melbourne, Florida
- Alpharetta & Atlanta, Georgia
- Augusta & Savannah, Georgia
- Macon & Columbus, Georgia
- Honolulu, Hawaii
- Boise, Idaho
- Bloomington, Illinois
- Chicago, Illinois
- Indianapolis, Indiana
- Cedar Rapids / Des Moines, Iowa
- Dublin, Ireland
- Wichita, Kansas
- Paducah / Lexington / Louisville, Kentucky
- Baton Rouge/New Orleans, Louisiana
- Portland, Maine
- Hagerstown & Frederick, Maryland
- Annapolis / Silver Spring / Baltimore, Maryland
- Boston / Cambridge, Massachusetts
- Hartford, Connecticut / Springfield, Massachusetts
- Ann Arbor / Farmington Hills / Detroit, Michigan
- Grand Rapids, Michigan
- Flint, Michigan
- Saint Paul / Minneapolis, Minnesota
- Jackson, Mississippi
- St. Louis, Missouri
- Whiteman Air Force Base / Kansas City, Missouri
- Lincoln / Omaha, Nebraska
- Reno and Las Vegas, Nevada
- Fredericton / Moncton / Saint John, New Brunswick
- Santa Fe / Albuquerque, New Mexico
- Princeton, New Jersey & Philadelphia, Pennsylvania
- Trenton, New Jersey
- Albany, New York
- Buffalo, New York
- White Plains / New York City, New York
- Charlotte, North Carolina
- Durham / Raleigh, North Carolina
- Bismarck & Fargo, North Dakota
- Halifax, Nova Scotia
- Bowling Green / Toledo, Ohio
- Canton / Akron, Ohio
- Cincinnati, Ohio
- Cleveland & Columbus, Ohio
- Dayton, Ohio
- Tulsa / Oklahoma City, Oklahoma
- Toronto, Ontario
- Portland, Oregon
- Pittsburgh, Pennsylvania
- Québec City / Montreal, Québec
- Providence, Rhode Island
- Saskatoon / Regina, Saskatchewan
- Edinburgh / Glasgow, Scotland
- Columbia & Charleston, South Carolina
- Spartanburg & Greenville, South Carolina
- Stockholm, Sweden
- Chattanooga / Knoxville, Tennessee
- Memphis / Jackson / Nashville, Tennessee
- College Station and Houston, Texas
- El Paso, Texas
- San Antonio / Austin, Texas
- Wichita Falls & Dallas, Texas
- Ogden / Salt Lake City, Utah
- Burlington, Vermont
- Fairfax / Dulles / McLean / Herndon / Reston, Virginia
- Richmond / Alexandria / Arlington, Virginia
- Virginia Beach / Norfolk, Virginia
- Tacoma / Seattle, Washington
- Charleston, West Virginia
- Madison / Milwaukee, Wisconsin
|
|
|
|
Access VBA Training: Introduction to Access 2007 VBA
|
Course Number: VBA-114
Duration: 1 day
view class outline
Access VBA Training Overview
Accelebrate's Introduction to Access 2007 VBA training course teaches experienced Access 2007 users how to automate Microsoft Access using VBA (Visual Basic for Applications).
Important Note: This course presumes that little or no time will be spent on your actual VBA projects. If you would like to include a day of time working on your actual VBA projects, please request the extended version of this course.
Location and Pricing
Most Accelebrate courses are taught on-site at our clients' locations worldwide for groups of 3 or more attendees and are customized to their specific needs. Please visit our client list to see organizations for whom we have recently delivered training. These courses can also be delivered as live, private online classes for groups that are geographically dispersed or wish to save on the instructor's or students' travel expenses. To receive a customized proposal and price quote private training at your site or online, please contact us.
In addition, some courses are available as live, online classes for individuals. To see a schedule of online courses, please visit http://www.accelebrate.com/online_training/?action=course&page=ACC301.
Access VBA Training Prerequisites
All attendees must be well-versed users of Microsoft Access 2007.
Hands-on/Lecture Ratio
This Access 2007 VBA training class is 70% hands-on, 30% lecture, with the longest lecture segments lasting for 20 minutes. Students "learn by doing," with immediate opportunities to apply the material they learn to real-world problems.
Access and Excel VBA Training Materials
All students receive comprehensive courseware and related textbook.
Software Needed on Each Student PC
This Access 2007 VBA training course requires:
- Microsoft Access 2007(full installation including Visual Basic Help) with the latest service pack applied.
Access VBA Training Objectives
All students will be able to:
- Use VBA within Microsoft Access 2007
- Query and interact with database data via ADO (ActiveX Data Objects)
- Debug VBA code
- Integrate Access 2007 with other Office 2007 products via VBA
|
Access VBA Training Outline
- Overview
- Visual Basic Editor
- Objects
- Object Browser
- Collections
- Programming basics
- Control structures
- Decision structures
- Loop structures
- ActiveX Data Objects
- Getting started with ActiveX Data Objects
- Working with ActiveX Data Objects
- VBA debugging tools
- Errors in code
- Debugging techniques
- Handling runtime errors
- Office integration
- Automating Office 2007
- Working with Word from Access
- Working with Excel from Access
- Conclusion
|
| |
Java® and all Java-based marks are trademarks or registered trademarks of Sun Microsystems, Inc. in the U.S. and other countries.
|
|
Accelebrate®
Focuses on You! |
|
Accelebrate’s courses are taught for private groups of 3 or more people at your site or online anywhere worldwide.
Don't settle for a "one size fits all" public class! Have Accelebrate deliver exactly the training you want, privately at your site or online, for less than the cost of a public class.
For pricing and to learn more, please contact us via information request form or phone, or email us at info@accelebrate.com today.
|
|
|
|
