Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
 
Home > Courses > Access > Templates > ABCD > Part 1 >
 
Access Business & Contact Database
By Richard Rost   Richard Rost on Twitter Richard Rost on LinkedIn Email Richard Rost   14 months ago


 S  M  L  XL  FS  Buy Now

Introducing the ABCD

The Access Business & Contact Database (ABCD) is designed to be a professional, full production-quality database to cover all of your information management needs. I have been building and teaching Access databases for over 25 years. Now, I'm finally building a solid, professional database system that you can use to run your business.

Parts

Resources

ABCD Part 1: Core

  • Entities (People, Organizations)
  • Multiple Phone, Address, Email Addresses
  • Helper Data (Prefix, Suffix, Title, Gender, Marital Status, etc.)
  • Entity List, Main Menu
  • Custom Entity Code

ABCD Part 2: Core

  • Helper Data Edit Popup Form
  • Helper Data Editor
  • Groups (Students, Employees, Parents, etc.)
  • Relations (Parent/Child, Co-Worker, etc.)
  • Automatic Reverse Relations

ABCD Part 3: Core

  • Misc Data (Shoe Size, Favorite Sports Team, etc.)
  • Required Misc Data
  • Free Text Entry or Pick From List
  • Admin Menu & Simple Security
  • Open Form Right
  • Group Editor
  • Slide Out Sections for Tabs

ABCD Part 4: Core

  • Sorting & Filtering the Entity List Form
  • Search on Helper Data Fields
  • Search on Related Data (Address, Email, Phone, etc.)
  • Search on Misc Data (Baseball Team, Rank, etc.)
  • Printable Report

ABCD Part 5: Core

  • Document Management
  • Create a Profile Picture
  • Select a File, Copy to Server Folder
  • Conditional Format Expiration Dates
  • Custom Image Thumbnails
  • Add Multiple Documents

ABCD Part 6: Core

The ABCD Part 6 is currently under development. Enroll now you can join in, watch videos as they're released, ask questions, and make suggestions!
 

ABCD Add-On Modules

After the Core package is finished, I will be releasing new Modules on a regular basis. These will be designed so that you can pick and choose which features you want and don't want in your database. Install only what you need. Some of these will include:

  • Contact Management
  • Letter Writer (Bulk Email, Print)
  • Task Management
  • Schedule & Calendar
  • Importing & Tracking Leads
  • Orders, Quotations, Invoicing
  • Recurring Memberships
  • Employee Time Tracking
  • Inventory & Barcoding

Plus, the ABCD will eventually have full enhanced search capabilities, split database options, possible cloud-based data storage, and full security to lock the database down. I'll be adding these and a lot more features - pretty much everything I've covered in my classes - to the system, eventually.

I'll even be adding custom Modules for specific vertical markets like insurance (tracking clients, leads, policies), automotive (vehicle & fleet maintenance), schools (students, attendance, grades), budgeting, and lots more. 

Videos

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.

Licensing

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.

Ordering

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. 

 

Part 6 Coming Soon Upload Images   Link  
Richard Rost 
2 months ago
Hey guys. I just wanted to let everyone know that I have been working on different stuff for the ABCD. I'll be releasing Part 6 in the next week or two.

A lot of projects that I have been working on as stand-alone databases are ALSO going to be integrated into the ABCD. For example, right now I'm putting the finishing touches on my Task Manager which is going to be released as a standalone template AND as an add-on for the ABCD.

Details in the comments...
Richard Rost
2 months ago

Richard Rost
2 months ago
There's LOTS of cool stuff in there, and it's the database I've been using to manage my own task lists for the past year or so. It's just one of the things that I'm planning on integrating in the ABCD. So hang in there. A lot more is coming. Part 6 is going to include a tool to split the database, auto-relink the tables, and even allow you to switch to a different data set (multiple sets of back-end tables, in case you run multiple companies). Full contact management is also going to be added - I can't really call it the Access Business CONTACT Database without that, right? LOL. Lots more too.
Richard Rost
2 months ago
And yes... that's Rick's Tree View - NOT the TreeView Control. You know I hate external controls. I built that sucker myself using a listbox. Super cool! Plus the "breadcrumb trail" on the top of the task window that says:

Root > 599CD > Courses > Access > ABCD

is completely functional too. You can click on it to jump to that branch of the tree. I put a lot of time in to this one.
Michelle Maughan
2 months ago
I can't wait! So excited to get back to the ABCD.
Juan C Rivera
2 months ago
Looking forward to this....
Richard Rost
2 months ago
Just built ANOTHER technology that's going to be going RIGHT into the ABCD... the ability for the database to realize that its backend tables have moved. When you start the DB, it will say "hey! Can't find the ACCDB file for this table. Where'd you put it?" Let you browse for the file, and auto-relink it. This is going to be the topic of today's TechHelp videos AND a Developer lesson. See... I've been doing LOTS of stuff for the ABCD. Just haven't put it all together into the ABCD yet. Coming soon...
Richard Rost
2 months ago
The Letter Writer I built in a TH video a little while ago... that's going in too. Part of the "Contact" management part.
Antony Lee
2 months ago
Cant wait!!
JoAnn Brookover
30 days ago
Most of the tutorials I have found online are not complex enough for my needs. Your videos are challenging and really helpful. I am building a database for a cemetery and your ABCD/Tech Help videos have been amazing! I know you have lots more stuff planned for the ABCDatabase. I hope you will have modules on invoicing and bank accounts/check registers somewhere down the road. Live long and prosper!
Juan C Rivera
28 days ago
Richard I just agdded a comment on data collections.  updating help tables from responding emails.  Can you include into the ABC?
Richard Rost
25 days ago
JoAnn: thank you. And yes, there will be a lot of financial stuff added as modules later.

Juan: yep. :)
Alexis Cao
18 days ago
it has went gone for 35 days, Dear Richard. you still not update the Part6. i'm still waiting for it, due to i need it. waiting.....
Richard Rost
14 days ago
Workin' on it.
Add a Reply

Show All Comments

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.
 
Subscribe
 

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

12/4/2021Hangman!
12/3/2021Access Beginner 2
12/3/2021Access Beginner 2 Lessons
12/3/2021Access Beginner 2
11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close
11/28/2021Random
11/22/2021Currency Symbols
11/13/2021Access Developer 36
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: ABCD access business contact database  PermaLink