Can anyone recommend a good Acces / EXCEL / VBA & SQL guide.
I have a good knowledge of both Access and Excel GUI use but not how to implement scripts macros and all that. Specifically I’m after being able to use the linked Pervasive ODBC access tables to produce automated worklists, 3 day lookaheads, progress reports etc either outputting them to Access reports or to Excel sheets for graphing etc. I am making progress on this on my own, but it would be useful to have some sort of reference guide to refer to
So, the guide should provide me with;
- advanced tools in the Access / Excel GUI
- VBA and SQL scripting guide for Access and Excel
- VBA and SQL reference and syntax guide, general and specific to Access / Excel
- How tos for common tasks
- a tea maker and possibly a cigarete roller
Thanks
I have a good knowledge of both Access and Excel GUI use but not how to implement scripts macros and all that. Specifically I’m after being able to use the linked Pervasive ODBC access tables to produce automated worklists, 3 day lookaheads, progress reports etc either outputting them to Access reports or to Excel sheets for graphing etc. I am making progress on this on my own, but it would be useful to have some sort of reference guide to refer to
So, the guide should provide me with;
- advanced tools in the Access / Excel GUI
- VBA and SQL scripting guide for Access and Excel
- VBA and SQL reference and syntax guide, general and specific to Access / Excel
- How tos for common tasks
- a tea maker and possibly a cigarete roller
Thanks