fbpx
Logo
Home » Posts tagged "Access Relational Databases"

Tag Archives: Access Relational Databases

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: , , , , , , , ,

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: , , , , , ,