Up to 1000x Faster Subqueries and Lookups, On-the-fly Caching Calculated Tables
Auto-Generate
SQL Queries & VBA
Auto-generate & Use Template, Framework & New Macro Events to avoid Boilerplate VBA Code
800+ New Query & Macro Functions
800+ PowerSQL™ Functions for Query/Macro Designers, VBA & SQL. Excel, Finance & Power Query-like functions like XNPV(), XTreasuryRate() & XNearestMinOrDefault()
Automate Import,
Export & Reports
Automated Report Generation, Import/Export & Syncing with Files & DBs.
PDF/Image & Website Data Extraction Automation Setup Services.
Finance, Accounting
& Compensation
Templates & Services for
Financial Planning & Analysis, Accounting, Forecasts, Payroll, Auto Commission Calculation, Budgeting, Ad-Hoc Reporting & BI Dashboards
iPad, Mac, Web,
Cloud & Mobile
Cloud-host on own PC/Server for Azure to enable simultaneous use of full Desktop features on iPad, Mac, Browser, PC Phones & Tablets
New Modernized
Tools & Templates
Global Find & Replace across all Queries/Fields/Records & Code
Smart Rename/Delete
Auto-generate Data Macros
& many other New Tools
Easy for End-Users to Edit & Maintain
No need to involve IT or Developer for Every Change (or at All) with Intuitive Excel-like Query Design & Excel User Database Building Tools Easy to Maintain/Edit Yourself
User View & Edit
Permissions
Limit what Forms, Reports, Records, Projects & Fields users can view, create & edit
User accounts, password login, and Device or Active Directory authentication
User & Row-Level Security
User-Level and Row-Level Security, User Accounts, Login & Remember Password or Active Directory authentication
Excel-to-Access/
SQL Conversion
Convert Excel Relative-Row Formulas to SQL Queries
Replace complex functions across many sheets & workbooks with a centralized database & iterative queries
500+ XLookup & QCriteria Functions
Dynamic lookups as first-class citizens with XLookup value escaping, null handling, & any number of {field, value} QParam(), QIsBetween() QIsAny(), criteria params
SQL Server & Azure Cloud Sync
Change-triggered Auto Syn to Azure, SQL Server or Excel or other DB
Refreshable Link from Excel & more even to Queries using VBA Functions
Logging, Telemetry & Diagnostics
Logging of errors, warnings, debug info, performance & with In-Access Viewing & to Files or Tables
World-class Expert Consulting & Support
Backed by top Access experts worldwide – the developers of PowerAccess, able to customize as needed