Technology Driven IT Training Longstanding IT Technologists Computer Education Techniques
Distance-learning - MS Access: VBA Programming

Home

distance-learning center

Computer-Device_Tethered-Distance-learning Distance-learning-Building

Professional Distance-learning

IT Training Services



PCDBS03

MS Access: VBA Programming
DURATION: 3 days

FEE: $735

PRIVATE GROUP FEE: $
Based upon a class size of six students.

Scheduling can be adjusted to employee work hours and incorporate client assignments.

SMALL CLASS SIZE:
There is a surcharge associated with training two or fewer students.

AUDIENCE:

  • Business Professional
  • Database Administrator
  • Programmer
  • System Analyst
  • IT Professional
 
   

DATES:

CONTENT AND OBJECTIVES:
    1. Getting Started
      • Recognize the differences between a macro and program.
      • Create a macro to open a form and size it on the screen.
      • Create a pushbutton on a form and assign Open-table macro to the pushbutton.
    2. Event-driven Programming
      • Become familiar with the properties of a textbox and the events of a pushbutton.
      • Recognize the differences between top-down and event-driven programs.
    3. The Programming Environment
      • Show and hide Project Explorer and Properties Window.
      • Open and use the Immediate Window.
    4. Form Controls
      • Add controls to a form.
      • View and change properties of form controls and the form.
    5. Syntax Basics
      • Invoke a textbox to show property sheets.
      • Open the OnChange event handler window for a textbox.
      • Add extra space after the reserved word “Sub”; add the "Sub" to "sub".
      • Invoke the Run button to ascertain whether any error message is displayed.
    6. Variables, Arrays, and Constants
      • Declare a variable of integer type.
      • Assign the value 100 to an integer type variable.
      • Create an array for storing the names of weeks.
      • Print the 5th element of the array.
    7. Control Structure
      • Change the background color of a textbox to light yellow; if the value entered is less than 500.
      • Change the background color of a textbox to light blue, if the value entered is between 501 and 700.
      • Create buttons on a data bound form for navigating to first record, previous record, next record, and last record.
      • Create a loop to find the factorial of a number.
    8. Input/Output Features
      • Display the name of the current day of week on a form.
      • Change the caption of a pushbutton from "Show" to "Hide" each time it is clicked; this is known as a toggle button.
      • Prompt a user to enter a number in InputBox and if the user enters a number less than 500, display a MessageBox with a Stop sign icon with the message "Too low".
    9. Modular Programming
      • Create a sub subroutine and invoke it from the click event of a pushbutton.
      • Create a function to find the area of a rectangle which has a size of 10 by 15 feet.
      • Modify the function to receive the length and width of the rectangle as parameters.
      • Call a function from within another function.
    10. Custom Menu
      • Examine the windows style menu; use the Menu Editor to create a menu.
      • Assign keyboard shortcuts to menus; attach functions to the menu options.
    11. Text File I/O
      • Code a subroutine which creates a new file and writes the names of five locations to separate lines of the file.
      • Code a subroutine which opens the file and displays the names stored in the file in MessageBoxes.
    12. Debugging and Deploying
      • As part of the debugging process, comment out lines in a program to suppress them from executing.
      • Use the debugging facility to display values of variables.
      • Become proficient with the Step over and Step into features of the debugger.

 
 
    Web-based Training   Blended Learning    
Synchronous
Instruction
Asynchronous
Instruction
 

 

Effective February 27, 2012, the course dates listed on the SYS-ED schedules only will be available based upon approved and authorized user ID.

Copyright Acknowledgement: The software product(s) listed in this outline are owned and copyrighted by their respective companies. SYS-ED makes no representation regarding ownership in any of the software products that we train on.

SYS-ED courses are not intended for or open to the general public. They are intended for employees of Fortune 1000 companies, government municipalities, consulting companies, software, companies, healthcare providers. and mid-sized businesses. Individuals attending such courses will be required to execute a statement acknowledging that the employer will be paying for the SYS-ED course and that the employer has a licensed version of the software.