I used union queries to populate my combo boxes so that the value of "left arrow (the sign won't show up in the post) All right arrow "). By...

While I agree there can be something...

I agree. You seem to have a good understanding of the level of granularity, which is the fundemental concept to proper OLAP design. Without the data, I can't...

I don't have a chance to do interviewing now, but at my previous company we had a test that had a few multiple choice questions, but was mostly free form....

Most of the time, we're perfectly happy with case-insensitive, accent-insensitive searches. The difference between upper and lower case (Majuscule and Minuscule) in the European languages are more accurately described as...

Triggers are great for maintaining data integrity when it can't be maintained through the normal means. Here, however, you have a very easy way to use standard data constraints....

I sympathize. The fact is that several things are easier in Access than SQL. It also sounds like you have unrealistic management expectations.

I don't know if they'll have...

As for the comment about European languages not having a semantic difference between upper and lower case letters... in German the noun is always capitalized... I don't know enough German...

C'mon. I've seen VB front ends with Access back ends, and they work, but we're talking about what works best, not what just works. With an Access backend,...

Not true in a general sense, as long as you don't have issues with user's not having Access licenses then Access can be better than VB (and other languages). Depends...

That's good. Access front ends to access an Access database works well, but VB is a much better front...

Although a dimension table should have a surrogate key to facilitate the join with the fact table, there should be a field or combination of fields that can't be repeated...

If you use even a tinyint, you are still forced to make a join that wouldn't otherwise be necessary. Making no join is surely faster than making a tinyint...

In the example above, the four tables I showed with a natural key have 3, 17, 12 and 9 rows respectively. When I got here a year ago, the table...

I don't who RonKyle is arguing with, but it is not me. I never proposed using SSN (or any country's equivalent) as a Primary Key. In fact, I first mentioned...