Professional developers, who are looking for advanced data manipulation capabilities, have the option to write VBA (Visual Basic for Applications) code and store it in modules.ĭata can also be imported from other sources, such as Excel spreadsheets, Access databases, text and XML files, ODBC databases, Outlook folders, SharePoint servers, dBase, and more. Access features a so-called 'Design View', which illustrates tables as boxes, allowing you to test relationships, manage dependencies and build macros. You can easily organize data into tables, build queries or forms, and chain them together using macro commands. Create database tables or import data from various sources 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. The enhanced ribbon interface offers you easy access to every command, but you can personalize the user experience by customizing tabs and toolbars as you consider fit.Īccess enables you to create new databases, but also conveniently start by modifying one of the available sample templates. Regular users of other Office family products are going to enjoy the familiar look and feel of the application.

Familiar look and built-in template collection It provides a flexible database management system that enables you to organize important information easily even if you are not a database expert, going even further and managing to help you build reliable database apps for your business. Around since 1992, Access is integrated into the Microsoft Office suite.Īlthough designed for a more complex purpose than simply handling data in small databases, Microsoft Access has been created with simplicity in mind. When it comes to managing databases, Microsoft Access is one of the reference tools on the market.

Ms access mac tril