Using MS Access/Expert Profile

Ask A Question


ALL MICROSOFT ACCESS DESIGN AND Development QUESTIONS which occur in a Access Projects Lifecycle. Can offer constructive help on Designing Advanced MS-ACCESS Applications such CRM/FRM(Follow-up),HSE-Health,Safety & Environmental Applications,School Management Systems,Hotel Software, Hospital Software,Chemicals Indenting,Import/Export,MRP - Manufacturing Resource Planning, ERP - Enterprise Resource Planning, Automotive Management Systems, Business Intelligence for Oil & Gas Drilling Operations, CRM,KPI- Key Performance Indicators,HealthCare, Hospitality, Constructions, Loyalty Clubs, Call Centers, Travel & Tourism, Educational Institutions, Industrial Strength Invoicing and many more being added every year.

Experience in the area

29+ yrs in the Software industry with 23yrs completely dedicated on more than 350 Various Microsoft Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.


Worked in various multinationals catering from Aerospace, Oil & Gas etc.


-BSc - Computer Science -MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineer (Software Development)

Past/Present Clients

Catered to various clients in the following industries • Oil & Natural Gas (BPM/CRM/Access Development) • Sales / Marketing (CRM) • Automotive (Automobile Dealers) • Logistics & Indenters (Import/Export) • HealthCare / Hospitals • Hotels 3* & 5* • Restaurants • Construction Co’s (Project Billing) • Clubs (Concept Selling) • Shoe-Chains • Solicitors/Lawyers • Call Centers • Aerospace (Preventive Maintenance) • Travel & Tourism • Computer Vendors • Manufacturing • Music Shops • Education • Data Warehousing • Health,Safety & Environmental Applications • Mud Engineering • School Management Software

What do you like about this subject?

This is an amazing tool for bringing and marrying different databases into one single pool. No Corporate firm will ever reveal the fact that they use MS-Access because of prestige, they might allways pick on the bigger giants. But the fact remains that all the middle work is done by MS-Access unknowingly.

What do you still hope to achieve/learn in this field?

Although I know so much about this subject, yet I feel I have to still explore & learn more. Nobody can say he knows complete MS-Access, this subject is so vast one will allways remain a student including myself.

Something interesting about this subject that others may not know:

This can serve as a wonderfull front-end to the worlds best databases. People consider Access to be very small, but if used properly you will be surprised to see what it can do for you. (Believe me I run some of the Major Operations of a Multinational using PURE ACCESS on a Middle Tier).

Something controversial or provocative about this subject

People allways compare it with Oracle. I feel Oracle should be compared with SQL-Server, then we are talking Muscle Power here.

Average Ratings

Recent Reviews from Users

Read More Comments

    K = Knowledgeability    C = Clarity of Response    P = Politeness
Oleg09/14/16101010Sorry, it does not work but thank .....
mehr03/11/16101010Thnx a lot sir
Maya05/22/1510Thank you Manish, your help was priceless .....
Maya05/21/1510Thank you Manish Batola
sher05/05/15101010Thanks for your reply, I know how .....

Recent Answers from Manish Batola

2016-09-13 Form property DataEntery=Yes prevents fields be filled out automatically:

Hi Oleg,  When you set a property such as dataEntry = Yes, it will open the form with blank fields for data entry. Under this circumstance if you want some fields to be filled out automatically then you

2016-08-09 adding stock:

Hi Hilde,    Usually in a Simply Inventory database you have Stock Inwards and Stock Outwards form. There will also be a Product Master table in which you will have the below fields    Product Name  Product

2016-07-28 MS-Access 2007 inventory management:

Hi Vimal,    In fact in a normal inventory system we have 2 forms, Purchases(Goods Inward) and Sales (Goods Outwards). But in your case I'm not seeing a Sales Form to record Goods going outward.You are

2016-07-06 Global Variable:

Hi Richard,    Your questions isn't very clear as to what you want to achieve, based on which I can suggest you a solution that can bring you closer to solving your problem.    Please let me know where

2016-03-10 access at back end and gui at front end:

Hello Mehr,    ODBC Driver is the solution.    Access can be a Back-end database for any front-end development tool in this world which can provide a ODBC Driver which can help in connecting to the Access


Ask A Question

Using MS Access

All Answers

Answers by Expert:

Ask Experts


©2016 All rights reserved.