You are here:
Using MS Access/Expert Profile
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
K = Knowledgeability C = Clarity of Response P = Politeness| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| Akshay | 04/19/13 | 10 | 1 | 10 | |
| Charles | 04/14/13 | 10 | 10 | 10 | Manish I am sorry I took so ..... |
| Tina | 02/19/13 | 10 | 10 | 10 | |
| Kundan | 01/29/13 | 10 | 10 | 10 | I very much like your comments you ..... |
| Ronald | 12/22/12 | 9 | 9 | 10 | Well answered |
Recent Answers from Manish Batola
2013-04-18 Display a username on form after login:
Hi Akshay, You need to do the following : 1.Create a Main Form which Opens first to allow the User to add his name along with his password. 2.This form should have a combo box e.g.(myemplst) which
2013-04-04 Access VBA:
Hi Charles, For the Vehicle Serial number to appear automatically in all the related vehicle tables you need to create a relational schema. This is a place where your Vehicles Serial no field is considered
2013-03-26 MS access table help needed:
Hi Kenneth, You will need to populate your master form with Combo/List boxes. The combo box/list box objects allows you to bring information from different tables and queries and have them stored in
2013-03-21 Access Query:
Hi Debbie, If your going to view the results of this query only on Screen, then I would suggest you base a Pivot form on this same query. The pivot form can help you get more insight at different date
2013-03-12 Creating a database:
Hi Marina, What you are about to create is a Mini CRM Software. CRM=Customer Relationship Management for a Car Rental Service. You will need the following table[s] and not just one. Master Tables:
Answers by Expert:
©2013 About.com. All rights reserved.