Microsoft Access Training, Tutorials
 |
Microsoft Access 202
Intermediate Access 2
More command buttons, setting
values across forms, sorted combo boxes, form/subforms, and more.
74 Minutes. |
This class follows Access 201,
which we strongly recommend before taking this class. Access 201
covers all of the basic fundamentals and relational database concepts
that are key for this course.
We'll begin by
placing a command button on our customer form to show just the
contacts for the current customer. This will allow us to see all of -
say - Joe Smith's contacts.
Next, we'll learn how to make the combo box on our
contact form get its default value from the currently open customer
record. This will teach us how to get a value from a different form
using a new kind of naming notation. The benefit - we can create new
contacts without having to fill in the customer value.
We'll learn about the Tab Stop property -
so we can make our Tab Order skip over the first few fields and
go right to the Notes field when opened.
Next, we'll learn how to sort the company names in
our customer combo box by creating a sorted query to do the job...
...and then manually changing the combo box Row
Source property to get the values from the new query.
The result? A sorted list.
We will also teach you just a little bit of SQL
(Structured Query Language) and show you how to modify the row source
property without making a query to change that sort. We'll get
into more SQL in future courses - we just wanted to give you a taste
today.
We'll learn about more combo box properties, such
as the List Rows and List Width properties.
Next, we'll enhance our contact management system
by integrating a Callback feature into it. This way we can
generate a listing of any customers we have to call back. We'll start by
adding the necessary fields to our table and form.
We'll create a Callback List Form which is a
continuous form showing all of our callbacks - sorted by date. We can
click on one of them and then click on a button to open up either the
contact itself or the customer's record.
In the following lesson, we'll learn about
Subforms, which are forms that can go inside of other forms to show
related data (like showing the customer's last couple of contacts right
on the customer form). We'll start by designing a mini contact subform.
Then, we'll use the Subform Control to
place the subform inside of our main parent form.
We'll teach you how to hide certain fields (like
those ID numbers we don't need to see) with the Visible property.
In this lesson, we'll also give our Main Menu
a bit of a face lift. What we've had going so far was nice, but it's
starting to get cluttered, and lacks a certain professional tone. Let's
upgrade it a bit...
We will also see how to use the Phone
Autodialer so we can just click on a button and have our computer
dial the customer's phone number for us!
We learn several key concepts in this
course. Learning how to get values across multiple forms is a very
important concept. Also, we will be building many more form/subform
pairs in the future - especially when we get into our Order Entry
System. Don't miss this course.
Microsoft Access Training, Tutorials
Access 202 Course Outline
0. Introduction
1. Contact Button
Command button to open contacts for current customer
Find specific data to display
Viewing filtered results
2. Setting Values Across Two Forms
Using Forms!FormName!Field notation
Get CustomerID for Combo Box on ContactF
Setting the Tab Stop property
Skipping fields in the Tab Order
3. Sorted Customer Combo
Creating a sorted query with customer info
Manually editing the Row Source property
Modifying the Column Count property
Column Widths property
Column Heads property
SQL Primer
Modifying the row source with an SQL statement
List Rows and List Width properties
Lesson 4. Callbacks
Adding callback and date to table/form
Creating a callback query
Creating a callback form
Buttons on the form to open customer/contact
Lesson 5. Contacts Subform
Learning about subforms
Creating the contact subform
Using the subform control and wizard
Format > Send to Back
Hiding text boxes with the Visible property
Lesson 6. Miscellaneous
Editing our Main Menu
Replacing button images with text
Coloring text on buttons
Phone AutoDialer
Lesson 7. Review
|
