There are two ways to automatically create a page for users to activate their account. The first is a checkbox in the User Registration Wizard. The second is applying the Create Activation Page server behavior from the Application panel, Server Behaviors -> + -> MX Kollection -> User Login -> Advanced -> Create Activation Page.
The following dialog box will appear:

Create Activation Page will generate an Update Transaction to change the value of the active column in your database table. Ideally, the active column should be a boolean type (Y/N).
Also, the generated activation page acts as a redirect after the Update Transaction occurs. The user will be sent to either the login page, or they will be automatically logged in. This depends on whether or not a random key has been set up in your database.
Below is a list of the server behaviors generated by the Create
Activation Page server behavior:

Note: If you use this server behavior
on the ColdFusion server model, a file named
Application.cfm will be automatically generated
in the site root folder. Do not delete this file, as it contains settings
related to session variables used by the server behavior and the current
application. If you remove this file or modify it, application pages that
use sessions will not function properly.