Introduction To Active Table Editor
Understand why Active Table Editor exists and how it helps users edit lookup tables, run reports, and work with database data.
OverviewStart with the introduction if you are new to Active Table Editor. If you already know the product, jump straight to lookups, forms, reports, stored procedures, or security settings.
Understand why Active Table Editor exists and how it helps users edit lookup tables, run reports, and work with database data.
OverviewCreate lookup tables, design menu items, and connect database values to user-friendly editing screens.
LookupsBuild data input forms so users can edit records through controlled screens instead of raw tables.
FormsReview import and export workflows, including common data import problems and how to handle them.
Data movementUse the reports designer to give users operational reports without asking them to write SQL.
ReportsRun stored procedures from Active Table Editor so approved database actions are available from the user interface.
SQL actionsConfigure security settings so users see only the tables, forms, reports, and actions they are allowed to use.
PermissionsDesign forms and lookup editors so users can edit database records without working directly in database tools.
Create reports, import data, export records, and handle everyday database maintenance tasks.
Expose stored procedures and approved SQL-side operations from a controlled interface.
Configure security so each user sees only the forms, reports, menus, and actions they should use.
Download the Active Table Editor trial before following the tutorials.