Queries and Relationships
Tutorials Shared by the Internet Community
Total Hits - 31971
Total Votes - 98 votes
Vote Up - 42 votes
Vote Down - 56 votes
Domain - www.functionx.com
Category - MS Access/Building Databases
Submitted By - Shekhar
Submitted on - 2008-04-15 06:13:30
When creating relationships among tables, we were selecting the primary key of one table and the foreign key of a dependent table to join them. Once such a relationship is created, you can create a query that combines both tables to create a set of records, also called a record set, or a Recordset, that would include either all records or isolate only the records that have entries.
Suppose you want to create a query that includes the persons of this table and their gender. A question that comes is mind: Do you want to create a list of only people who can be recognized by their gender, or do you want the list to include everybody? This concept leads to what are referred to as inner joins and outer joins of queries. There are two ways you can get such queries: you can prepare the relationship between two tables to be aware of this type of relationship or you can directly create it when designing a query. More detail...