Microsoft Access Databases must really have primary keys applied to each core table to help manage relationships and keep data integrity 100% enforced to avoid those unexpected errors. Take a look at this quick tutorial on How To Set the Primary in Microsoft Access My Comments on Microsoft Access Database Primary Keys I’m not a fan of mutiple fields to act as a group for the primary key as discussed in this video tutorial. I believe there should only be […]
Tag Archives: Access database 2007
People prefer to keep complex data sets in databases rather than in flat files because data can be found and grouped more precisely when it is stored in a database. The ability to draw data out of a database depends upon the ability to structure queries, or requests that define specific records. Structuring queries in Access 2007 is relatively easy because Access is designed to handle many different types of operators. An operator is a special symbol or reserved word […]
This video from YouTube shows the basic way to set and join two tables together in the relationship window viewer tool. This gives you a clear and simple step by step instructions on how to join two tables creating a global/permanent relationship. Access database then recongnises this setting and releases more functionality including the ability to expand and collapse related records in a table.