Free Lessons
Fast Tips
Topic Index
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
Courses - Microsoft Access 203
Description: Intermediate Microsoft Access 3
Running Time: 87 minutes
Pre-Requisites: Access 202 very strongly recommended
Previous Lesson: Access 202
Next Lesson: Access 204
Main Topics: Form Controls, ActiveX Objects, Tab Control, Bound OLE Objects
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 203
Intermediate Access 3

Option Groups, List Boxes, Toggle Buttons, ActiveX Controls, Tab Control, Bound v. Unbound Object Frames, more. 87 Minutes.

AC203 Major Topics

  • More Form Controls
  • ActiveX Objects
  • Tab Controls
  • Bound OLE Objects

This class follows Access 202, which we strongly recommend before taking this class. The main focus for this course is Form Controls. We'll cover all of the form controls we haven't covered in classes to date, including:

  • Option Groups & Option Buttons
  • List Boxes
  • Toggle Buttons
  • The ActiveX Calendar Control
  • Picture OLE Fields
  • Tab Controls
  • Bound & Unbound Object Frames
  • Image Control
  • Line & Rectangle Controls
  • And more.

We'll begin by creating an Extended Customer Table so that we can store additional information about our customers, but not take up space in our main Customer Table. There are several benefits to this technique, which I will explain in class.


Next, we'll create an Option Group to track each customer's Gender. We'll use Option Buttons for this.


We will then create a Customer Type List Box to track what type of a customer we're dealing with. This list of types will be user-defined and we'll create a separate table to track this information - so that you can add, edit, and delete the options.


Next, we'll play with the settings for our Option Group - colors and properties and such.

We'll then learn all about Toggle Buttons. We'll create a column of toggle buttons to indicate which services and products each customer buys from us. I'll also teach you a trick for assigning keyboard hot keys to these toggle butons.


In the next lesson, we'll do some more tricks with Combo Boxes. We've done a lot with Combo Boxes in previous classes, but there are a few more examples we need to cover. We'll add a Sales Rep combo box to our Customer Form, and a Service Tech combo box to our Extended Customer form. Both of these will be fed from our Employee table that we built in an earlier class. Why do it this way? You'll see in class.


Then we'll learn something really cool... how to place a special object called the ActiveX Calendar Control in our form. This will allow you to pick a date from a calendar and store that date in your table.


We'll make a Command Button next to open up the Extended Customer Form right from our Customer Form, so that we can see just the data for the currently open customer. No big deal - we've done this before when we were making our Contacts form, but this is a good review PLUS I'll show you how you can force this to be a one-to-one relationship and only have one Extended Customer data record for each customer record.


I'll show you how to use Hyperlink fields in your tables and forms so that you can type in a web page, click on it, and your web browser is automatically launched and you're taken right to that page.


Here comes a fun lesson... We'll learn how to create Tab Controls. You've seen them before (like if you click on Tools > Options in any Microsoft Office program like Word, Excel, or Access). Well now you'll learn how to put Tabs in your own Access Forms to save space and logically group related information.


Next we'll study Bound and Unbound Object Frames. We've seen before how to put a picture in an OLE field. We did that with our employee table and form. Now, I'll show you a few more tricks with Bound Object Frames to store pictures in your database. I'll also teach you how to Link to images on your hard drive from your database so you can still have the image available, but not waste space in your tables.


I'll also show you how you can use Unbound Object Frames to either store information directly in your forms, OR link to external data files such as Word documents or Excel spreadsheets so that your database users have quick access to commonly used files.


Finally, we'll round the course out by showing you how to add Images to your forms using the Image Control. We'll also cover the Line and Rectangle controls, Page Break Control, and more.


This is a great class if you'd like to really take your Access Forms to the next level. You'll learn how to use all of the controls in the Toolbox, and I'll teach you a lot of tips and tricks to teach you which tools to use and when.



Access 203 Outline
0. Introduction

1. Creating the Extended Customer Table
Building the table
Creating fields
Hyperlink field for Web Site

2. Using Option Groups
Option Groups
Option Buttons
List Box
Creating a Customer Type Table

3. Toggle Buttons
Toggle Buttons
Making a Check Box > Change To Toggle Button
Creating a Toggle Button manually
Changing Toggle Button Properties
Changing Option Group Colors
&Caption trick

4. ActiveX Calendar
Combo Box for Sales Rep
Combo Box for Service Tech
Picture OLE Field
Birthday ActiveX Control

5. Tab Control
Linking CustomerF to CustExtF
Tab Control

6. Object Controls
Bound Object
Pasting v. Linking Bound Objects
Unbound Object
Image Control
Boxes & Lines
Page Breaks
Force a 1-to-1 Relationship


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 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 5/18/2024 3:15:57 AM. PLT: 0s