Top IT companies like Amazon, CSC, Oracle, SAP, Infosys, Accenture, and Cognizant often require candidates with specialized Database and SQL skills.
Moreover, these skills are fundamental to a DBA and QA engineer job profile.
When you click on the Update Drop Downs button, the VBA code uses the “Data” worksheet as a table and then finds unique values for Products, Region and Customer Types and then populates them as List Items for the Combo Box controls.
Example for Products drop down What is important to notice here is how the Table and Fields have been identified using square brackets unlike traditional SQL where we just provide the name, also the table name has to be suffixed with a $ symbol at the end.
It is a database programming language which provides us the means to work with several types of databases like Oracle, MYSQL, and SQL Server.
In the days of excessive auditing, many ETL tools keep track of the number of inserts and number of updates being performed during batch data loads.
Here are a few examples of SQL being implemented from VBA.
Future tutorials in this series will expand on these techniques, and show you more things you can do with SQL in your Access databases.
These include Delete Queries (used to delete records from a table), Append Queries (used to add records to a table), Update Queries (used to edit records in a table) and Make Table Queries (used to create a new table).
Working from the Access query design window you are limited to the four query types described above, but using SQL in conjunction with VBA (or by entering SQL directly into the SQL view of the Access query design window) you can accomplish a lot more, including the use of "data-definition queries" which are used to build and modify the structure of the database itself.