Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rating: Thread Rating: 4 votes, 5.00 average. Display Modes
Old 09-09-2013, 06:04 AM   #1
Jon
Access World Site Owner
 
Jon's Avatar
 
Join Date: Sep 1999
Location: East Sussex, UK
Posts: 789
Thanks: 13
Thanked 1,887 Times in 62 Posts
Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future Jon has a brilliant future
How to go from Intermediate to Advanced - please help

I would like to ask what you folk think you need to know in order to go from an Intermediate Access user to an Advanced Access users. Considered the defined categories as being Beginner, Intermediate, Advanced and Expert, so at least you have some context.

So, what specific things do you need to know to make this progression?

__________________
Regards,

Jon

Last edited by Jon; 09-19-2013 at 07:12 AM.
Jon is offline   Reply With Quote
The Following User Says Thank You to Jon For This Useful Post:
hassanogaibi (06-28-2016)
Old 09-09-2013, 04:00 PM   #2
tfurnivall
Newly Registered User
 
Join Date: Apr 2012
Posts: 81
Thanks: 8
Thanked 9 Times in 4 Posts
tfurnivall is on a distinguished road
Re: How to go from Intermediate to Advanced

What a silence......!

At the risk of being flamed, let me offer some suggestions:
Code:
Beginner:     Uses (primarily) the built-in tools to create apps. 
              Little or no VBA; 
              Tables may or may not be normalized (Huh? What's that?)

Intermediate: Comfortable using form events. 
              Probably not using OO approach for the main part of the code.
              Tables generally normalized - most of them with an AutoNumber Primary Key. 
              Maybe secondary indices.  
              Little or no use of Office Automation; 
              DB is typically single DB - no splits. 
              Occasional use of Unbound forms. 
              Code is generally well commented, but not subject to rigorous management.

Advanced:     Tables routinely normalized, 
              Most application code is object oriented, with user defined classes capable of inheriting other classes. 
              User has established several utility libraries, and knows how to keep them as external files, using Tools|References to bring them in. 
              User is comfortable using split DB where one or other of the components is on a separate machine. 
              Comfortable using other DB engines than Jet. Code routinely has clearly defined transactions, including Commit and Rollback. 
              Application routinely includes user authentication (possibly from a different server).

Expert:       Good track record of helping others in clear, concise helpful language. 
              Provides just enough help to allow 'further research' on the part of the questioner to yield a solution. 
              Good track record of publishing code examples which are clearly documented, with Revision History. 
              Applications and other code are exemplary models of well-engineered code that can be taken and easily  modified for alternative uses.
Obviously represents my own very personal POV. I do have (surprise) an alter ego, who insists that I add the following :
Code:
Beginner:     Wants someone on the list to write the whole application.
              Problem specification written in some language which only vaguely resembles the English of a drunken idiot.
Intermediate: Can't figure out why anyone on the list wouldn't want to write the application.
              Problem specification sounds like English, but doesn't quite make sense 
              (maybe that's why it would be neat to have someone else write the app)
Advanced:     Problem statement is generally succinct, with relevant excerpts of code to assist 
              the other poor souls on the list figure out what (s)he's trying to get at.
Expert:       Doesn't need problem statement, 
              Has already solved the problem, and many more like it.
Tony (Struggling towards Intermediate!)
tfurnivall is offline   Reply With Quote
The Following 6 Users Say Thank You to tfurnivall For This Useful Post:
chohan78 (10-06-2015), Ghostman (11-03-2014), hassanogaibi (06-28-2016), Jon (09-10-2013), Lightwave (11-17-2016), psyc0tic1 (10-01-2018)
Old 09-25-2013, 01:37 PM   #3
gbil
Newly Registered User
 
Join Date: Aug 2013
Location: Zamboanga City, Philippines
Posts: 26
Thanks: 13
Thanked 1 Time in 1 Post
gbil is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

Quote:
Most application code is object oriented, with user defined classes capable of inheriting other classes.
User has established several utility libraries, and knows how to keep them as external files, using Tools|References to bring them in.
User is comfortable using split DB where one or other of the components is on a separate machine.
Comfortable using other DB engines than Jet. Code routinely has clearly defined transactions, including Commit and Rollback.
Application routinely includes user authentication (possibly from a different server).
If I may, I think I need to learn these things.

gbil is offline   Reply With Quote
The Following User Says Thank You to gbil For This Useful Post:
hassanogaibi (06-28-2016)
Old 09-25-2013, 03:14 PM   #4
Galaxiom
Super Moderator
 
Join Date: Jan 2009
Location: NSW Australia
Posts: 11,638
Thanks: 95
Thanked 1,498 Times in 1,413 Posts
Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold Galaxiom is a splendid one to behold
Re: How to go from Intermediate to Advanced - please help

One important phase to pass from Intermediate to Advanced is a few times around the cycle of realising that one is not intermediate at all but really still a beginner.

There are so many aspects to using Access and VBA that it is impossible to comprehend the extent of one's inexperience for quite a long time.
Galaxiom is offline   Reply With Quote
The Following 2 Users Say Thank You to Galaxiom For This Useful Post:
hassanogaibi (06-28-2016), Uncle Gizmo (11-17-2016)
Old 09-25-2013, 05:25 PM   #5
tfurnivall
Newly Registered User
 
Join Date: Apr 2012
Posts: 81
Thanks: 8
Thanked 9 Times in 4 Posts
tfurnivall is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

Ain't that the truth!

Tony
tfurnivall is offline   Reply With Quote
The Following User Says Thank You to tfurnivall For This Useful Post:
hassanogaibi (06-28-2016)
Old 03-12-2014, 05:37 AM   #6
Charmagne
Newly Registered User
 
Join Date: Aug 2013
Posts: 15
Thanks: 6
Thanked 1 Time in 1 Post
Charmagne is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

Anyone have recommendations on training classes in the Chicago area or resources were we could advanced through the levels?
Charmagne is offline   Reply With Quote
The Following User Says Thank You to Charmagne For This Useful Post:
hassanogaibi (06-28-2016)
Old 08-29-2014, 05:22 AM   #7
Immaster
Newly Registered User
 
Join Date: Aug 2014
Posts: 11
Thanks: 0
Thanked 1 Time in 1 Post
Immaster is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

Thanks alot for this

Immaster is offline   Reply With Quote
The Following User Says Thank You to Immaster For This Useful Post:
hassanogaibi (06-28-2016)
Old 03-21-2016, 12:42 AM   #8
NauticalGent
Pristine Curmudgeon
Gold Supporter
 
NauticalGent's Avatar
 
Join Date: Apr 2015
Location: Naples, Italy (EXPAT from Virginia)
Posts: 1,990
Thanks: 440
Thanked 295 Times in 256 Posts
NauticalGent has a spectacular aura about NauticalGent has a spectacular aura about
Re: How to go from Intermediate to Advanced - please help

Quote:
User has established several utility libraries, and knows how to keep them as external files, using Tools|References to bring them in.
I did not know this was even possible. Is there a reputable place (Website) that expounds upon this?
NauticalGent is offline   Reply With Quote
The Following User Says Thank You to NauticalGent For This Useful Post:
hassanogaibi (06-28-2016)
Old 04-27-2016, 09:30 PM   #9
stevekos07
Newly Registered User
 
Join Date: Jul 2015
Posts: 169
Thanks: 18
Thanked 8 Times in 8 Posts
stevekos07 is on a distinguished road
Talking Re: How to go from Intermediate to Advanced

Quote:
Originally Posted by tfurnivall View Post
What a silence......!

At the risk of being flamed, let me offer some suggestions:
Code:
Beginner:     Uses (primarily) the built-in tools to create apps. 
              Little or no VBA; 
              Tables may or may not be normalized (Huh? What's that?)

Intermediate: Comfortable using form events. 
              Probably not using OO approach for the main part of the code.
              Tables generally normalized - most of them with an AutoNumber Primary Key. 
              Maybe secondary indices.  
              Little or no use of Office Automation; 
              DB is typically single DB - no splits. 
              Occasional use of Unbound forms. 
              Code is generally well commented, but not subject to rigorous management.

Advanced:     Tables routinely normalized, 
              Most application code is object oriented, with user defined classes capable of inheriting other classes. 
              User has established several utility libraries, and knows how to keep them as external files, using Tools|References to bring them in. 
              User is comfortable using split DB where one or other of the components is on a separate machine. 
              Comfortable using other DB engines than Jet. Code routinely has clearly defined transactions, including Commit and Rollback. 
              Application routinely includes user authentication (possibly from a different server).

Expert:       Good track record of helping others in clear, concise helpful language. 
              Provides just enough help to allow 'further research' on the part of the questioner to yield a solution. 
              Good track record of publishing code examples which are clearly documented, with Revision History. 
              Applications and other code are exemplary models of well-engineered code that can be taken and easily  modified for alternative uses.
Obviously represents my own very personal POV. I do have (surprise) an alter ego, who insists that I add the following :
Code:
Beginner:     Wants someone on the list to write the whole application.
              Problem specification written in some language which only vaguely resembles the English of a drunken idiot.
Intermediate: Can't figure out why anyone on the list wouldn't want to write the application.
              Problem specification sounds like English, but doesn't quite make sense 
              (maybe that's why it would be neat to have someone else write the app)
Advanced:     Problem statement is generally succinct, with relevant excerpts of code to assist 
              the other poor souls on the list figure out what (s)he's trying to get at.
Expert:       Doesn't need problem statement, 
              Has already solved the problem, and many more like it.
Tony (Struggling towards Intermediate!)
An advanced user is someone who has not just done a single day course by a commercial "training company" and issues an "Advanced Access Programmer" certificate to everyone in the class including those who finish the day still trying to work out how to use a mouse.
stevekos07 is offline   Reply With Quote
The Following User Says Thank You to stevekos07 For This Useful Post:
hassanogaibi (06-28-2016)
Old 10-25-2016, 02:30 PM   #10
mjdemaris
Working on it...
 
Join Date: Jul 2015
Location: Washington State, USA
Posts: 362
Thanks: 80
Thanked 7 Times in 7 Posts
mjdemaris is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

@tfurnivall:
Wow, what a great definition of the various levels of abilities. I find my self in a mixture of the levels, definitely not Expert!
__________________
Life is not a problem to be solved, but a reality to experience.

Soren Kierkegaard
mjdemaris is offline   Reply With Quote
Old 11-17-2016, 01:53 AM   #11
Lightwave
Ad astra
 
Lightwave's Avatar
 
Join Date: Sep 2004
Location: Edinburgh
Posts: 1,401
Thanks: 123
Thanked 137 Times in 129 Posts
Lightwave will become famous soon enough
Re: How to go from Intermediate to Advanced - please help

Likewise I think its an excellent description of the different levels.

I must say Galaxioms point from 2013 is excellent as well

Last edited by Lightwave; 11-17-2016 at 02:23 AM.
Lightwave is offline   Reply With Quote
Old 11-17-2016, 08:34 AM   #12
mjdemaris
Working on it...
 
Join Date: Jul 2015
Location: Washington State, USA
Posts: 362
Thanks: 80
Thanked 7 Times in 7 Posts
mjdemaris is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

@Lightwave:
After starting my second major project, and now almost finished, I am still a beginner.
__________________
Life is not a problem to be solved, but a reality to experience.

Soren Kierkegaard
mjdemaris is offline   Reply With Quote
Old 01-06-2017, 03:09 AM   #13
Acceesbility
Newly Registered User
 
Join Date: Jan 2017
Posts: 32
Thanks: 7
Thanked 0 Times in 0 Posts
Acceesbility is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

Interesting post.
Access fascinates me. I manage enough for my small personal purpose of searching simple data, parts and part numbers etc.
Problem is I probably spend more time tweaking poorly constructed mdb's.
It's okay for myself but I wouldn't want to share it
I thought I'd give Access 2003 another try as that's the version I have.
I do wonder if that's wise considering the number of Versions since Access 2003

Not sure that Beginner would be me, more kindergarten !

Thanks to those (and their patience) in the forum on this interesting site who have pointed me toward a structured resources in response to my forum posts.

Acceesbility is offline   Reply With Quote
Old 03-09-2017, 04:35 PM   #14
stevekos07
Newly Registered User
 
Join Date: Jul 2015
Posts: 169
Thanks: 18
Thanked 8 Times in 8 Posts
stevekos07 is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

Great post! I have undertaken all sorts of training, and mostly I find that I have to work things out myself in the end. Class study is almost useless to develop real-world skills. Like anything else learning comes by practice, practice, practice! And there are some skills most of us will never develop because the learning curve to be able to do a particular task once is so huge that the cost/benefit ratio is off the scale to the negative.

I am just putting my toe in the water developing small databases for small businesses, while establishing a collaborative relationship with a well established professional company. For me this is the best of both worlds. I can call them in if a project I am scoping has aspects that I can't handle, and I can learn skills as I watch the experts deal with it, and they can offer me some work appropriate to my skills that they need help with.

Just my 2c.
stevekos07 is offline   Reply With Quote
Old 03-10-2017, 08:54 AM   #15
mjdemaris
Working on it...
 
Join Date: Jul 2015
Location: Washington State, USA
Posts: 362
Thanks: 80
Thanked 7 Times in 7 Posts
mjdemaris is on a distinguished road
Re: How to go from Intermediate to Advanced - please help

Steve, how did you go about establishing such a beneficial relationship with a professional company? I would like to do the same, but am unsure about who to approach and how.

__________________
Life is not a problem to be solved, but a reality to experience.

Soren Kierkegaard
mjdemaris is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Acces developer & intermediate VBA programmer from AZ clobfaz Introduce Yourself 3 06-20-2012 01:11 PM
Need some advanced help smig Visual Basic 0 11-09-2011 10:08 AM
Query to return intermediate values kiwijules0505 Queries 3 12-12-2007 01:58 PM
datasheet lookup, with intermediate relationship Conor Tables 2 05-04-2007 12:55 AM
Referential Integrity with intermediate table DataMiner Theory and practice of database design 3 11-28-2006 04:15 PM




All times are GMT -8. The time now is 06:11 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World