Microsoft Access 2002 question?

Question

I am building an address book in Access 2002. It's the first time I've used this program and the tutorials are not much help for what I want to do. When I print out the Access phone listing (on 4" address labels in the Report area) I want to seperate the listings by alpha. How can I do this? Also, when I tried doing this - in the design view by creating a header with the first letter of last name, it would automatically cut out a lot of listings and only had 11 pages out of 31! Any ideas out there on how to fix this? Thanks!

Answer 1

Don't ya hate when people who have no clue give you suggestions?
Access is about as easy as it gets for databases, and you're already into the tutorials.

Now to your problem: I'd have to know what is missing to more closely diagnose what the problem is. When it gets cut from 31 pages to 11 pages is there any pattern? Like is it only listing the first Name from each letter of the alphabet? Or is it skipping everyone from F through R (for example).

I might write a query with a variable for the first letter of the names, like:

Dim strLetter as STRING
FOR strLetter = A to Z
SELECT * FROM Table WHERE Last_Name LIKE (strLetter & *)
NEXT

Then on the report put a page break and a header with the strLetter variable at the top. Every time strLetter changes, it's a new page.

Hope that helps

Answer 2

Access is a very hard tool to use for beginners. I would suggest that you go to the MS Office website and look through the different templates that they have there. You should be able to find something that will closely suit your needs. If not I would suggest that you use MS Outlook to manage your address book.

Good luck with your project!

Answer 3

As you are a beginner in Acces it is impossible to explain someone has to show it to you because it takes more than one handling to obtain the result you want.

I would suggest you use a simple excell file with differrent coloms for - first name - Postalcode - Location - ...
By using a filter or find function you should be able to retrieve and sort quickly the information you are looking for.