The VBA language is derived from “Basic” language invented in 1964 that became popular on personal computers in the 1970’s. Visual Basic for Applications (VBA) is the programming language used in the Microsoft Office family of software products such as Excel and Access. The way to accomplish such customization is by adding code using the Visual Basic for Applications programming language. For example, the developer may wish to automatically correct bad data before it is saved in the database, show an alert if a business rule is violated, help the user navigate from one data entry form to another or launch a report with some custom filters.
Even with these tools, however, there may be situations where the developer would like to add even more functionality not already provided by the MS Access development tools. Various query builder and wizard tools ease this development process. Microsoft Access includes a number of features to allow database developers to create data entry forms, reports and queries that can guide users in querying existing data in the database and entering new data.
0 kommentar(er)
