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.
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 is very important because everyone wants to avoid entering data twice.
Same as above this should work correctly with excel as the favorite data format for most of the users
Most of the calculations are performed inside the database so it must be very easy to run stored procedure just by pressing a button
Again it is hard to imagine modern application without the ability to print the data
Ability to design reports is also very important
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.