|
|
|
That completes the query design. Every time this query is run, it will display all entries in the AddressDB sorted by LastName. We will use this query later on when we create a form to display information.
IMPORTANT NOTE: The order in which you enter address information doesn’t matter because queries do the sorting for you. Please try hard to understand this. It is one of the most difficult things for beginners to understand or visualize. Organizing and sorting of information is what databases are all about. When you put addresses in the address table, the order in which you type them into the entry form is irrelevant. It will all get sorted and organized by the query when it is displayed or printed. | OK, now the query must be closed, named and saved. Close the query by clicking the X in the upper right corner of the query window. Access asks if you want to save the query to which you answer Yes. When the name dialog box appears, type in the name AddressQ. Notice the names I give you are short but meaningful. Later on, any time you see these names, you can figure out exactly what they are just from the name. For example AddressQ means Address Query. |