Microsoft Access helps users manage digital databases in several popular formats. It is a part of the Microsoft Office software suite for Windows.

Brief description

This is one of the most popular engines for building complex databases with huge amounts of data that can be filtered and searched through in seconds.

You can create an empty project or utilize one of the provided templates. They include Contact List, Inventory, Sales Report and other types of simple databases. You are able to enter new values and sort the data using flexible filter settings.

There is a wizard instrument for creating complex queries. Selecting multiple search fields and configuring summary options is possible. To construct queries for MySQL databases users can download MySQL Query Browser.

There are tools to link the database with external Microsoft Excel tables. This connection allows both applications to exchange the data between each other. Text files in all popular formats can be imported into the project as well.

Advanced tools

This software offers you unique instruments for compacting and repairing massive databases. Flexible macro actions can be constructed for automatic maintenance of the data. Performance analyzer helps you evaluate the quality and health of the database.

There are extensive online tutorials and video lessons available for learning how to work with this powerful program.

Features

free to download and use;
allows you to build digital databases;
there are flexible settings for search queries;
there are several database templates available;
compatible with all modern versions of Windows.