Access VBA

Databases have evolved in various was for a long time, even from the MS-DOS days, when setting up a database was cumbersome, but a variety of tools made it possible to create systems that companies in a variety of ways, from invoicing, to stock control, sales, accounting and payroll, and also to store, process, and report data.

When Windows came along, Access made databases much easier to setup, and with VBA, it meant it could be used to create multi-functional applications with a database at its core, examples being integrated products, stock, sales and invoicing applications, and also data storage and indexing applications. Reporting tools also make it easy to export the data from queries to create professional looking reports, invoices, and other graphical representations of the data.

Recent versions of Access have brought many new features, to make creating powerful databases easier, with various templates. Databases can also be optimised for the Internet, with web forms, and reports, subject to a suitable web hosting package or web server.

VBA has played a pivotal role as databases have got more complex, once the tables and queries have been setup, reports that are based on the queries can be drawn up, and more importantly the data forms can be created. Forms are used to enter data into the tables, but these can also be used to create Button control panel to do some of the admin work, run a function, open a particular data entry form, and more.

Some more detailed articles can be found here on how Access can be used, more details on the way forms can be used, and examples of VBA.