Access Database Development Languages

We speak multiple languages that can communicate with and control a database such as SQL, (Structured Query Language), a standard language used to manipulate and retrieve the data in databases.

VBA, (Visual Basic for Applications), which is the event driven programming language within Microsoft Access that allows a Microsoft Access Programmer to create and control functions within Access and other Microsoft Office products. Most Microsoft Office products utilize VBA, and a custom function created in Microsoft Access can create a report that would be output into Word, Excel, or Outlook. Exporting data from an Access database to other Microsoft Office products like Word, Excel or Outlook is a button press away using VBA. The Windows API, (Windows Application Programming Interface) which contains thousands of functions is also accessible using VBA to obtain the user or computer name for example.

The following Microsoft Office products include integrated VBA:

• Access
• Excel
• Office Shared
• OneNote
• Outlook
• PowerPoint
• Publisher
• Visio
• Word

We also speak the language of Recordsets using DAO, (Data Access Objects), or ADO, (ActiveX Data Objects). DAO and ADO allow an Access database programmer to create or modify virtually any data object within Microsoft Access down to an individual field of data.