Archive for Month: February 2016

MS Access Database Referential Integrity

MS Access Behind-The-Scenes 6 Pillars to an MS Access Database   PILLAR#2 Continued– MS ACCESS REFERENTIAL INTEGRITY ** What is Referential Integrity? ** It is a set of rules to help maintain accuracy between the tables in a relationship. It prohibits a User from changing or deleting data that invalidates links […]

MS Access Relationships

MS Access Behind-The-Scenes 6 Pillars to an MS Access Database ** PILLAR#2: MS ACCESS RELATIONSHIPS & REFERENTIAL INTEGRITY   In order to have the Database function the way it is supposed to, you will have to create relationships between the tables. They need to talk to one another. If there […]

MS Access Database

MS Access Behind-The-Scenes 6 Pillars to an MS Access Database:  PILLAR#1– MS ACCESS TABLES   Databases simply advance Excel Spreadsheets a step further giving users the ability and flexibility to collect information in various formats. They can be used by anyone everyday either for personal or business use. Excel vs Access Many people create massive […]