Home

Did you know that the one of following is not always true in Excel?

A-B-C = A-(B+C)
100.8 - 100.7 = 0.1

It is a trick question: Both of them aren't always true! (For the second one, see links at the end of this question. Particularly if you use VBA code.)

In an earlier article, we created a simple relational database in Microsoft Access. However, that design has some flaws (which were by design, pardon the pun). In this article, we'll walk through the issues and make some changes to the table design to address those issues.

That being said, I make the assumption that the following concepts aren't alien to you:

• One-to-Many Relationship
• Many-to-Many Relationship
• Junction Table
• Primary Key
• Foreign Key

If they are, I suggest reading through my earlier article on the prior version of this database first.

I won't be spending too much time talking about forms and reports, since that may be too much detail for the purposes of this article. However, the sample database will include revised and improved forms and reports for you to look at. I do recommend taking time to look at those in design view and try to understand how they work.

Let's start by taking a look at the table design again.

One of the issues has to do with compilation CDs. In this design, we can't assign multiple artists to a CD. The workaround was to create a catch-all artist called 'Various'. The problem with that is that there is no way to figure out how many albums an artist has appeared on.

In this article I'll show you how to highlight edited fields on a form and help you understand some of the control and form events (see additional links for information on all the events.).

The first thing we need to understand is what are events. For the control (e.g. textboxes) events, we'll be focusing on the Change and BeforeUpdate events. [Note: Controls and Forms have many events in common, but there are some that are specific to each.]