Category Archives: New

Table Types

To my way of thinking, there are two types of tables. Entity Tables and Transaction Tables. It is important to understand the difference. Entity Describes an entity and its attributes. Customers are entities, Products are entities. You can edit an entity’s attributes. I always like to use a Log table that takes a copy of… Read More »

Outer Joins in Access

The Access Query Designer does some great stuff but what it won’t do is an Outer Join. What is an Outer Join? If we have two tables, in this example Sales and Orders and we want to see a full list of customers who have placed Either an Order or a Sale and also see… Read More »

Containers, Collections and Objects

An Access Database is a container. Within this container are collections of objects which include tables, queries, forms and reports. Objects can themselves be containers. For example a table contains columns (or fields) while forms and reports contain controls that display data. So we could iterate through our database’s Tables (TableDefs) and through each Table’s Fields like this… Read More »

Category: New