How to Make Specialized Phone Directory?

[Chris B.]

I am running Windows 98 SE and MS Access and also MS Works Suite Data
Base.
I live in a small retirement condo/association community. I prepare the
annual phone directory. I have been doing it in a makeshift manner with
lists and then MS Publisher. This is very difficult and can be filled with
errors because I am not accessing the data via a form to a master data base
as is done with queries and reports in MS Access. I am looking for an
Access Template or some inexpensive (I am, of course, willing to pay for
this if necessary) and simple program to do this. The directory has two
sections: first by alphabet; then by building and unit number. The alphabet
section is no problem. The building and unit number section is not directly
in numerical order, however: evens on one side; odds on the other of our
circular drive. Each building is displayed separately with its units. Some
buildings have four units and some have six units. I print the directory
out with two panels to a regular 8.5 X 11 sheet, landscape aspect. The
complete booklet has 16 panels. The 8.5 X 11 sheets are folded to make for
a nice little booklet.
Thanks for any ideas.


Chris

 

[Alex H]

Chris
There are two vissues here

1. The database holding the information and
2 Publishing

Noth are very easy to do, you can make a simple table in Access to hold all
the information you need, and then either use Access, or better Publisher to
actually display the data in the format you want.
You need to get some paper and list all the elements of the directory that
you want to hold in the database.

Surname, Christian Names, Telephone number, Building number, unit number,

Enter the data (that'll be the longest part

Then you can sort and publish

Hope this helps

Alex

 

[Van T. Dinh]

There is a Contacts Database available on Microsoft Web
site that you can use as the starting point and then
modify to suit your needs. See:

<http://office.microsoft.com/search/redir.aspx?
AssetID=DC010554741033&url=http://www.microsoft.com/downloa
ds/details.aspx?FamilyID=6534F03C-518E-4868-9BDC-
20BAADB1C710&displaylang=en&hurl=038A7BA3D81EF5D2AF6DA024DE
59A438&CTT=1&Origin=EC790000701033&QueryID=GnF4kctk8>

If the link doesn't work from this post, copy and paste
the link onto our browser as ONE line.

HTH
Van T. Dinh
MVP (Access)