Microsoft Access is all about simplicity. Access empowers you to make the most of your information—even if you’re not a database expert. And, through newly added Web databases, it amplifies the power of your data, making it easier to track, report, and share with others. Your data will never be further away than your closest Web browser.
Get started faster and easier than ever before.
Harness the power of the community in Access. Build on database templates created by others and share your own designs. Use new prebuilt database templates available on Office Online, designed for frequently requested tasks, or select from community-submitted templates and customize them to meet your specific needs.
Create a centralized landing pad for your data.
Integrate your Access reports using multiple data connections and information linked or imported from other sources. With improved Conditional Formatting and calculation tools, you can create rich and dynamic reports with visual impact. Access reports now support data bars, enabling you and your audience to more easily track trends and gain insight.
Access your application, data, or forms from virtually anywhere.
Extend your database to the Web so that users without an Access client can open Web forms and reports via a browser and changes are automatically synchronized.1 Or work on your Web database offline, make your design and data changes, and then sync them to Microsoft SharePoint Server when you’re reconnected. With Access and SharePoint Server, your data can be protected centrally to meet data compliance, backup, and audit requirements, providing you with increased accessibility and manageability.
Apply professional designs across your Access database.
Take advantage of familiar and appealing Office themes and apply them to your databases with high fidelity both on the Access client and the Web. Choose from a variety of themes, or design your own custom theme, to get great looking forms and reports.
Add navigation to your database using drag-and-drop functionality.
Create professional looking, Web-like navigation forms to make your frequently used forms or reports more accessible without writing any code or logic. Choose from six predefined navigation templates with a combination of horizontal tabs or vertical tabs. Applications with a large number of Access forms or reports can be displayed using multi-level horizontal tabs. Simply drag-and-drop forms or reports to display.
Accomplish your work more quickly and easily.
Access simplifies how you find and use features. The new Microsoft Office Backstage™ view replaces the traditional File menu to let you publish, back up, and manage your database with just a few clicks. And, with the improved Ribbon, you can access your favorite commands even more quickly by customizing tabs or creating your own to personalize the experience to your work style.
Build your expressions effortlessly using IntelliSense.
The simplified Expression Builder makes it faster and easier for you to build out logic and expressions in your database. IntelliSense — Quick Info, ToolTips, and AutoComplete — enables you to reduce errors, spend less time memorizing expression names and syntax, and spend more time focusing on building application logic.
Design your macros faster than before.
Access has a revamped Macro Designer that makes it easier to create, edit, and automate database logic. The Macro Designer enables you to be more productive, reduce coding errors, and easily incorporate more complex logic to create robust applications. Increase code maintainability by using Data Macros to attach logic to your data, centralizing the logic on the source tables. With the more powerful Macro Designer and Data Macros, you can extend automation outside the Access client to SharePoint Web databases and other applications that update your tables.
|License term in years
|Compatible operating systems
||Windows XP SP3, Windows Vista SP1, Windows Server 2003 R2 + MSXML 6.0, Windows Server 2008 (32/64-bit), Windows 7
Office Access, Win32, Microsoft Open Licence Program, 1 user, EDU, Open no level, single language
Office Access, Win32, Microsoft Open Licence Program, 1 user, EDU, Open level C, single language
Office Access, Win32, Microsoft Open Licence Program, 1 user, Open no level, single language
SmartOptimize report - health check, rulebase and database optimization