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.
CONTENT AND OBJECTIVES:
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.
Become familiar with the properties of a textbox and the events of a pushbutton.
Recognize the differences between top-down and event-driven programs.
The Programming Environment
Show and hide Project Explorer and Properties Window.
Open and use the Immediate Window.
Add controls to a form.
View and change properties of form controls and the form.
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.
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.
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.
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".
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.
Examine the windows style menu; use the Menu Editor to create a menu.
Assign keyboard shortcuts to menus; attach functions to the menu options.
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.
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.
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.