+ 2

Microsoft Access language

What language should I learn if I wanna write code tat works on Microsoft access? My company has a program that is run on Microsoft access and they want me to take over this program and update it. https://www.sololearn.com/discuss/1316935/?ref=app

13th Apr 2019, 1:59 AM
Cesr Ramirez
6 Answers
+ 4
hi, here is a nice description about VBA and VB: https://en.m.wikipedia.org/wiki/Visual_Basic_for_Applications
14th Apr 2019, 12:22 PM
Lothar - avatar
+ 5
Well, to be honest I don't know much about this field. But in my opinion I think they use C# to accomplish the task related to do stuff with Microsoft applications.
13th Apr 2019, 5:53 AM
Ayush Sinha
Ayush Sinha - avatar
+ 4
hi, Microsoft has an integrated language for all their Office products. This is called VBA which means Visual Basic for Applications. You can write applications with this language which can access all objects like access, word, excel or outlook. Using access also allows the user to design forms for a visual User Interface. Code editor and all stuff is availlable if you have Office installed. For your purpose its the preferred tool.
13th Apr 2019, 9:52 AM
Lothar - avatar
+ 3
I have worked several years with access. But I never used SQL direct as the visual creation of queries was much easier for me. But as far as I remember you can see the SQL statement for the current query. It should be possible to find more about that at Microsoft support web. Here is a good point for starting: https://support.office.com/en-us/article/Access-SQL-basic-concepts-vocabulary-and-syntax-444D0303-CDE1-424E-9A74-E8DC3E460671
13th Apr 2019, 2:31 PM
Lothar - avatar
+ 2
Would sql work for queries on access?
13th Apr 2019, 2:02 PM
Sonic - avatar
+ 1
I think VBA is fine for running code in Access (which I think is the scope of this question). If you want the program to be able to interact with other MS applications, maybe consider VB instead.
14th Apr 2019, 2:48 AM
Janning⭐ - avatar