Introducing G2.ai, the future of software buying.Try now

Compare LibreOffice Base and Microsoft Access

Save
    Log in to your account
    to save comparisons,
    products and more.
At a Glance
LibreOffice Base
LibreOffice Base
Star Rating
(15)3.8 out of 5
Market Segments
Small-Business (42.9% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about LibreOffice Base
Microsoft Access
Microsoft Access
Star Rating
(845)4.0 out of 5
Market Segments
Enterprise (38.7% of reviews)
Information
Entry-Level Pricing
No pricing available
Learn more about Microsoft Access
AI Generated Summary
AI-generated. Powered by real user reviews.
  • Users report that Microsoft Access excels in its integration with other Microsoft products, making it a preferred choice for enterprises that rely heavily on the Microsoft ecosystem. Reviewers mention that features like "Import/Export with Excel" streamline data management.
  • Reviewers mention that LibreOffice Base is favored by small businesses for its cost-effectiveness, as it is open-source and free to use. Users on G2 appreciate the "no licensing fees" aspect, which allows for budget-friendly database management.
  • G2 users highlight that Microsoft Access has a more robust query language, with features like "SQL View" that allow for complex queries, while LibreOffice Base's query capabilities are seen as more basic, which may limit advanced users.
  • Users say that Microsoft Access offers better support and documentation, with a quality of support rating of 7.9 compared to LibreOffice Base's 7.5. Reviewers mention that Access's extensive online resources make troubleshooting easier.
  • Reviewers mention that LibreOffice Base provides a more flexible data schema, allowing for easier modifications and customizations, which is particularly beneficial for users who need to adapt their databases frequently.
  • Users report that Microsoft Access has superior performance in terms of stability and scalability, with ratings of 8.0 and 7.4 respectively, making it a better choice for larger datasets and enterprise-level applications.
Pricing
Entry-Level Pricing
LibreOffice Base
No pricing available
Microsoft Access
No pricing available
Free Trial
LibreOffice Base
No trial information available
Microsoft Access
No trial information available
Ratings
Meets Requirements
7.5
8
8.4
707
Ease of Use
7.7
8
7.7
713
Ease of Setup
Not enough data
7.9
176
Ease of Admin
Not enough data
8.0
169
Quality of Support
7.5
8
7.9
564
Has the product been a good partner in doing business?
Not enough data
7.8
134
Product Direction (% positive)
7.1
8
6.2
709
Features by Category
Not enough data
Not enough data
Management
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Support
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Security
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Performance
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Database Features
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
LibreOffice Base
LibreOffice Base
Microsoft Access
Microsoft Access
LibreOffice Base and Microsoft Access are categorized as Desktop Database
Unique Categories
LibreOffice Base
LibreOffice Base is categorized as Relational Databases
Microsoft Access
Microsoft Access has no unique categories
Reviews
Reviewers' Company Size
LibreOffice Base
LibreOffice Base
Small-Business(50 or fewer emp.)
42.9%
Mid-Market(51-1000 emp.)
35.7%
Enterprise(> 1000 emp.)
21.4%
Microsoft Access
Microsoft Access
Small-Business(50 or fewer emp.)
34.3%
Mid-Market(51-1000 emp.)
27.0%
Enterprise(> 1000 emp.)
38.7%
Reviewers' Industry
LibreOffice Base
LibreOffice Base
Computer Software
14.3%
Accounting
14.3%
Telecommunications
7.1%
Retail
7.1%
Real Estate
7.1%
Other
50.0%
Microsoft Access
Microsoft Access
Information Technology and Services
7.6%
Hospital & Health Care
5.5%
Higher Education
5.5%
Computer Software
4.5%
Financial Services
4.0%
Other
72.8%
Most Helpful Reviews
LibreOffice Base
LibreOffice Base
Most Helpful Favorable Review
Verified User
G
Verified User in Higher Education

Just that it gives a alternative ms access in opensource

Most Helpful Critical Review
Verified User
G
Verified User in Computer Games

It doesn't support Insert, Delete, and Update statements through its query designer, and the SQL tool doesn't parse ANSI compliant SQL. It is therefore WORTHLESS. All but the most childlike of functionality is closed to it. If you want a functioning...

Microsoft Access
Microsoft Access
Most Helpful Favorable Review
Michael S.
MS
Michael S.
Verified User in Insurance

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...

Most Helpful Critical Review
Tapan J.
TJ
Tapan J.
Verified User in Marketing and Advertising

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.

Alternatives
LibreOffice Base
LibreOffice Base Alternatives
MySQL
MySQL
Add MySQL
PostgreSQL
PostgreSQL
Add PostgreSQL
SQLite
SQLite
Add SQLite
Microsoft Access
Microsoft Access Alternatives
OpenOffice Base
OpenOffice Base
Add OpenOffice Base
Memento Database
Memento Database
Add Memento Database
Axisbase
Axisbase
Add Axisbase
Discussions
LibreOffice Base
LibreOffice Base Discussions
Monty the Mongoose crying
LibreOffice Base has no discussions with answers
Microsoft Access
Microsoft Access Discussions
what is microsoft access used for
4 Comments
gail l.
GL
Microsoft Access helps you analyze large amounts of information, and manage related data more efficiently than Microsoft Excel.Read more
do you know other useful documentation besides those of Microsoft?
2 Comments
Michael H.
MH
Access for Dummies is actually pretty good.Read more
Is it reliable to use Access forms just like visual basic to build applications?
2 Comments
JR
If is a very small project is ok But it’s better use VB.net for create a program and store the data in MySQL or MMSQL or SQLite Read more