Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 
Courses - Microsoft Access 202
Pre-Requisites: Access 201 very strongly recommended
Description: Intermediate Microsoft Access 2
Running Time: 74 minutes
Previous Lesson: Access 201
Next Lesson: Access 203
Main Topics: Command Button, Tab Stop, Tab Order, SQL Primer, Subforms, Visible Property
Versions: This course is valid for Access 2000 through 2003. If you are using Access 2007 or 2010, you will still benefit from this course. You will find that the concepts are the same, but there are cosmetic differences between the versions.

    

Order before 11/24/2019 to get a FREE upgrade to our Access 2010 version!
Click here for details

 
Microsoft Access 202
Intermediate Access 2

More command buttons, setting values across forms, sorted combo boxes, form/subforms, and more. 74 Minutes.
 

AC202 Major Topics

  • Button to Show Specific Record
  • Tab Stop, Tab Order Properties
  • Sorted Combo Boxes
  • SQL Primer
  • Form / Subform Relationships
  • Visible Property

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.


 

 

Access 202 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
 


Try a FREE Demo Lesson

 
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP