Category Archives: Tables, Table Design

Tables, Table Design

Edit From Relationships Window (Access 97 and later)

      Comments Off on Edit From Relationships Window (Access 97 and later)

You can right-click any table in the Relationships window and then choose Table Design from the shortcut menu to open that table in Design view. You can also choose Print Relationships (Access 2000) from the File menu while viewing the Relationships window to create a report that prints what you have laid out in the window.

Nulls and Zero-Length Strings (V2 and later)

      Comments Off on Nulls and Zero-Length Strings (V2 and later)

Relational databases support a special value in fields, called a Null, that indicates an unknown value. Nulls have special properties. A Null value cannot be equal to any other value, not even to another Null. This means you cannot join (link) two tables on Null values. Also, the test “A = B,” when A, B, or both A and B… Read more »