Lessons

Resources

Questions?

Please feel free to post your questions or comments below. If you have questions about a specific lesson, please specify the lesson number and the time index in the lesson where the issue occurs. Thank you!

Subscribe for Updates

If you would like to be notified whenever changes are made to this page, new lessons are posted, or comments are made, click on the subscribe button.

Subscribe to Access 203
Get notifications when this page is updated

Intro

In lesson 203, you will learn how to create an extended customer data table and form in Microsoft Access to store supplemental customer information without cluttering your main customer records. I will show you how to use a variety of form controls, including option groups, list boxes, toggle buttons, the ActiveX calendar control, tab controls, bound and unbound object frames, image controls, page breaks, lines, and boxes. This lesson builds on the previous Access courses and focuses on organizing customer data with more advanced form design features.

Transcript

Welcome to Microsoft Access 203 Intermediate Microsoft Access, brought to you by 599cd.com. I am your instructor, Richard Rost.

Let's go over the objectives for today's class. Today we are going to cover extended customer data. We have got a customer table and a customer form, but we want to be able to store a whole bunch of other supplemental information about our customers. We do not want to clutter up our customer form or take up extra room in our customer table.

We are going to make an extended customer data table and form, and that is going to allow us to learn all kinds of new controls. We are going to learn about all the other controls in its little box: option groups, option buttons, list boxes, toggle buttons. We will see how to use the ActiveX calendar control, tab controls, bound and unbound object frames, image controls, page breaks, lines, and boxes. That is pretty much everything in its little box.

Now, this class follows Microsoft Access 202. I do strongly recommend that you have taken 202, 201, and all the 100-level Access courses. You will get the most out of this course if you go through all the courses step by step and build the database with me. Do not just use my databases. You will get a whole lot more out of it.

In this class, we will be using Microsoft Access XP 2002 edition and Windows XP; however, you should be able to use this lesson regardless of what Access version you have. 97, 2000, and 2003 should all work pretty much the same.

Sit back and watch the lessons one time through. Get the gist of what I am trying to cover, and then go through it again, following along step by step. Build the database yourself. I cannot emphasize how important that is.

The database files have been included along with your course. You should find them in this folder here: C program files 599 Access 2003 help. You can also find them by clicking on the help button in the video player. If you cannot find them, you can also get them off of our website: 599cd.com/access/203. That is a special site I set up for this class.

Quiz

Q1. What is the main purpose of creating an extended customer data table and form in this course?
A. To store additional customer information without cluttering the main customer form and table
B. To replace the primary customer table entirely
C. To create duplicate records for backup purposes
D. To enhance database security by splitting tables

Q2. Which types of controls are covered in this Microsoft Access 203 course?
A. Only text boxes and combo boxes
B. Option groups, list boxes, toggle buttons, and others in the toolbox
C. Advanced coding controls only
D. Controls specifically for report design

Q3. What specific control is mentioned as being demonstrated in this course?
A. ActiveX calendar control
B. OLE automation control
C. Script editor control
D. Advanced sorting control

Q4. Why does the instructor recommend building the database step by step instead of just using the pre-made databases?
A. To practice typing skills
B. Because the sample files do not work
C. To get a better understanding and more learning benefit
D. Because Access cannot open downloaded databases

Q5. Which versions of Microsoft Access does the instructor say are compatible with the techniques taught in this class?
A. Only Access XP 2002
B. Only Access 2000 and newer
C. 97, 2000, 2002 (XP), and 2003
D. Only Access 2010 and newer

Q6. Where can students find the database files needed for this course?
A. In the C program files 599 Access 2003 help folder, from the help button in the video player, or at 599cd.com access 203
B. Only from Microsoft official support
C. By emailing the instructor directly
D. By searching for third-party downloads online

Q7. What is the recommended way to approach the lessons in this course?
A. Watch once for overview, then follow along step by step building the database
B. Only skim through the topics briefly
C. Jump to the final lesson to see the results
D. Only read the handouts provided

Answers: 1-A; 2-B; 3-A; 4-C; 5-C; 6-A; 7-A

DISCLAIMER: Quiz questions are AI generated. If you find any that are wrong, don't make sense, or aren't related to the video topic at hand, then please post a comment and let me know. Thanks.

Summary

Today's video from Access Learning Zone focuses on extending customer data in a Microsoft Access database. In our existing setup, we already have a customer table and a customer form. However, sometimes we need a way to store additional, supplementary details about our customers without jamming too much information into our main customer table or cluttering the main customer form.

To address this, I will be showing you how to create an extended customer data table along with a dedicated form for entering and viewing this supplemental information. Doing this also presents the perfect opportunity to explore a wide range of form controls that you may not have used before. You will learn how to work with option groups, option buttons, list boxes, and toggle buttons. I will be demonstrating the ActiveX calendar control, as well as using tab controls, bound and unbound object frames, image controls, page breaks, as well as lines and boxes. Essentially, we will cover just about everything that comes in the toolbox for Access forms.

This class builds directly on what was covered in Microsoft Access 202. I strongly recommend completing Access 202, 201, and all the 100-level Access courses to ensure you get the most benefit from this material. It is best to follow along step by step and create the database together with me, rather than simply using my completed databases. The hands-on practice really makes a difference in how well you understand the material.

For this course, I am using Microsoft Access XP 2002 Edition and Windows XP. That said, the techniques covered here should apply to most recent versions of Access, including 97, 2000, and 2003, with very little difference.

My recommendation is that you first watch the lessons all the way through to get a sense of the entire process, and then review the videos a second time while working alongside, step by step, building your own copy of the database. This kind of repetition and hands-on work is key for real understanding.

You will find all the necessary database files included with your course materials. Look for them in the suggested folder path on your computer, or, if you need to, you can visit my website to download them using the Access 203 page I have set up for this class.

You can find a complete video tutorial with step-by-step instructions on everything discussed here on my website at the link below. Live long and prosper, my friends.

Topic List

This is an introductory overview for a Microsoft Access intermediate course, providing information about the objectives and topics that will be covered in the full tutorial.