This class continues our look at programming in Visual Basic for
Applications in Microsoft Access (VBA, or Access VB). We're
going to begin by building a form that we can use to search
between dates. We've done some work with sorting and
query criteria in the past, but in this lesson we'll put a new twist on
it. You'll be able to select "before," "after," or "between" from a
combo box and then filter the list accordingly.

In the next lesson, we're going to build
a form to calculate the tuition for students in a
private school. The tuition can be based on many factors including their
grade level (K-12), any applicable discounts (parent is a teacher), or
the number of children that family has in the school.

We'll set up properly normalized
relational tables to track the different possible options so
that we can calculate the correct tuition for each student. This example
would be the same regardless of the kind of business you're running. If
you're in retail, think of it like selecting products
that have multiple options (a shirt that can come in multiple sizes and
colors, for example). We'll take a non-relational spreadsheet with many
options like this...

Then we'll fix it and
set up the data in a way that Access can understand. A lot of you have
asked me for more examples on taking crazy spreadsheet
data and normalizing it. Here you go...

Finally, we'll build a Pricing
Wizard form where we can select the Grade Level, and then only
the corresponding Tuition Levels will show up. Pick that, and only the
appropriate number of children available will show up. Pick that and
then the proper tuition is displayed. Think of this like
selecting a specific shirt, and then only the colors that are
available for that shirt are displayed. Pick that, then the available
sizes are displayed. Get it?

This is the 13th class in the Access Developer series. If you're
serious about building quality databases with Access, and you want to
learn how to automate your database with VBA Programming then don't miss out on
this course. Of
course, if you have any questions about whether or not this class is
for you, please contact me.

Complete Outline - Access Developer Level 13

|