Features of Microsoft® Access® 2010

Microsoft Access 2010 is its easy to use and user-friendly interface. In Access 2010, if you have access to Access Services in Microsoft SharePoint Server 2010, you could create a Web database by using Access 2010. Users could use your database in a Web browser window, but you must use Access 2010 to make design changes. Although some desktop database features do not translate to the Web, you could do many of the same things by using new features, such as calculated fields and data macros.

For creating a new database you could use built-in templates and the design to make your work easy. This software is being used since a long time and hence you could trust it as better-suited database management software for your business needs. The best part is that you do not need to upgrade your software every year. Microsoft Access 2010 features are being improved and have become convenient after every update by the Microsoft.

Microsoft Access is a multi user database and thus more than one user could use the same database at the same time without facing any difficulties. The automated tools are available in the Microsoft Access 2010 like drag and drop to create buttons. You could create multiple databases for your business like customers details mailing address and financial details. You could display all these data in form of table, charts and worksheets. You could also use automated tools in case your database gets corrupted or MDB files are unreadable. Compact and repair is a tool provided by Microsoft that is used to compact your database to utilize extra space and to repair the database regularly so it could work efficiently. It also has expression builder that is used to create a lot of expression in Microsoft Access 2010.

• FIVE – Group of fields

  Microsoft Access 2010 changes the way that fields are added to the database by using a better list of the fields to insert. The Data Type gallery replaces the Add Field task pane and contains all of the common field types for the use in a database. One handy new feature here allows you to add certain groups of the fields called Quick Start selections as a collection rather than the adding one field at a time.

• FOUR – Macros and themes

  Macros function more like SQL triggers and they could be launched conditionally based on the actions taken within the database that not only improves performance but also could improve the user experience by allowing tasks to be automated. The office themes are supported in Access 2010 making customizations to the appearance of the databases much easier and more uniform than in the past. When using a form in Access you could apply a theme to it similar to the way themes could be applied in Word and PowerPoint.

• THREE – Create web forms, tables and reports

  You could also use Macro designer to create logics and generates XML codes. Microsoft Access 2010 permits you to use the attachment dialogue box that will let you make change in various files uploaded. Microsoft Access 2010 allows you to open the Attachments dialogue box that would enable you to make changes to some uploaded files. Updates are made to documents in the files they were first created in so if your attachment features an employees address in a Word document you would be required to make changes in this format.

• TWO – Web-ready database format

  The web is the new desktop in some environment and the Access team took this into consideration and provided a web-ready format for the databases. While previous versions of the Access allowed publishing to the web via scripting technologies to access the data Access 2010 makes Web publication even easier by making use of the Web Database type. This reduces the margin of the error when working with queries and expressions as well as the time spent looking up the spelling of field names in large databases.

• ONE –  Enhanced security

  The enhanced security features and the strong integration with the Microsoft SharePoint Foundation 2010 help you more effectively manage data and allow you to make your information tracking applications more secure than before. By storing your tracking application data in lists on SharePoint Foundation 2010, you could audit revision history recover deleted information and set data access permissions. The Office Access 2007 introduced a new security model that is carried forward and improved in Access 2010.

In Office Access 2007, there was limited support in the sharing a database to the web where you could only publish your lists and move the database to the document libraries. In the 2010 version, you could load an Office Access 2007 application with code or macros that are disabled to provide a more secure, Sandbox experience.