Microsoft Access Training Unleashes the Power of the Pivot Table
Software:
Microsoft Access has been a leading relational database product for many years. Each new version refines the concept and adds powerful new features, some of which can be overwhelming to the new or even the experienced user. Because this piece of software is so complex, instructor-led training is one of the fastest and most effective ways to get you up to speed on using these new tools effectively.
Let's look at an example of a technique learned in the advanced Microsoft Access training course.
In Access 2002, Microsoft added pivot tables and pivot charts as powerful data analysis tools that allow the user to organize and summarize the database information.
Introducing the pivot table
A pivot table allows analysis of a large amount of data, sorted and sub-sorted by any data field. With the help of the Pivot Table Wizard, it is easy to create comprehensive reports that present the data in practically any way imaginable.
A typical exercise you might see in an instructor-led training environment would give you a database of sales information and have you extract customer orders through a previously designed query. To make use of this data, you must display it in a useful format, and the pivot table is perfect for that.
Select View/PivotTable View from the main menu to create a blank pivot table. Creating a finished table involves simply dragging fields from the field list onto areas of the report.
For example, you might drag "Sale Representative", "Category", and "Month of Sale" to the column fields and "Amount of Sale" to the data field. This gives a report of all sales sorted by representative, sub-sorted by category of item, and sub-sub-sorted by month. The report is automatically subtotaled by category then again by representative.
You can expand or hide the detail at any level, thus hiding the detail for a representative or a category. You can filter certain fields, for example limiting category to "Toys" and month to "November" and "December" to see how the Christmas shopping seasons affected toy sales.
Advanced pivot table techniques
Microsoft Access training shows how a pivot table can do more than just present the data. By adding calculation fields, you can provide a further level of analysis. This allows you, for example, to analyze average sales by sales representative or sales volume by month.
Formatting allows you to emphasize certain data, easily drawing attention to trends such as profit or loss within certain sectors. You can create your own data groupings, such as tagging certain cities in your report and tagging them "Western England" and other cities as "Eastern England" to see if there is a difference in sales between the two regions.
Microsoft Access training has more to offer
This is a quick view of a small part of what an advanced training course offers you. With two to five days of instructor-led classroom training, you can acquire a wide range of skills that will beef up your resume and drastically increase your effectiveness when working with spreadsheet data.
Author is a freelance copywriter. For more information on microsoft access training, please visit www.microsofttraining.net
Hot Topics In Software
Boosting Your Career With Microsoft Office
It's difficult to remember a time when the workplace was not dominated by the desktop computer. With 90% of the world's computers now installed with Microsoft Office many employers require at least a ...Microsoft Excel Training - Numerical Excellence For All
Do you need an easier way to manage your household budget? How about finding an efficient way to create mailing lists? Perhaps you need to create financial forecasts or analyse sales figures for your ...Why CRM Projects Fail
1 OverviewThis articles looks at some of the human? i.e. people-related factors that can cause a CRM project to fail. We then look at why, for those businesses already utilising Microsoft Outlook f...
Why Easy To Use Software Is Putting You At Risk
Title-----
Why Easy To Use Software Is Putting You At Risk
Can Easy To Use Software Also Be Secure
----------------------------
Anyone who has been working with computers for a long tim...
Spyware Remover A Cautious Review
A spyware remover program that came across my desk just the other day. No Adware is anti-malware software that professes to have a solution that will:?Perform a web bug scan... A web bug scan will ...
Free business software alternatives to Microsoft office
By Paul WilsonThe cost of using paid for?business software has become prohibitive. Both businesses and home users are focusing on new and affordable avenues.
The options include free software:
Adware Removal Tips
Have you tried (and failed) to remove those annoying pop-ups known as adware? There may be reason. You can manually remove adware components one by one, but there is a good chance you would miss some ...Spyware Free Acceleration Tool
Helping users have quicker internet surfing speed, Straight2You released at the beginning of 2004 a web surfing acceleration tool. The tool was designed not to give users false promises but to provide...How to Improve Productivity and Automate Everyday Computer Tasks with Windows Automation Software.
There was a time when one of the main purposes of a PC was simply to save you time. The theory was that a computer could do what you do, but do it quicker and more efficiently. We've all seen the SciF...Why Those Free Software Downloads May Not Exactly Be Free
When using the Internet be very cautious of free downloadable software, such as sites that offer you free downloadable cursors, tool bars, and smiley faces as well as many other appealing things. If y...Erasing index.dat files
1. What are index .dat files?
When you visit a webpage, the content (html files, pictures, flash, java scripts and other) is downloaded and saved to your computer. This is called the cache or Tempo...Innovative Software Tools for Process Development and Management
Reliable, state-of-the-art software tools are vital for businesses that wish to achieve and maintain a leading position on the market. In order to boost their overall productivity and efficiency, incr...
Most Recent Software Supplements
- Microsoft Access Training Unleashes the Power of the Pivot Table
- Advanced Excel Training - Takes You To The Next Level
- How can we maximize E-mail efficiency in business operations?
- Did You Try The Desktop Publishing Software
- Boosting Your Career With Microsoft Office
- Advantages of Using a Content Management System
- Advanced Microsoft Project Training - Manage Your Level Of Expertise
- Microsoft Promised To Make You Speechless
- Microsoft Access Mistakes to Avoid
- Personal Experiences of a PowerPoint Presenter Living in London
- Advanced Excel Training - Takes You To The Next Level
- How can we maximize E-mail efficiency in business operations?
- Did You Try The Desktop Publishing Software
- Boosting Your Career With Microsoft Office
- Advantages of Using a Content Management System
Newly Popular Computers Articles
Boosting Your Career With Microsoft Office
It's difficult to remember a time when the workplace was not dominated by the desktop computer. With 90% of the world's computers now installed with Microsoft Office many employers require at least a ...The Secret Formula to Affiliate Success
The internet has become a reservoir for buyers and sellers. Consequently, this has to lead to wave of online malls pouring onto the internet. The customers are then left with websites that offer littl...A Look At Bluetooth Security
These days, all communication technology faces the issue of privacy and identity theft, with Bluetooth being no exception. Almost everyone knows that email services and networks require security. What...Multi Tier Programs In Affiliate Internet Marketing
Internet Affiliate Marketing is the system of promoting web based businesses in which a third party usually referred to as an affiliate is rewarded for every visitor, customer or sale he/she provides....Three Steps to Take to Recover Your Hard Drive
Disk recovery services are very searched for and that is because more and more people have a computer as their means of working. We are more or less forced knowing computers, and therefore we depend o...
Think of Your Affiliate Program as a Small Piece of You
It is important to have a good affiliate program, for a variety of reasons. It makes it easier to increase your profit margin and make higher income for yourself.Having an affiliate program can hel...
Choose Today's Best Laptop Accessories
Buying laptop accessories online is a very popular option for laptop owners nowadays. After all, if you decide to buy a laptop computer, it's only natural that you will also want to buy accessories fo...Affiliate Internet Marketing: Where Are They Coming From?
It is just a point of fact that to really take off with affiliate internet marketing, you need to establish your presence online. If you have not done so already get a good domain name and web host. A...Discussing Affiliate Marketing Network
Affiliate internet marketing is a virtual network under which firms and individuals sign up with affiliates on the internet to promote their own business. This online market includes the huge network ...Affiliate Marketing Training Program
Affiliate marketing does not promote any particular industry standards for training and certification. But there are some of the websites that have training courses and conduct seminars to offer you c...
