Suggestion for advanced access/VBA?

[RCheesley]

Hi all,

You probably get asked this all the time, but I wondered if anyone could suggest courses for advanced access and VBA?

I've done quite a bit of research and a local company has suggested that a one day workshop tailored to my needs would be the best way to go, but I am a bit hesitant about this as surely there may be things covered in the open 1/2/4 day courses which I might not need right now, but may need in the future? I don't want to get my work to shell out lots of cash on a course which is too "blinkered".

I'm looking at instructor led courses as well as online/distance learning.

Thanks in advance!

Ruth

 

[MagicMan]

Ruth,
How advanced a course? In most cases, the KISS rule is the best way to program (Keep It Simple Stupid). Do you mean VB or one of the data access components (DAO/ADO/SQL Server's T-SQL)?
Bob

 

[RCheesley]

Hi Bob,

The following are my immediate needs although as I said above, I don't know what I don't know ... haha

Access

• Using VBA to customise buttons, automate functions, etc – e.g. csv export, create emails (with CSV attachments), create reminders, etc
• Using SQL to create custom queries etc
• Using OLE/ADO/ADOX?
• Concurrency – considerations for, how to set it up, how to monitor
• Working with data files – e.g. opening/reading/writing/printing to files
• Producing graphs & charts in reports & customising report layouts incorporating graphs, trend lines, etc
• Using intranet/internet forms to interact with data (not essential)

 

[MagicMan]

http://www.functionx.com/vbaccess/ is recommended by Microsoft. I haven't used them, I learned by doing it, but I am told they are pretty good.

 

[RCheesley]

Thanks Bob, I think I came across one of the pages when trying to fix something else (answered my question at the time, but I didn't bookmark it or look into it any further), I'll look into it in a bit more detail.

Ruth