Using MS Access/Expert Profile

Manish Batola

India
On Vacation
returns 11/30/2009
Expertise

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),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 and many more being added every year.

Experience in the area

25 yrs in the Software industry with 19yrs completely dedicated on more than 250 Various Access Projects from different Industry Sector[s]. I'm using Access ever since it was born.

Organizations

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

Education/Credentials

-MSAP (Master in Software & Applications Programming) -BPRE (Business Process Re-engineering Engineer) -SQAE (Software Quality Assurance Engineer) -STIE (Software Testing & Inspection Engineer) -Project Engineeer (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

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    T = Timeliness    P = Politeness
UserDateKCTPComments
Brad04/14/0910101010 
desiree04/09/0910101010 
Dee02/19/0910101010Excellent assistance
Serge02/18/0910101010Thank you for this valuable info. You .....
Mark02/16/0910101010Always a great response! Even though I'd .....

Recent Answers from Manish Batola

2009-06-30 HELP ON ACCESS:

Hi Femi, -You can create a form each having a table as the forms backend (Entity A, Entity B, Entity C, Entity D). -Create a form assuming that will be your main form. -In this Main form you need

2009-04-09 Display best result according to parameter input in query:

Hi, The query will display results but will they really be best all depends on the data in your tables,cause this aint Artificial Intelligence like Prolog. In your query you need to add a Parameter

2009-04-08 combo box in ms access 2003:

Hi Desiree, Infact I'm not to clear which values you change and where. I assume that once data in the combo box is changed it triggers an update query running behind it to makes changes to values in

2009-04-07 Line in Report:

Hi Hasmukh, You need to create a Group on any of your fields with a Header and a Footer. You need to then place your complete line in the footer of the field you created a Header. This way your line

2009-04-05 MS Access 2000 tab control multipage form:

Hello Neil, Your question just ain't stupid, its logical cause I faced the same situation in 1999. Anyway what you need to do is really simple but with patients. The same controls LOOK like they appear

 

Ask A Question

All Answers

Answers by Expert:


Ask Experts

Volunteer


©2009 About.com, a part of The New York Times Company. All rights reserved.