Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

SQL

Let's say your friend is spending the summer in Tokyo. The mailing address he gives you has the text string chome, which in Japanese roughly means “division” or “section.”

The Japanese post office will have no problem interpreting chome on an envelope you address to him. On the other hand, chome is not Japanese. It only approximates in English the pronunciation of the actual Japanese word, written as .

Something similar is at work when you add fields, sorts, criteria, and more on the design grid. In the past several pages, I've been telling you to “create a query in Design view.” That's not strictly accurate. What I've really been saying is ...