ABCD Part 1: Core Database

Welcome to ABCD Part 1: Core. This is the foundation of the database. We will construct the tables and forms necessary to store information about people, organizations, and companies (called Entities). Each entity can have an unlimited number of phone, email, and physical addresses. We will use Helper data tables to store all of the minor information like name prefixes, suffixes etc. so that we don't clutter the database with dozens of tiny tables. We will create a function to assign EntityCode values to each person so we don't expose our AutoNumbers. Total running time is 3 hours, 27 minutes.

S M L XL FS | Slo Reg Fast 2x

Lessons

Database Files

FREE Version (ACCDE)
PAID Version (ACCDB)

Resources

ABCD Home Page
Video Lessons Download ZIP File (coming soon)

Learn More

Free Access Beginner 1
Not Exposing Data to Customers (reason for the EntityCode)
Why AutoNumbers are Good
Access Expert 1, Expert 2, and Relationship Seminar
Access Developer 1 for VBA Beginners
ZIP Code Lookup Template
Access Insider Circle
Random Numbers
DLOOKUP Function

Questions

Post your questions or comments below

ABCD Addressee Lines Link
Richard Wilson

4 days ago

Rick, I have built a database with several hundred academic institutions in it. The addressees would be Name, University, School/Department, Department, Street1, etc. There may be as many as four or even five different Addressee lines. I know that is customizable, but I hope you are going to show us how to fill those lines without having to type them in every time.

Richard Rost

2 days ago

My thinking is that the Addressee lines will only be used if you want to change the way correspondence is printed. For example, you're a school, and you've got Joe Smith as the Entity. However, as a matter of courtesy, he would like printed correspondence to come to the house as "Joe and Sue Smith," or even "The Parents of Bobby Smith."

Another example: you have Peter Williams as a contact for XYZ Company, but he has requested that printed correspondence come to him as "Peter Williams, Accounts Payable."

Addressee1 and 2 will override the default setting which is going to be the person's name followed by the company name. We haven't gotten that far yet to do anything that involves printing (letters, invoices, etc.)

Richard Wilson

25 hours ago

OK. Look forward to it. Thank you.

Add a Reply