Best training for Advanced Access - online or instructor-led

[jjlogan]

I would like to dedicate some time to learn the advanced features of Access 2010 that I have not had to use in my job of creating a few databases and automating them. I'm sure there are more features I not aware of and want to use company funds this time to advance my knowledge. I have read at least two books on development and have been using Access for about 8 years. Does anyone have any suggested sources for learning advanced Access? I checked my local junior college and they are not offering such courses now. I would be open to web-based training, dvd's, etc. just not another book at this point. Thanks for any input you might have. Jeff

 

[lameid]

I'm mostly self taught myself so I don't have any recomendations there but the obvious question that comes to mind is what do you know or Don't know?

I ask because what one or another thinks is advanced may vary wildly.

I guess another good question is what would you like to know how to do that you don't?

 

[jjlogan]

What I do know is how to design tables and relate them in normal structure rules. Of course, design of all types of queries (select, action), report design, form design, etc. And I write modules in VBA and ADO and DAO. I also do use import/exporting to Excel. But what I don't use much is features like pivots, drilling down concepts, and the new access features found in 2010. Jeff

 

[lameid]

Funny, someone just sent me an e-mail the other day how Pivot Charts are removed in 2013.

The recommendation is to use Excel objects instead there.

Somewhere along the line they added conditional logic to macros and web application support with sharepoint... I think those are the main things that are major enough to learn about...

Then there are things that are minor to know like using Tempvars() instead of globals because they don't die when your code errors out. Making PDF / XPS. I'm guessing that if I cared these would be a line or so of code.

Customizing the ribbon programatically would be something to learn about if offered too as the best documentation requires alot of intuition.

Using Acces with SQL server is a good topic too and any realted SQL Server classes.

Others may be able to dogpile more topics or offer specific classes.

Another thought... at some point courses only go so far so getting a developer that knows the thing maybe an alternative way to go if you get truly stuck.

 

[jjlogan]

Thanks for the practical advise. I will look into the recommendations like for pivots, sql server, etc. Jeff