Using MS Access/Expert Profile


Ask A Question

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),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

27+ yrs in the Software industry with 21yrs completely dedicated on more than 350 Various Microsoft 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

-BSc - Information Technology -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 • 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
UserDateKCPComments
mehr07/16/14101010 
Asad Ali12/30/13101010thanks very much Manish Batola
Nagy12/23/13101010 
Raj11/14/13101010Thank u very much Manish. It's great .....
Akshay04/19/131010 

Recent Answers from Manish Batola

2014-07-29 MS Access - Saved Import File Path:

Hi Antony,  Try this:  Under navigation options, select to show system objects. Then in your table list, all your system tables will appear. Two tables are of interest here: MSysIMEXspecs and MSysIMEXColumns

2014-07-16 random number generation in a query:

Hi Mehr,  I feel you must create a separate log file to record dates and have it compared everytime you generate the question. Your code should look into this log file and compare the dates, you must check

2014-06-10 Dcount:

Hello Elie,    Date data types in SQL-Server are a little different then what you have in MS-Access. Please make sure your using the correct date data type for both your fields.    Please checkout this

2014-05-29 check value already available in subform:

Hello Vimal,    You will have to write code on the Event after the user deletes the record. Mostly this code will be on the OnClick Event of the Delete button.  The code should the checkbox based on the

2014-03-20 MS Access:

Hi Reenu,    Let's assume you have 3 fields    [Start Date]  [End Date]  [Employment Days]    Where [Employment Days] = [Start Date]until today's date.    You need to use a DateDiff() function.  Please

 

Ask A Question

Using MS Access

All Answers


Answers by Expert:


Ask Experts

Volunteer


©2014 About.com. All rights reserved.