hi people, i have a nagging question that ive been constanly asking myself. Now i am turning this question to you experts here for some 3rd party advices/opinions
i am in the midst of going through literature on sql, vba (know nuts abt these) and as i go through, for example sql, i note that what most of the codes and statements achieve can be accomplished in the GUI version, by icons manipulation. i know the icons activate the codes in the background to execute commands and no doubt understanding and knowledge of the codes will be useful but the question is how much more useful? is the benefit of learning sql, vba greater than the cost of acquiring that kind of knowledge and expertise?
i am not too sure abt the general demographic of the members in this forum - whether most are programmers, excel apps developers etc .. but i am a financial analyst who works with ms access and excel (mostly excel). access is used only to store years worth of data and report extraction. wldnt claim to be an expert but i am rather familiar with excel, access GUI .. as in for example, slicing and dicing data with excel formulas and using query design views in access to manipulate data.
ive posted a few mails here regarding vba,sql issues that i tried to build into my files and i am very grateful to the feedback and assistance i got that helped me to fix the issue and move on my work. but i dont really want to just come here and post what i dont understand, get something in return which i still dont understand but work anyway. but then the burning question is how much do i really need this knowledge .. there is also a concern that future technologies may make apps more "user friendly" and emphasis on GUI with more codes and commands already built into the appls ..for example, MS excel 2007 has a feature called "remove duplicates" and it does as the name implies .. which is a function i used to do manually on an excel 2003 spreadsheet or on a "no duplicate" query on access. So future versions may eliminate the need to know vba, sql and could allow user to just execute functions (with click of buttons)that are currently possible only by user self man vba, sql codes.
in other words, i am grappling with the "you-dont-have-to-know-how-a-TV-works-to-enjoy-it" paradox, if i may use this
sorry if this question seems naive and "noobish" but obviously i do not know enough of sql, vba and the depth of their content to make an accurate assessment of their potential and how much can be accomplished with them, except that i think sql is for data manipulation / extraction while vba is for automation with some sql content (i guess this statement shows my lack of knowledge?? )
anyway appreciate some feedback as i am on a crossroad, having a couple of things like work, studies on the plate so gotta channel resources (in this case, time) to the most productive areas.. and so need some sort of "light at the end of the tunnel" to guide me ..
Thanks people!!!
i am in the midst of going through literature on sql, vba (know nuts abt these) and as i go through, for example sql, i note that what most of the codes and statements achieve can be accomplished in the GUI version, by icons manipulation. i know the icons activate the codes in the background to execute commands and no doubt understanding and knowledge of the codes will be useful but the question is how much more useful? is the benefit of learning sql, vba greater than the cost of acquiring that kind of knowledge and expertise?
i am not too sure abt the general demographic of the members in this forum - whether most are programmers, excel apps developers etc .. but i am a financial analyst who works with ms access and excel (mostly excel). access is used only to store years worth of data and report extraction. wldnt claim to be an expert but i am rather familiar with excel, access GUI .. as in for example, slicing and dicing data with excel formulas and using query design views in access to manipulate data.
ive posted a few mails here regarding vba,sql issues that i tried to build into my files and i am very grateful to the feedback and assistance i got that helped me to fix the issue and move on my work. but i dont really want to just come here and post what i dont understand, get something in return which i still dont understand but work anyway. but then the burning question is how much do i really need this knowledge .. there is also a concern that future technologies may make apps more "user friendly" and emphasis on GUI with more codes and commands already built into the appls ..for example, MS excel 2007 has a feature called "remove duplicates" and it does as the name implies .. which is a function i used to do manually on an excel 2003 spreadsheet or on a "no duplicate" query on access. So future versions may eliminate the need to know vba, sql and could allow user to just execute functions (with click of buttons)that are currently possible only by user self man vba, sql codes.
in other words, i am grappling with the "you-dont-have-to-know-how-a-TV-works-to-enjoy-it" paradox, if i may use this
sorry if this question seems naive and "noobish" but obviously i do not know enough of sql, vba and the depth of their content to make an accurate assessment of their potential and how much can be accomplished with them, except that i think sql is for data manipulation / extraction while vba is for automation with some sql content (i guess this statement shows my lack of knowledge?? )
anyway appreciate some feedback as i am on a crossroad, having a couple of things like work, studies on the plate so gotta channel resources (in this case, time) to the most productive areas.. and so need some sort of "light at the end of the tunnel" to guide me ..
Thanks people!!!