Tips For Microsoft Access

Microsoft Access is a compact but powerful database software package that has been used by most small and mid-sized companies as a part of their IT implementation projects. It is actually a part of the Microsoft Office suite. Similar to the other office products, MS access also has undergone a lot of changes over the last several years and the last full-fledged version to have hit the market is MS Access 2010. It has a number of features that helps customers to manage data effectively and effortlessly.

With the adoption of the web as the standard medium of buying and selling of goods and services, MS access also has adapted to the change and has developed services for making Access a database tables that have been created for simple office applications to be available across the web.

Another important feature that is available in the latest version of MS Access (2010) is to make the old stand-alone access database table into a web ready database table. For this purpose, one has to make use of the compatibility checker that is provided along with the Access package. This checker will not only check for the older objects but will also convert the older database objects in to a web friendly database object. The back-end view of the access database helps the users in customizing the appearance of the MS access user interface. With this option, users can hide the ribbons and toolbars and also the navigation pane.

Another excellent utility available in the latest version of MS Access is the ability to share the reports generated in MS Access in other formats. This export utility makes it possible for the user to export the report in to other forms such as Excel, PDF and HTML In this way the report can be shared with other users who don’t have Access on their system.

In the latest version of Microsoft Access, it is very easy to share images across multiple forms and reports. The user has to add the image to the common image gallery and then call that image in to the required form or report. Smart tags can also be added to the database forms created in MS Access. This will simplify the process of providing additional look up information. Previously a separate web form had to be created for displaying such additional information. Now with the availability of smart tags, there is no need to create a separate form.

By: Mark J Gregory

Article Directory: http://www.articledashboard.com

Mark Gregory is writing on behalf of Computer Training Solutions, who offer excel training courses and excel training