access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

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

Access 2007

resolvedResolved · Medium Priority · Version 2007

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.

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:

https://www.stl-training.co.uk/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.


 

Access tip:

Switchboard Startup

An option when you open your Access database that contains all of you tables, forms and queries is only the switchboard is displayed.

To achieve this, select Tools click on Startup. On the right hand side of the Startup screen you are able to select which form you want to open when you open you Access Database. Once you have selected this, there is a check box just below that says "Display Database Window", you need to uncheck this option. Then click ok.

Then when you close you Access database and re open it, the database should open with just the switchboard being shown


View all Access hints and tips


Server loaded in 0.08 secs.