Introduction

Purpose

Quite often it is necessary to give the user ability to edit data in the database or generate reports because not everything can be automated.

Active Table Editor features list

Manual Data entry

Very common request users may want to enter payments or invoices in some of the database tables plus they may want to design their own data entry screens

Import

Import is very important because everyone wants to avoid entering data twice.

Export

Same as above this should work correctly with excel as the favorite data format for most of the users

Calculations

Most of the calculations are performed inside the database so it must be very easy to run stored procedure just by pressing a button

Printing

Again it is hard to imagine modern application without the ability to print the data

Reports

Ability to design reports is also very important

Security

Users want to control who can see what and who is able to modify the data. This is usually done by creating user groups and giving them access to certain objects

The best way to learn Active Table Editor is to watch video’s. They are very shot and designed to explain one function. Documentation provides more detailed information.