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

access

ResolvedVersion 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:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.