Free Lessons
Fast Tips
Topic Index
Home   Courses   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
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.

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



The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
My Account
My Courses
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

Copyright 2023 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 12/4/2023 9:47:24 PM.