Microsoft® Access 2010 Tips

Tips on how can you install and use Microsoft Access 2010?

Microsoft Access 2010 is an application you which has some features which are quite useful for smaller databases, like address books and CD/DVD collections. The Microsoft Access 2010 offers some improvements that make this application more usable and it includes reliability enhancements which can improve the performance. This application also provides easier Web publication with the help of the Web Database type. The macro environment can be launched conditionally based on actions taken within the database, which not only improves performance, but also can improve the user experience by automating tasks. In Microsoft Access 2010, Office themes are supported thus making customizations to the appearance of databases much easier and more uniform. Application also allows conditional formatting within reports, showing the information that meets a certain condition or set of conditions.

Given below are the tips regarding the installation and use of Microsoft Access 2010:

• Productivity tips
• Use the Quick Access toolbar
• Steps to install Microsoft Access 2010

Productivity tips

The improved ribbon interface in Microsoft Access 2010 can take up much space in your work area and this can be very annoying. You can avoid this by minimizing the ribbon. To locate a code window, you have to press Ctl+G to open the immediate Window thereby making the VBA editing environment available. This will help in loading the required code module. Another option which can make use of Microsoft Access 2010 easier is the create tab containing all the options for making new tables, queries, forms, etc. The Design tab will allow you to work with the newly created objects, turning a SELECT query into an UPDATE query and dropping controls on your form. After this, opt for the Home tab where you have to navigate to do text formatting. The run-time options are also available such as sorting a datasheet or filtering a form.

Use the Quick Access toolbar

To perform printing tasks, you must add the print or print preview options to the Quick Access Toolbar until you get used to the menu options. It is a good option to load this toolbar with things you cannot easily find in the menus. The option of Navigation forms is an alternative to the Switchboard of previous Access versions. The menu option on the Create tab will guide you through the process.

You have to begin by verifying that your system meets the basic requirements for Microsoft Access 2010. You will require 500MHz or faster processor with 256MB of RAM and 3GB of free hard disk space minimum. Make sure that you have an updated Operating System. You can run Microsoft Access 2010 in Windows XP SP3 or later versions. Also apply all security updates and hot fixes to your system before installing Microsoft Access 2010 by from the Microsoft website. Insert the Office CD into your CD-ROM drive and the installation process will start automatically. The system will prepare the Installation Wizard. Next, you will have to enter your product key and accept the terms of the license agreement. If you want to install the entire Office suite you can select the 'Install Now' on the next screen and if you want to customize your installation, click 'Customize' instead. When the installation process is complete, you will have to restart your computer. When the computer restarts, the most important and primary step to do is to visit the Microsoft website to download security updates for Microsoft Access.

iYogi is the fastest growing online and remote tech support provider in the direct-to-consumers and small businesses sector. Our highly skilled and experienced tech experts available, 24x7x365 will provide the best issue resolution and customer satisfaction. Our award winning and low priced Annual Subscription covers the following services:

• Comprehensive support for tips to install and use Microsoft Access 2010
• Diagnostic & repair for your technologies.
• Troubleshoot software errors.
• Update drivers and security to protect against online threats.
• Connect to Internet, devices and peripherals.
• Optimize your computer’s speed and performance.

Unlimited access to great tech support, all year around! We promise the lowest wait-time and highest resolution rate in the industry.