Could Access possibly do this?

[truth_ip]

Hello there. I am a trainee from Hong Kong working for a company in Germany. Due to the infamiliarity of the Access program and the incompetence of German (all softwares here are in German), I am not able to finish the task below by myself and urgently need your help.

My company is going to join a trade fair. We want to get the information from the participants. To achieve this, we offer free business card (10 cards per A4 paper) to the participants.

I though that it maybe a good idea to develop a database in Access to get things done. However, I don't know how I can print just one individual set of data each time and how I can print 10 times of that individual set of data. Could any computer genius help me with this?

Thank you so much for your help in advance.

 

[Fuga]

Use a query to select the posts you want, then create a report.

Fuga.

 

[shkrebs]

Hi Truth...

A good idea is always to use the Wizards to do all the "borring" work, then later you can edit the reports, so they fit to your labels.
Eventhough the Access is in German, the wizards are using a lot of illustrations - and U know - a pic. says more than a 1000 german words so I think you will manage.

Regards
Søren

 

[shkrebs]

Well - as Fuga wrote then I think the best way is to make a query which select the data you need for your report and then base the report on this query. Goto propeties for your report and look for the DATA-SOURCE.
If you don't change any names in your query then you should be able to change the data-source from your tablename to your queryname.
In the query you are able to specify a search-criteria, i.e. [Name of Visitor] = "Gerhard Schröder", then the query only select the data belonging to this record.

Hmm - just beginning to realize what U want to do

When U are on the Fair and you have finished registrating the visitor, then the system should print a paper with 10 BusinessCards, that's it - no?

Hmm, think I would do some "After Update" programming, like this: (It's in SSL - "Sørens Structure Language" )

START:
Open table containing the data
Search for the last record.
Read it
Close table

For 1 - 10 Do
Write it to a temp-table
End Do

Print report based on the temp-table
Delete the records in the temp-table
END

If you want more inputs it's a good idea to keep this in the open forum - not only for you, but maybe others can gain from our chat

Best regards
Søren