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 […]
Tag Archives: Access Relational Databases
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.