Microsoft Access 2010 is a pseudo relational database management system that combines relational Microsoft jet database engine with graphical user interface and software development tools. It’s all about simplified ready-to-go template that stays relevant as the data grows. Through the newly added web databases, Access amplifies the power of data, making easier to track, report and share with others.
Start working faster & easier
Harnessing the power of community in Access 2010 and using the build on database templates created by others and sharing the designs are one of the excellent features of Microsoft Access 2010. Use the new prebuilt database template designed specifically for frequently requested task and select from community submitted templates and customize it.
Create centralized landing pad for data
The user can synchronize the Access reports using multiple data connections, information linked or imported from other sources. Using the improved conditional formatting and calculation tools, the user can create rich and dynamic reports with visual impact. The new Access 2010 report supports data bars and enabling the user to track trends and gain insight.
Access application, data, or forms virtually from anywhere
Database can be extended to the web so that the users without an Access client can open web forms and reports via browser and the changes are automatically integrated. Work on the web database offline, make design and data changes and synchronize to Microsoft SharePoint server 2010. With Access 2010 and SharePoint server 201, the data can be protected to meet compliance, backup and audit requirements providing increased accessibility and manageability.
Apply professional designs across Access database
Use appealing office themes and apply them to the database with high fidelity both on Access client and web. Choose variety of themes or designs and create great looking forms and reports.
Add navigation to database with drag-and-drop functionality
Create professional looking, web like navigation forms to make forms or reports accessible of writing any code or logic. Choose six predefined navigation templates with a combination of horizontal tabs or vertical tabs. An application with 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 the work more quickly and easily
Access 2010 simplifies the user, how to accomplish the work more quickly and easily using the new features. The Microsoft Backstage™ view replaces the traditional file menu to let the user to publish, backup and manage the database with just a few clicks. With improved ribbon, access the favorite commands, customize the tabs or create the personalize experience in work style.
Build expressions effortlessly using IntelliSense
The new expression builder enables the user to build out the logic and expressions faster and easier in the database. The Intellisense quick info, tool tips and AutoComplete enables the user to reduce errors, spend less time, memorize the expression names and syntax and spend more time focusing on building application logic.
Design macros faster
Access 2010 has restored macro designer that makes easier to create, edit and automate database logic. The macro designer enables the user to be more productive, reduce coding errors and easily incorporate complex logic to create robust applications. Increase code maintainability with data Macros to attach logic to data, centralizing the logic on source tables. With more powerful macro designer and data macros, the user can extend automation outside the Access client to SharePoint web databases and other applications.
Turn portions of database into reusable templates
Reuse the database parts built by other users in the database to save time and effort. Save frequently used Access objects, fields or collections of fields as templates and add existing databases and make more productive. Application parts can be shared across the organization to create consistency in building database applications.
Integrate Access data with live Web content
Connect to data sources via web service protocol and include web services and line-of-business applications data right in the databases through business connectivity services. The new web browser control enables the user to integrate web 2.0 content in the Access forms.
For more info about Microsoft Office 2010, read
- Microsoft Word 2010 – An Intro to Microsoft Word 2010 Web Version
- Microsoft Excel 2010 – Features & Benefits of Microsoft Excel 2010
- Microsoft PowerPoint 2010 – Microsoft PowerPoint 2010 Web Version
- Microsoft Outlook 2010 – Microsoft Outlook 2010 Advanced Version
- Microsoft SharePoint 2010 – Try Microsoft SharePoint Workspace 2010