Introduction to MS Access

In Chapter 9, you learned how to convert VBA Structured Query Language (SQL) statements designed to work with linked tables. Using MySQL functions will simplify retrieving results from the data while keeping the processing on the MySQL server and therefore speeding up the MS Access application. In this chapter, you will migrate the MS Access data processing over to the MySQL server to speed up the application. You will do this using passthrough queries. You will learn how to integrate MySQL-based functions, procedures, and views with MS Access VBA code and passthrough queries. You will learn how to create parameterized procedures, how to pass parameters into them for filtering, and how to use the returned data.