access
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007

Access 2007

resolvedResolved · Medium Priority · Version 2007

replyReply Mon 22 Sep 2008, 16:36Delegate Owen said...

Owen has attended:
Access Introduction course

Access 2007

Has the crosstab query been given added functionality since 2003? If i am right the 2003 version uses excel pivottable function to produce more compliacted crosstabs.

For upcoming training course dates see: Pricing & availability

replyReply Tue 13 Jan 2009, 18:01Trainer Rajeev said...

RE: Access 2007

Dear Owen

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

To the best of my knowledge there has been no additional functionality to the Cross Tab query.

Pivot tables are available in 2007 version as well. We cover Pivot tables in Access 2007 in Advanced level. If you are interested in knowing more about the course content in Access Intermediate and Advanced please refer to the following link:

http://www.microsofttraining.net/access-training-london.php#v2007




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

Tue 20 Jan 2009: Automatically marked as resolved.

 

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

Access tip:

Prefixed Autonumbering

When using Date Type = Autonumber as a primary key, clients may require autonumbering to be prefixed with a letter.

For example, P001, where P is the prefixed letter

Instructions
Step 1. Create Field Name
Step 2. Set Data Type to Autonumber
Step 3. Within Field Property General tabsheet,
enter Format property as [backslash]P000



View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard