Skip to main content
TrustRadius
Microsoft Access

Microsoft Access

Overview

What is Microsoft Access?

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

Read more

Learn from top reviewers

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Return to navigation

Pricing

View all pricing

Microsoft Access

$139.99

On Premise
per PC

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

Workflow Builder for Microsoft Access Demo

YouTube

Use a File Dialog in Microsoft Access

YouTube

Open Source Simple LIMS Software for Small Lab Demo

YouTube

Microsoft Access Electronic Signature Capture Database Template

YouTube

Microsoft Access Database Tutorial - User form Login Security Demo

YouTube

Microsoft Access Project Management Database Template

YouTube
Return to navigation

Product Details

What is Microsoft Access?

Microsoft Access Video

What is Microsoft Access?

Microsoft Access Competitors

Microsoft Access Technical Details

Deployment TypesOn-premise
Operating SystemsWindows
Mobile ApplicationNo

Frequently Asked Questions

Microsoft Access is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.

Claris FileMaker are common alternatives for Microsoft Access.

Reviewers rate Usability highest, with a score of 7.

The most common users of Microsoft Access are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

(1-5 of 99)

Great for small database work

Rating: 5 out of 10
December 31, 2024
Vetted Review
Verified User
Microsoft Access
19 years of experience
  • Individual entry data points
  • Option for multiple individuals to access the database
  • Ability to view data in different views
Cons
  • Speed of functionality decreases as size of database increases
  • Complex programming sometimes take a long time to run
  • Both good and bad, all data is in a single file

Best in Business, Microsoft Access!

Rating: 9 out of 10
June 28, 2021
RV
Vetted Review
Verified User
Microsoft Access
2 years of experience
  • Very easy to create entity-relationship diagrams for various tables and designing mock layouts.
  • Really easy to navigate as it hold[s] the classic Microsoft UI. Another good thing is that it comes with the complete MS Office Suite.
  • It is really fast when joining multiple tables no matter what type of join.
  • Works on pretty much same SQL scripts so no need to learn a new language!
Cons
  • Need to backup very frequently, I have lost my work many times.
  • No version for Mac users, [I believe this is a] big limitation.
  • The ability to handle large database and multiple users.
  • UI is easy to use but [I feel it] can be improved a lot.

A powerful database that lets you organize your data as you like

Rating: 9 out of 10
June 24, 2021
PW
Vetted Review
Verified User
Microsoft Access
19 years of experience
  • Generates information about department events, services, orders, etc. quickly and in report form.
  • Easy to design forms and reports with drag and drop components. You don't need to know coding.
  • The ability to link tables and queries to get all the info needed for forms and reports
  • Forms and reports are easy to customize and edit.
  • Easily report your data grouped and sorted by any field
Cons
  • Microsoft Access has not really changed at all for several years. It might be nice to see some upgrades and changes.
  • The help info is often not helpful. Need more tutorials for Microsoft Access to show how to do specific things.
  • Be careful naming objects such as tables, forms, etc. Names that are too long can get cut off in dialog boxes to choose a table, form, report, etc. So, I wish they would have resizable dialog boxes to allow you to see objects with long names.
  • I wish it could show me objects that are not in use in the database for current queries, tables, reports, forms, and macros. That way unused objects can be deleted without worrying about losing a report or query because you deleted the underlying object.

Very powerful, but not easy to configure

Rating: 5 out of 10
May 19, 2021
  • Fully customizable
  • Forms enable customized easy entry
  • Reports can solve pretty much any need
  • Mailmerge and emails can automate any task.
Cons
  • Very high learning curve
  • Hard to code complex reports without a ton of time and skill
  • No support resources for reporting help.
Return to navigation