MS-Acceess Training

[Dominic Vella]

I'm an avid MS-Access developer however as much as I feel I can build great
and powerful MS-Access databases, I still feel there's always more to learn,
such as:
* Using Access projects
* Using ADP files (incl., Views and Stored Procedures)
* Using Class Modules
* Locking modules and tables without having to build MDE files
* Using 'Additional Compilation Arguments' with projects, etc.

There doesn't seem to be any microsoft certificates that deal with MS-Access
at such levels.

Can anyone point me to where I can get training on such stuff?

Thanks


Dom

 

[Bill Mosca]

You're right about there not being certs for advanced developers, but I'd
like to express my views on the points you brought up.

Dump Access Projects. They are no longer supported in Access 2007. Instead
use linked tables. You will just need a user interface for the database back
end (use an ADP for creating/maintaining the back end if you don't have a
user interface). I've been developing with SQL Server back ends for more
than 10 years. ADPs are painfully limited compared to linked tables, and I
saw no increase in performance.

Class modules are fun to learn, but to be honest I have never had the need
for them.If you want to learn about Classes in VBA, I suggest one of the
many VBA books available.

Hmm...locking modules and tables without using MDEs. MDEs are the ONLY way
to lock your code. There are all kinds of password crackers on the net. And
tables? No matter how you hide them, if they are in the front end, a savvy
user can get to them. If they are in a back end, you can rely on network
security on hidden folders for that. Read Garry Robinson's book "Real World
Access DB Protection and Security" (Apress publisher).

Again, these are just my views.

 

[Bill Mosca]

You can still build adps in Access 2007,

you can use them to help get you acquainted with SQL Server.

I stand corrected. I was thinking of the defunct DAPs. But I still would not
build an ADP without a big fight.


--
Bill Mosca, MS Access MVP
http://www.thatlldoit.com
http://mvp.support.microsoft.com/profile/Bill.Mosca
http://tech.groups.yahoo.com/group/MS_Access_Professionals