AccUnit

Unit Testing in VBA - Microsoft Access, Excel, …

Getting started

From AccUnit
(Difference between revisions)
Jump to: navigation, search
 
(3 intermediate revisions not shown)
Line 3: Line 3:
[http://en.wikipedia.org/wiki/Software_testing Software testing] is a important part of software development.
[http://en.wikipedia.org/wiki/Software_testing Software testing] is a important part of software development.
-
During earlier tests at the end of the software development cycle as an acceptance condition,
+
In earlier days testing of a software was typically done at the end of the development cycle.
-
today's approach is to write the test before programming the logic of the application ([http://en.wikipedia.org/wiki/Test-driven_development TDD]).
+
Since this is very late to uncover severe problems, today's approach relies heavily on test automation. An important part for this is testing individual pieces of the code (unit testing). Even more, with [http://en.wikipedia.org/wiki/Test-driven_development Test-Driven-Development (TDD)] tests are written before implementing a part of the application.
-
Many actual programming languages ​​provide appropriate tools for automated test execution. The [http://en.wikipedia.org/wiki/Visual_Basic_for_Applications VBA]  programming language
+
Many actual programming languages ​​provide appropriate tools for automated test execution. The [http://en.wikipedia.org/wiki/Visual_Basic_for_Applications VBA]  programming language and the Code Editor (the VBE - Visual Basic Editor)
-
unfortunately only contains rudimentary functionality to test the code (Debug.Print, Debug.Assert).
+
unfortunately only contain rudimentary functionality to support testing of code (Debug.Print, Debug.Assert).
-
AccUnit now offers the possibility to run automated tests on MS Access. It uses the SimplyVBUnit, an Unit Testing Framework written in VB6.
+
'''AccUnit''' now offers the possibility to run automated tests on MS Access.
 +
 
 +
The following pages will help you to write the first tests for your application.

Current revision as of 21:55, 26 August 2024


Software testing is a important part of software development.

In earlier days testing of a software was typically done at the end of the development cycle. Since this is very late to uncover severe problems, today's approach relies heavily on test automation. An important part for this is testing individual pieces of the code (unit testing). Even more, with Test-Driven-Development (TDD) tests are written before implementing a part of the application.

Many actual programming languages ​​provide appropriate tools for automated test execution. The VBA programming language and the Code Editor (the VBE - Visual Basic Editor) unfortunately only contain rudimentary functionality to support testing of code (Debug.Print, Debug.Assert).

AccUnit now offers the possibility to run automated tests on MS Access.

The following pages will help you to write the first tests for your application.

Personal tools