Microsoft Access 2010
When it comes to managing databases, Microsoft's Access is one of the reference tools on the market. Around since 1992, Access is integrated into the Microsoft Office suite, but also distributed separately.
Designed with simplicity in mind, Microsoft Access provides a flexible database management system and enables you to easily organize important information, even if you are not a database expert.
Regular users of other Office family products are going to enjoy the familiar look and feel of the application. The enhanced Ribbon interface offers you easy access to every command, but you can personalize the user experience by customizing tabs and toolbars.
The application enables you to create a new database, but also modify existing sample database templates that others share on Office.com. One important feature is that you can create databases that are accessible from the Web, but in order to do that, you require access to a SharePoint website, configured for Access integration.
Users can easily organize their data into tables, build queries and forms and chain them together using macro commands. Professional developers, who are looking for advanced data manipulation capabilities, have the possibility to write VBA (Visual Basic for Applications) code and store it in modules.
Also, you can import data from other sources, such as an Excel speadsheet, another Access database, text and XML files, ODBC databases, Outlook folder, SharePoint, dBase and more. For instance, a web service can be used as an external data source, allowing you to add it to your database as a linked table.
The software also comes with an advanced report designer tool, in order to prepare your data for online viewing and printing. After choosing the report record source, the built-in wizard can guide you through the generation process step-by-step. Another alternative is to create a report from scratch using the 'Blank Report' feature.
Microsoft Access is a professional tool designed to help developers create database desktop and Web applications. Its capability to connect data sets stored across multiple platform, together with all the other professional tools for managing complex databases are what makes it one of the leading data management products out there.