|
|
|
Now it’s time to summarize what I’ve explained so far and explain where I’m going to take you next. So far we have: 1. An address book database named AddressDB 2. A table, to store our address information, named AddressTable 3. A form, to help enter information into the table, named AddressEntryForm 4. A query, to sort our addresses by last name, named AddressQ Next I will explain how to use the AddressQ (query) to sort the data in the AddressEntryForm so that each time the form is used, the addresses will be sorted and displayed on the monitor by last name. Finally, I will explain how to provide a look up | control on the AddressEntryForm to help find a specific address quickly.
As it is designed now, the AddressEntryForm uses the AddressTable to get its information. But the addresses are not sorted in a table. So in order to have them sorted, we need to use the query as the basis for the form instead of the table. The first step is to open the AddressEntryForm in design mode and change its data source from the table to the query. Open the database via the following path: (or, if you have the AddressDB already open, simply press the F11 key) Start\Programs\Microsoft Access\Open an existing file\AddressDB\OK If you followed the path correctly, you’ll see something like the following:
|
