Banner Image

Skills

  • VBA
  • Microsoft Access
  • VBA Programming
  • Database Design
  • Database Development
  • Access
  • Excel
  • Ms Excel
  • Microsoft Excel
  • Microsoft PowerPoint
  • Powerpoint Development
  • Powerpoint Presentations
  • Accounting
  • Data Analysis
  • Data Management

Sign up or Log in to see more.

Services

  • MS Access, MS Excel, VBA Databases

    $10/hr Starting at $100 Ongoing

    Dedicated Resource

    Samples of a few database applications designed and developed by me. Most of these applications are ready to install, or could be customized to meet specific needs within a very short course of time...

    AccessAccess ProgrammingAccountingAccounts PayableAccounts Receivable

  • Excel Access Data Sharing, Integration

    $10/hr Starting at $100 Ongoing

    Dedicated Resource

    Any query for Basic to Advanced Data Entry, Data Analysis, Data Conversion, Data Management, Graph/Charts, Reports, Mail Merge List, VBA Programming, MS Office Automation (MS Access, MS Excel, MS PowerPoint,...

    AccessApp DevelopmentData AnalysisData AuditData Conversion

  • Web Data Extraction and Management

    $10/hr Starting at $100 Ongoing

    Dedicated Resource

    Brief features: - Extract web data automatically (provided the desired site(s) do not have any restriction in data extraction) - Organize/Update Extraction schedules with alerts/reminders - Organize Data...

    AccessCollectionsData CollectionData EntryData Management

  • PowerPoint, PowerPoint/VBA Development

    $10/hr Starting at $50 Ongoing

    Dedicated Resource

    My PowerPoint services include: - New PowerPoint from a specific outline or theme Can also make Professional Templates, Interactive PowerPoint, animation with or without PowerPoint/VBA. With advanced...

    AnimationData ManagementMicrosoft PowerPointMs PowerpointPowerpoint

  • HOSPITAL CLINIC MANAGEMENT SOLUTION

    $10/hr Starting at $100 Ongoing

    Dedicated Resource

    Hospital/Clinic Management Application Program is a very powerful tool for patient management, pathology reporting, attendance / payroll and Accounting. It is suitable for any hospital, clinic, and diagnostic...

    Access ProgrammingClinic ManagementData ManagementDatabase DesignDatabase Systems

About

Access, Excel, VBA, Database Applications

I have extensive experience in managing large scale projects and can assist with consultancy, technical document creation and project management. I care for my clients and have very high work ethics.

My skills are:
- 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
- Total automation and/or Integrating between MS Excel, MS Outlook, MS Word, MS PowerPoint & MS Access
- Able to manage any project in Google Sheets, Google Docs with advanced usage of Google App Scripts.
- 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

Not a Developer only, I am a Professional Accountant too with advanced knowledge and skills in Financial Accounts Management. Some of my expertise in this range is:

- Preparation of management accounts/financial statements (Trial Balance, Profit and Loss Accounts, Balance Sheet, C a s h Flow and notes etc.)
- Bookkeeping in any accounting software
- Financial forecasting for business plan (P&L, Balance Sheet, C a s h Flow, Charts/Graphs)
- C a s h/Bank Reconciliations
- Payroll Management
- Fixed Assets Accounting
- Budgetary Analysis
- Creating Quick Database Tools (in MS Access and/or MS Excel) to convert manual accounts to generate financial statements, reports in any desired format.

Work Terms

Flexible (open to any proposal)

Attachments (Click to Preview)