Send us an Email describing your Access, VB, and/or SQL needs
|
Send us an Email describing your Access, VB, and/or SQL needs
|
  | When Excel becomes too difficult!Many projects start life as an Excel spreadsheet. Eventually they can become too big or too unwieldy to handle in Excel. Scale is usually the issue -- what was appropriate and handy at first grows into something that gets harder and harder and the cost/benefit ratio goes down. The solution is usually to move to Access. There is considerable cross over between the two systems. Many problems began in a way that could be solved by either system -- Access is oriented around managing data; Excel is for analysis and reporting with good data management abilities. Eventually some Excel projects reach the point where they need database management.
Email us to discuss your problem |
|
| |||||||||||||||||||||||||||||||
 | Eliminate simple typo errors. |
| Complex rules can be written programmatically |
| Use complex selection criteria |
| Greater consistency |
| Enhanced reporting |
| Continue to use Excel where it works best |
Your Access application can still be seen and analyzed in Excel! The harder parts -- date entry, manipulation rules and queries have become clearly expressed in Access.
A hybrid solution often works in another way: Access can read your Excel work sheets, get the data and perform calculations and put summaries into the cells you would have had to populate.
|
From here you can go: [Midway Home Page] [ Site Map ] And at the next level down (if any): |