Computer Learning Zone CLZ Access Excel Word Windows

Science is an attempt, largely successful, to understand the world... Microbiology and meteorology now explain what only a few centuries ago was considered sufficient cause to burn women to death.

-Carl Sagan
Home   Courses   Seminars   Templates   TechHelp   Fast Tips   Forums   Help   Contact   Join   Order   Logon  
Home > Courses > Access > Templates > ABCD > Part 1 < ABCD | Part 2 >
ABCD Core Part 1

Back to ABCD Core Part 1

Person Entity table Upload Images   Link  
Scott Axton 
11 months ago
I just finished watching the Core 1 videos and I'm a bit confused. Maybe this is answered in future videos but...

It's kind of sounding like the intention is to have all entities in one big table rather than several.  Such as customers, vendors, others...?
Then somehow (in the future) they would be differentiated - EntityType maybe? -  

Am I understanding your line of thought in this? Maybe I'm jumping ahead to fast in my mind.
Richard Rost
11 months ago
Scott, you're correct. An entity can be designated as being part of one or more groups (Part 2). You can have vendors, employees, sales reps, parents, softball team, customer, lead, Star Trek fan, whatever you want. Then later on, if you want to make an order form where the sales rep is selected from a list of just your sales reps, you can pull from members of that group. This essentially prevents multiple tables that essentially all store the same thing: information about entities (which can be individuals, families, companies, etc.) I tried to keep it as generic and flexible as possible.
Scott Axton
11 months ago
Thanks for the clarification.  Haven't had time to move on to the nest core yet.

This thread is now closed. If you wish to comment, start a NEW discussion, below.

Back to ABCD Core Part 1

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
My Account
My Courses
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