Mail us
Home » Posts tagged "Access database 2007"

Tag Archives: Access database 2007

Access Database 2007: Assigning a Primary Key to a Table Microsoft Lesson 2.7

Access Database 2007

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 […]

Tags: , , , ,

Structuring Queries In Access 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 […]

Tags: , , , , , , , ,

Microsoft Access Database 2007 tutorial

Access Database 2007

When Microsoft Access first appeared in the early 1990’s it revolutionized the desktop database market. Most versions have been similar to each other. Now with Access 2007 we see the most radical changes yet introduced by Microsoft. When working your way through an MS Access 2007 tutorial, a hardcore traditional user of MS Access is either going to love or hate these new changes. So what is different about this new version? The interface is completely different and instead of […]

Tags: , , , , , , ,

How to set a Relationship in Access 2007 ?

Microsoft Access Database

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.

Tags: , , , , , ,