Expanding My Access Database

  • Thread starter Thread starter Lewis
  • Start date Start date
L

Lewis

I have a database that's working well for me so far. Here is the layout:

There are 500 agencies,
Every agency has one or more contacts,
Each contact has only one program
so...each Agency could have more than one program

Now, what I want to do is sort the agencies and contacts by program. So,
when a person opens the link from the switchboard they see only the agencies
and their contacts. I know I can't make more than one table with the same
information but my folks don't know how to run queries or sort or anything.
Is there anything I can do? Thank you in advance,

Lewis Peterson
 
Lewis said:
I have a database that's working well for me so far. Here is the
layout:
There are 500 agencies,
Every agency has one or more contacts,
Each contact has only one program
so...each Agency could have more than one program

Now, what I want to do is sort the agencies and contacts by program.
So, when a person opens the link from the switchboard they see only
the agencies and their contacts. I know I can't make more than one
table with the same information but my folks don't know how to run
queries or sort or anything. Is there anything I can do? Thank you in
advance,
Lewis Peterson
Click to expand...

Let's start with the table design. How do you have your data stored
now? How many tables? How are they joined?
 
Create a new query.
On the menu click on Window and select the item near the bottom with a 1.
Under the list of Objects click on Queries.
On the tool bar click on New.
On the New Query window select Design View.
Double click you Agency, Program, and Contact tables. They will now appear
in the space above the grid. If you have set up the relationships they will
be linked.
If no relation exist click on the Agency table item that is BOLD (this is if
you have assigned a key field).
Drag to the related field in Program table. Do the same for Program to
Contact table.
In the Agency table drag each field you need to see in your display. Do the
same for Contact table fields (You do not need any Program information so
there is not need to pull any fields).
Click on the floppy disk icon on the tool bar and save, naming it something
like AgencyContacts.
Click on the red exclamation mark on the tool bar to run the query. Verify
it pulls the required data.
Close the query.

Use this query for your record source for the form or report.
 
Back
Top