Combining data sets

The UK's most regular instructor-led training courses.
Training information: ms+access+course/ · Access course microsoft training · Microsoft Access Training London
See also · microsoft access training · access vba courses · access database course

Resolved · High Priority · Version 2003

2 posts

ReplyTue 2 Jun 2009, 14:25Delegate Danielle said...

Danielle has attended:
Access Intermediate course
Access Advanced course

Combining data sets

In a table i am working on i need to decrease the amount of options in the industry field from aroung 20 detailed sector descriptions into roughly four sector overviews. How can i do this?

Version	Date	Location	Places available	Book	Next place rate (£)
Access VBA 2 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2003	Wed 24 + Thu 25 Mar 2010	Southwark	8		£445	£450
2003	Wed 5 + Thu 6 May 2010	Bloomsbury	10		£275	£280
2003	Mon 28 + Tue 29 Jun 2010	Bloomsbury	10		£275	£280
2003	Wed 4 + Thu 5 Aug 2010	Bloomsbury	10		£275	£280
2003	Thu 9 + Fri 10 Sep 2010	Bloomsbury	10		£275	£280
2003	Wed 27 + Thu 28 Oct 2010	Bloomsbury	10		£275	£280
Full Schedule: See all 7 Access VBA course dates. Bookings currently available until 6th December 2010.

870 posts

ReplyWed 3 Jun 2009, 16:50Trainer Rajeev said...

RE: combining data sets

Dear Danielle

Thank you for attending Access Intermediate course!! I hope you enjoyed the course and benefited from it.

I would appreciate if you could further clarify your query buy providing more details.

I know that you have done Advanced Access course today and I am hoping that it might have helped you in answering this query. If it hasn't than please provide more example or if it is possible to e-mail then I would request you to send me the file on rajeev@microsofttraning.net. Please ensure that you have no confidential data on the file. I would request you to expand on your query further when you do send me the file!!

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

· Access VBA Handling Errors and Debugging Code
· Microsoft Access Courses
· Some Simple Database Questions Answered
· Have You Ever Wanted To Create A Combo Control On An Access Form?
· Tips for designing databases in Microsoft Access

Please browse our web site to find out more about
ms+access+course/ and other Microsoft training courses.

Access tip:

Changing MS Programs Text Size

A handy way to increase or decrease the size of text in Microsoft Word, Microsoft PowerPoint, Microsoft FrontPage, or Microsoft Publisher, first, select the text you want to resize.

Then, to increase the font size, press CTRL+SHIFT+>.

To decrease the font size, press CTRL+SHIFT+<.

View all Access hints and tips