- Database design (SQL Server, MS ACCESS, MySQL, Cloud Database).
- Front End Application Design – Forms, data entry, process flow logic, Reports, connectivity with other Apps.
- Hybrid Front Ends, using both Cloud and local server database tables.
- SQL Queries; static/dynamic.
- Reports – Summaries, Grouping, Crosstabs, Pivot tables, Graphs.
- Custom Report builder tools for User generated ad-hoc reports.
- MS Office Automation/Integration using VBA.
- Email integration with Outlook – functions to build detailed email from database data; automated run, save & attaching of Reports; Automated sending to specific database list(s).
- WORD Integration – pass Access database data into WORD pre-formatted fields (Contracts, Legal documents, etc).
- Convert Excel to Access or other database application.
- Excel Applications, forms, Macros, Pivot tables, Charts, Integration, VBA, automated import and export.
- Version and OS conversions.
- Quickbooks Integration – directly pass data from database applications into Quickbooks (Invoices, Orders, etc).