Wednesday, November 29, 2006

Details of the Relational Algebra

Access's Query Design mode provides a graphical environment to create and edit queries.

Table schemes are added in the upper portion of the Query Design window.

The design grid is in the lower part of the window.

Access takes care of forming the appropriate join based on the relationship information shown in the upper portion of the window.

Access SQL is more powerful than the Access Query Design interface.

No comments: