Top 5 tips for easy working on Microsoft® Office Access 2010

If you are into database management and are looking for reliable and flexible options, look no further than Microsoft Office Access 2010. A part of the Microsoft Office 2010 productivity suite, Microsoft Office Access 2010 comprises of improved features that can be used as front-end options to other Microsoft and non-Microsoft products. Tasks of creating tables, reports, queries, forms, etc. can be easily done using this application. Whether you work in a small or a mid-sized company, this application can surely help you to manage data effortlessly. We have compiled for you the top 5 tips here for easy working on Microsoft Office Access 2010.

Tip 1: To create a new Access Data Project

All new databases are created in the ACCDB format in Microsoft Access 2010. To create a new project, follow the simple steps given below

• On the Backstage View, hit on the ‘Blank Database’ button
• Select the ‘Browse’ icon
• Select Microsoft Office Access Project (*.adp) in the Save As Type drop down list
• Browse and select a folder location to save your project
• Type in/ select a new name for the project and click on ‘Ok’
• Hit the ‘Create’ button (Blank Database task pane) to open the new project

Tip 2: To change the default color scheme

The default color scheme in Microsoft Access 2010 is silver. However, if you so wish, you could change this color scheme to either blue or black as well. Altering the color scheme is a simple process; Click on ‘Options’ in the File tab and then click on ‘General’. In the color scheme selection box, choose either ‘Blue’ or ‘Black’, depending on your taste. Select ‘Ok’ to complete the process. You may have to close and reopen the database to view the changes.

Tip 3: To update bulk data

This is one very handy tip that you can follow while using Microsoft Access 2010. Rather than changing one field in a host of products, you can set criteria, even for calculations, by using an Update Query. In this way, rather than having to manually change in each product, all you will have to do is set the criteria and uniformly apply it. Not only will it save time and effort, it will also reduce the chances of miscalculations and offer you better results.

Tip 4: To use Microsoft Access data in Microsoft Excel

Depending on your requirements and tastes, you can use any of the three options; copy, export, and data connection; to have Microsoft Access data in Microsoft Excel. You can copy from Microsoft Access to Microsoft Excel if you would want to create a table of the data for easy sorting of the same. If you choose to export the data, you can retain the formatting layout of the original data.

Tip 5: To avoid database corruption in Microsoft Access

No matter how hard you try, you still might have to face database corruption once in a while. Well, having a back up can surely save you from a lot of worries. However, if you had to repair and retrieve the data, you might have to resort to utilities like the Compact and Repair utility or some other third party tool. In order to keep your database safe, you can consider working with a split database, especially if you have a shared database.