Microsoft Access language

Question

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

Answer 1

hi, here is a nice description about VBA and VB:

https://en.m.wikipedia.org/wiki/Visual_Basic_for_Applications

Answer 2

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.

Answer 3

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.

Answer 4

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

Answer 5

Would sql work for queries on access?

Answer 6

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.