VBA school training courses in Albuquerque, NM (public, in-house or online)

Upon successful completion of this Lab, students will be able to:

work in the Visual Basic Editor and record macros
define the basic elements of a VBA object model and analyze VBA code
write new Sub procedures and modify existing procedures
create a UserForm and program its controls

Lab content

Lab Activity 1: Get started

What is VBA and why do I care?
The Visual Basic Editor
Don¡¯t make work
Try another macro in Excel
Lab Activity 2: Under...

Full archival course description>>

This course will introduce students who are familiar with Word, Excel or Access the basics of writing and debugging VBA code. VBA is Microsoft’s Visual Basic for Application and is the tool used to create custom macros and user-interfaces in the Office applications. Students will learn to define variables, create loops and branching statements, define functions, get user input and interface with the application of their choice. Students will need a copy of Microsoft Word, Excel or Access. A...

Full archival course description>>

This advanced Access 2010 training class targets people who intend to design databases at an advanced level and/or improve existing Access databases.

Class Goals
•Learn to manage Access 2010 relational databases.
•Learn advanced form customization techniques.
•Learn to optimize and administer Microsoft Access 2010.
•Learn to manage relational databases.

1.Visual Basic Editor A.Visual Basic for Applications
B.Object programming
C.The Object Browser

2.Programming basics A.Data basics
B.Scope of variables
C.Scope of procedures

3.Control structures A.Decision structures
B.Loop structures

4.Custom dialog boxes A.User forms
B.Events

5.Debugging and error handling A.Errors
B.Debugging
C.Error handling

Our trainers are industry and product experts that have mastered the use of each product in the field and enjoy teaching others how extract the maximum benefit from OEM product use at each students organization, big or small. Students learn from Industry experts with hands on product experience in multiple hardware and software environments and will benefit in the following ways.

Benefits of AMS Trainers
•The industries highest quality Computer Product Trainers for more than 4,000+ pro...

Full archival course description>>