Question

Describe a problem that may occur where it would be better to use Access to solve, rather than Excel.

Your initial answer must be a 2 to 3 paragraph response to the discussion question.  

Answer 1

Answer:-

things may find problem to use access rather than Excel:-

Hard to learn: You can say that Microsoft Access is the Suite’s most advanced and complicated software.

With that in mind, the learning curve for Access is quite high. In fact, a few programming skills will prove quite helpful.

Experience is a must: You can quickly make a database. But to fashion it in an orderly manner and make it future-proof, you need experience.

Lots of planning should happen behind the scenes. Both skills, training, and experience are vital to figuring out how to best define normalized tables, link them, and structure the data so they’re easy to edit, query, view, and report.

Poor data visualization: Access is a no-go when it comes to visualizing data.

more issues:-

1. Windows and Office version dependant. Even though Microsoft tries to ensure backwards compatibility it doesn’t always succeed. To make things worst I’ve seen cases where Access had to be compiled on the target PC as simply copying a pre-compiled MDB did not work even when the source and target pcs have the same Windows & Office versions.
2. As Manas said, Access doesn’t have triggers and advanced functions (e.g. sheduled jobs like backups). You can do all this stuff but it requires complex coding and external programs/libraries.
3. Access’ VBA is an interpreted language. As such it is slow. You may never come across this problem till you try to do a nested loop through two recordsets with tens of thousand of records each.
4. Access tools for performance analyzing and optimizing the database are… well… non existent.
5. Access becomes terribly slow if you have more than 5–10 concurrent users even in a split (front/back end) database.
6. Access files are prone to corruption when they become too big (>100MB per mdb).