Services I offer
- Building database with relational database modeling system to maintain data integrity and efficiency
- Developing/Upgrading database with user-friendly, nice looking GUI
- Developing database for standalone (single user) or multi-user environment featured with various levels of login and user privilege management
- Writing VBA module(s) to accomplish customized, advanced functionalities of databases
- Integrating between MS Excel, MS Word, MS PowerPoint & MS Access (exporting/importing XLS/CSV files, developing hybrid (Access/Excel) office applications)
- Writing SQL Queries to pull required data and generate analytical reports accordingly
- Writing advanced VB/VBA scripts in MS Access or MS Excel for Web Scraping, Web Extraction, Data Entry, Data Mining, Management and Analysis
- Designing professional PowerPoint presentations including or excluding integration with MS Access or MS Excel
- Conversion/Integration: MS Access/Excel, MS SQL Server, MySQL