You are here:
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.
26+ yrs in the Software industry with 19yrs completely dedicated on more than 300 Various 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.
-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 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
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.
| User | Date | K | C | P | Comments |
|---|---|---|---|---|---|
| bianca | 10/03/11 | 10 | 10 | 10 | thank you. how would u suggest i ..... |
| khurram | 02/09/11 | 10 | 10 | 10 | Thanx Manosh I always received best responces ..... |
| Benjamin | 08/02/10 | 10 | 10 | 10 | |
| Khurram | 04/06/10 | 10 | 10 | 10 | Thanks a lot. you save me my ..... |
| Brad | 04/14/09 | 10 | 10 | 10 |
AssSalamwalaykum Shaymaa, You need to use the DateAdd() function to get the result you have in your example. Check out the example on http://office.microsoft.com/en-us/access-help/dateadd-function-HA001228810
Dear Bianca, It has to do with the YYYYMMDD date format of your data. You might try YYYY-MM-DD or MM/DD/YYYY formats. Different versions of Access accept different formats. Also check out this link
Dear Perry, You're attached image on the link provided seems to have been moved or deleted, due to which I cannot understand you're schema. Pls email me on manish@aqantassoftware.com with a cut/paste
Hi Helen, Your syntax should be =DSum("[DPrice]","tblPInfo","[DName]='Helen'" Check out this link for help on syntax, http://office.microsoft.com/en-us/access-help/dsum-function-HA001228829.aspx
Hi Khurram, -Whenever a .accdb file become greater than 10GB (in size) ?? First of all no .mdb or .accdb file can go above 2GB limit even under split constraints. Wish Microsoft could have done something
Answers by Expert:

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