|
Lessons & Projects |
Projects,
Slides, & Videos |
-
Lesson 1
Introduction to
Data Entry (Chapters 1-3)
|
|
-
Lesson
2
Data Entry
Parts 3 & 4: Introduction to Variables &
formatting strings (p. 141)
|
-
Creating our master MDI application
-
Learning about variables
demo
-
Data Entry
Part 3
-
Data Entry
Part 4
|
-
Lesson 3
More on variables, keystroke trapping,
running totals & Other cool stuff
(Chapter 4)
|
-
Using List Boxes & Dynamic Properties
- Learning about
Running Totals & Counting
-
Ron's Pet Store Demo
(includes my images)
-
Trapping
Keystrokes
example
- Trapping
Keystrokes note:
A KeyPress event can involve any printable
keyboard character, the CTRL key combined with a
character from the standard alphabet or one of a
few special characters, and the ENTER or
BACKSPACE key.
Use KeyDown and KeyUp
event procedures to handle any keystroke not
recognized by KeyPress, such as function keys,
editing keys, navigation keys, and any
combinations of these with keyboard modifiers.
|
-
Lesson 4
Making Decisions (Chapter 5) & Custom Event
Handlers, & Loops (p.146)
|
Making Decisions
Using if Logical operators: If
part 2
Using
Switch
- Trapping Multiple Controls
Using
one event handler to trap three
Radio Button click events
- Midterm
exam covers all material up to this point
______________________________
|
-
Lesson 5
File I/O, Try-Catch, Custom Subs,
StreamReader, and StreamWriter (Chapter 21)
|
-
Introduction to File I/O
(Page
662)
- Structured
Error Handling
(Page 190)
Slides
Load List Box from a disk file
project:
Using Stream Reader &
Stream Writer
Videos:
Part 1
Read
from disk file
Part 2
List box Add/Delete
Part 3
Write to
a disk file
|
-
Lesson 6
Custom Functions,
properties & Classes
(Chapter 12)
|
-
Object-Oriented Programming Techniques
-
Methods
-
Working with
Properties
- Classes
|
My DB Resources Page
This page is designed to support
database programming lessons for Access and SQL. |
-
Lesson 7
SQL
Express DATA
BASES I (Using the ADO Objects & Wizards)
|
|
-
Lesson 8
SQL
Express DATA
BASES II (ADO in Code- Chapter 20)
|
-
My first SQL project using
ADO in code
Get
my Database for
this lesson(customers-05)
ADO in code using a grid control
|
-
Extra Projects
Some useful projects.
|
|
|