Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   TechHelp   Forums   Help   Contact   Merch   Join   Order   Logon  
 
Back to Access Beginner 6    Comments List
Upload Images   @Reply   Bookmark    Link   Email   Next Unseen 
Customer and employee table
Roland Richon 
     
3 years ago
Hello everybody,
What would be the downside of putting all the customer and employee data in one and only table? The role or qualtiy (customer/employee) of one person can for ex be specified by a specific field.
I don't know if this topic is covered in the "multiple tables video" thx in advance kind regards Roland
Scott Axton  @Reply  
        
3 years ago
You could split them but to be honest people are people.  There are many advantages for keeping them all together.
See the Self Join Relationships video.  That one talks about family but could just as easily be used for employees or customers.

Richard does something very similar in his ABCD database.  That goes much more in depth into working with a single table that he names 'Entity'.
Kevin Yip  @Reply  
     
3 years ago
From my experience, it's probably not a good idea to put them together, because customers and employees may require quite different data sets and purposes.  In my old job, our customers had bill-to addresses (multiple ones for one customer) , ship-to addresses, distribution center addresses, and that was just for addresses.  Different customers had different payment terms -- some must pay before shipment, and some could pay months after shipment.  And there were tons of other data relevant only to customers but not to employees or anyone else.  Our customers were publicly-known entities like department stores, wholesalers, things of that nature.  But employee info must be kept with utmost privacy, obviously, because of all the sensitive info like SS#, phones, and addresses.  Only our accountant kept all our employees' info in her own database (not Access, but her accounting software).
Roland Richon OP  @Reply  
     
3 years ago
Thank you Kevin for your feedback on this. Yes, considering the different data sets makes sense. I think also, that you need to separate people who are somehow related to each other. Well, I certainely need to gain more experience how to set up tables related to persons.
Roland Richon OP  @Reply  
     
3 years ago
Hello Scott, well yes that was my initial approach too. But in this video Richard hasn't kept the customer and employee data together? I will watch the video you have suggested and the maybe it will be clearer for me...
Scott Axton  @Reply  
        
3 years ago
Roland
In this case there really isn't a correct or incorrect between the two methods.  Kevin brings up some very valid reasons why you might want two different tables.

In my case, I separate special or sensitive data into a different table.  Basic information like name, address, and phone are kept in the same table.  My main reason for doing it this way, in my case, is that our employees can also be a customers of our business.

The beauty of using Access is that there are multiple options and by making your own database you can customize it according to your needs. I think that is really the main point here.

Another video to illustrate this is the Too Many Tables
Kevin Robertson  @Reply  
          
3 years ago
I certainly prefer keeping customers and employees in separate tables. If the employee is also a customer I would simply add an IsCustomer field to the Employee table. But' like Scott said there is no set in stone method and depends pretty much on how you want your database to function.
Roland Richon OP  @Reply  
     
3 years ago
Hello guys, thank you all for your input. I will certainly considering your suggestions when designing especially seperating sensitive data from basic data. As already said there is no one "right" method and it certainly depends on what should be the outcome of the db. Thx

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 6.
 

Next Unseen

 
New Feature: Comment Live View
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
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
PCResale.NET
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
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2026 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 4/30/2026 10:47:29 AM. PLT: 0s