Compare Microsoft Access and SQLite 
Microsoft Access vs SQLite
When assessing the two solutions, reviewers found SQLite easier to use, set up, and administer. Reviewers also preferred doing business with SQLite overall.
- Reviewers felt that SQLite meets the needs of their business better than Microsoft Access.
- When comparing quality of ongoing product support, reviewers felt that Microsoft Access is the preferred option.
- For feature updates and roadmaps, our reviewers preferred the direction of SQLite over Microsoft Access.
Of the many businesses I have worked for all have one thing in common. They track data in a spreadsheet. Access takes Data analysis to a new level. Many people don't know that if built correctly your database can cross reference between many fields of data...
It's a very simple form of database supporting small/medium size of data. It slows down exceptionally when queries are run on large datasets.
It allows a lot of reads and writes simultaneously and when you have an entire office accessing your database at once, caching and parallel access is essential.
the user interface needs to be more engaging
Of the many businesses I have worked for all have one thing in common. They track data in a spreadsheet. Access takes Data analysis to a new level. Many people don't know that if built correctly your database can cross reference between many fields of data...
It allows a lot of reads and writes simultaneously and when you have an entire office accessing your database at once, caching and parallel access is essential.
It's a very simple form of database supporting small/medium size of data. It slows down exceptionally when queries are run on large datasets.
the user interface needs to be more engaging
