Queries and Relationships

Tutorials Shared by the Internet Community

Advertisements


Synopsis

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.

Statistics

  • Total Hits - 15638

  • 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

Description

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. ...


Site  |   Broken  |   Tweet  |   Facebook  |     |   Save  |   Liked  |   Down

Advertisements