Pivot Tables

The UK's most regular instructor-led training courses.
Training information: 2003 access micorosft training · Access training · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · High Priority · Version 2007

2 posts

ReplyMon 8 Jun 2009, 14:51Delegate Daljit said...

Daljit has attended:
Access Intermediate course

Pivot Tables

how to create pivot tables with 2 rows and multiple columns

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

870 posts

ReplyTue 9 Jun 2009, 07:27Trainer Rajeev said...

RE: Pivot Tables

Dear Daljit

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

Following link is a video tutorial and very helpful in learning the basics about Pivot tables in Access 2007:

http://examples.oreilly.com/9780596527600/ch09/Pivot-Tables.html

I believe that after going through this 9 minutes tutorial you should be able to figure out how you need to arrange your data in pivot table.

Also from what you were asking me about the Vessel and Fleet examle I beleive teh follwoing link might help you:

http://blogs.techrepublic.com.com/msoffice/?p=1009

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

Mon 15 Jun 2009: Automatically marked as resolved.

· Access VBA Handling Errors and Debugging Code
· Microsoft Access Beginners' Training: Getting to Grips with Databases
· Learn about Subqueries in Access Courses
· So what's new in Access 2007?
· Microsoft Access Cheat Sheet: Tips and Shortcuts

Please browse our web site to find out more about
2003 access micorosft training and other Microsoft training courses.

Access tip:

Convert A Form Into A Report

If there is a form that you want to to save as a report:

1. Open that form in Design View
2. Select File and Save As
3. In the Save As Dialog box Select Report

The system creates a report based on the form.

View all Access hints and tips