Welcome to ABCD Part 1: Core. Total running time is 3 hours, 27 minutes.
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.
Post your questions or comments below