Features: / Functions:
Features of the Microsoft Access 2010 Office app
The Microsoft Access 2010 Office app builds on the huge leaps in the 2007 edition by improving all 2007 features and adding a host of new features that offer greater convenience, efficiency and flexibility when entering, analyzing and reporting data.
Improved user interface - Access 2010 takes the new user interface that debuted in 2007 and makes finding jobs even simpler and more streamlined. This improves an even more thorough and well-designed taskbar with all necessary commands at the click of a button, without all the complicated searching required in previous editions.
Sharing Web Database - Databases can be of great use on a computer, but many databases really need to be shared and used by multiple users to be effective. With this latest version of Access this problem has been solved with web database conversion. You can now build a database or use a template from scratch and then convert it to a web database to share online. Access includes a Web Compatibility Checker to troubleshoot problems that make a database incompatible with the web database. The web database can then be shared on SharePoint for maximum availability for those who need it the most.
SharePoint integration - As mentioned above with parts of web databases, SharePoint is now more integrated in Access for more sharing and collaboration. However, this is just the beginning of the benefits of SharePoint, including new security benefits and saving of revision history.
Better automation with more of Macro and IntelliSense macros now has a new interface that makes it easier to build automation functions. Conditional automation requires no more than a few clicks in the streamlined new interface. This creates "triggers" that can fill in fields based on what you write elsewhere. IntelliSense has also been expanded with Expression Builder and Query Builder.
New Templates Access 2010 has expanded the number of available templates for users to handle more database needs. It is now possible to use templates for tracking contacts, events, students and assets, among others. With one click you have the entire database ready for you.
Better organized field options: field options are reorganized for more intuitive use. It is also possible to use groups of fields that create a collection of fields instead of a separate one. For example, if you click on the Address field, not only an address field, but also city, province and postcode are displayed at the same time.
Conditional formatting: Reports can now use conditional formatting to indicate which data is reaching certain conditions. This will affect access to the benefits that are already visible in Excel. For example, you can include data bars that better illustrate progress. With Conditional Formatting Rule Manager, you can create a list of the rules you want to add, delete, or charge for your report.
More from your insights - For the first time in Access 2007, layout and report views plus a navigation window are all included in the 2010 edition. As in 2007, these offer new and useful ways to sort and view your data.
Backstage view - In addition to the above views, there is now the Backstage view that allows users to easily execute commands across the entire database. Some of these come from the old file menu, such as New, but others are new in Access 2010 and are all collected for easier browsing and use.
Tabbed objects for easier access-As seen in Access 2007, you can now open multiple objects in the same database that are now displayed as tabs that are easy to click. This enables faster clicks between tables, forms, reports, queries and macros.
New data types - Building on the new data types available in the 2007 edition, such as multi-value fields, attachment data, enhanced memo fields, and calendar and date controls, you can now also save calculated fields with Access 2010. With calculated fields, you can save results of your calculations in the database.