PCDBS03

DATES:

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.

↓