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.
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.
Worked in various multinationals catering from Aerospace, Oil & Gas etc.
-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)
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 Cos (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
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.
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.
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).
People allways compare it with Oracle. I feel Oracle should be compared with SQL-Server, then we are talking Muscle Power here.
|Asad Ali||12/30/13||10||10||10||thanks very much Manish Batola|
|Raj||11/14/13||10||10||10||Thank u very much Manish. It's great .....|
Hi Jonathan, Comparing of Rows is performed using a common field existing in both the tables. Usually this field is a Primary key in one table which can be a Foreign key in another table OR both may
Hi Debbie, You will need to use a Crosstab query to produce this output. Make sure you index the correct fields to speed up the fetch process such as the "Number field" where the Survey question number
Hi Mehr, In Design View for the Form go to Properties - Events and set KeyPreview to YES. Then in the Form's Code Module Private Sub form_keydown(KeyCode As Integer, Shift As Integer) Select Case
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
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
Answers by Expert: