Computer Learning Zone CLZ Access Excel Word Windows

It is impossible for a man to learn what he thinks he already knows.

Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > ABCD > Part 3 < Part 2 | Part 4 >
ABCD Core Part 3

Access Business & Contact Database Part 3

Welcome to ABCD Part 3: Core. Total running time is 4 hours, 27 minutes.

 S  M  L  XL  FS  |  Slo  Reg  Fast  2x  |  Bookmark Buy Now



Starting off working with Misc Data. This is all of that "extra" stuff you want to collect about people, but you don't necessarily want to put it in the EntityT. For example: shoe size, favorite baseball team, nickname, etc. In lesson 1 we'll build those tables. In lesson 2, we'll make it so specific items are required, so if you want to get shoe size from everyone, it will show up there automatically and cannot be deleted. We'll also make it so you can pick from a list of helper data items to provide that data. Lesson 3 allows you to force the user to pick from the list of items, and we'll design the Misc Type Editor form. In Lesson 4 we create an admin menu and add some simple security, make helper lists system values, and add the OpenFormRight function. Lesson 5 we add a group editor and the address block for copy/paste. Lesson 6 is lots of little housekeeping items: force email to be the first tab displayed, show current age next to DOB, HowLong function, make the first email, phone, and address entered set to primary, set the focus on new records in the entity subform, create a SwitchTabs function, and hide flashing with the Echo command. Lesson 7 builds slide-out form sections for the EntityF and EntityListF.

Database Files

I'm only posting the 32-bit versions for now. That's what I use. If you are using 64-bit Access, just create a new blank database file and import all of my objects into yours. I'll post a 64-bit version when the Core is finished. If you experience any code that doesn't work under 64-bit let me know. Click here for more information about 32 v 64 bit.


Learn More

Enroll Today!

Enroll now so that you can watch these lessons, learn with us, post questions, and more.


I am recording videos showing how the database is built, but mostly so that you can understand the construction and be better equipped to make any modifications or additions you may need on your own. This will be marketed as a finished database without the need for any enhancements, but, of course, one of the main reasons to use Access is so that you can make changes yourself. The videos will be a quick run-through of how each feature is built, as I'm building it. I will be using advanced features like SQL and VBA from the start, so you may want some SQL or VBA Developer Lessons under your belt if you're going to try to follow along. This is NOT a teaching database. Free Technical Support will NOT be offered.

Tech Support

There is NO free Technical Support provided on the ABCD if you have not taken ALL of my previous Developer lessons. There are a lot of very difficult, advanced programming concepts used in the construction of this database. I do not have the time to provide free support if you get stuck trying to make modifications. All I will do is point you to the appropriate Developer lesson(s) that cover the issue. There is a reason why (a) I say this is NOT a teaching database, and (b) there are pre-requisites. Feel free to ask questions, but I can't spend half an hour explaining concepts that are already covered in my other lessons.


Unlike my other courses and seminars which provide you with royalty-free databases that you can modify and distribute yourself, the ABCD does NOT come with a royalty-free license. You may only customize the database for your business needs and for use within your organization. You may not resell or distribute it to others without express written permission. In addition, if you are using it in an organization with more than 10 users, you must purchase additional licenses. Contact me for additional information. I will post additional details when the Core database is completed.


There are two purchase options available for the ABCD.

  • You can purchase a fully editable and customizable copy of the database in addition to the video tutorials that show how it was built. This is the option you should pick if you want to make changes to the database for your own business needs, and you want to learn how the database was constructed to assist you. As a reminder, these are not teaching videos. They are simply provided to show you how the database was built. Free support is not guaranteed if you have questions. I do my best to answer questions, but I can't promise anything. You must purchase any pre-requisite parts or modules required. For example, you may not purchase Core Part 4 without first having parts 1 thru 3.
  • Once the Core is finished, you can optionally purchase a use-only version of the database. This is the best option if you only plan on using the database for your personal or business needs, but do not intend on modifying the structure of the database. Free instructional videos will be provided to teach your staff how to use it.

Your Feedback

I will be releasing new Core features and modules on a regular basis. You can see the list of features that are scheduled for development on the Coming Soon page. I would very much like your feedback on what features you think should be available. If you have a specific interest for your business type, let me know. 


Fabulous Stuff Upload Images   Link  
Chris Bezant 
10 months ago
Hello Rick
Just a quick note to say a big thank you for making these videos available. A major part of my Christmas/New Year period has been watching them. It is really enjoyable watching you work and following the thinking. It is a Privilege to watch you in action. I look forward to the rest of the core. Read More...
Richard Rost
10 months ago
I'm glad you're enjoying a trip inside the mind of a madman. :)
Michelle Maughan
10 months ago
HaHaHa, we all must mad! That's how i spent my time too and loved every minute!
Add a Reply
ABCD Part 3 Lessons 4 to 6 Upload Images   Link  
Richard Rost 
11 months ago
More work done on the ABCD including a group editor, some simple admin security, and lots of housekeeping items.
Julian Okolonji
10 months ago
Hi Richard,

I just realised that when I use the edit button on the GroupListF I'm able to delete a Helper Value but I can't add to it. I then realised that it shows up on the HelperT but with no HelperTypeID, I have to manually input the HelperTypeID before it shows up on the GroupListF. Please how can I solve this problem?

Many thanks in Advance
Add a Reply
ABCD Part 3 Lessons 1-3 Upload Images   Link  
Richard Rost 
11 months ago
I'm on a roll. Another 90 minutes of video posted today for the ABCD. Designed the Misc Data section. What's that? Check out the ABCD3 page to find out.
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
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
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: access ABCD 03 part 03 core  PermaLink