Report & Analysis Tools in Access 2010 for Windows

IN THIS COURSE

• 1.  Creating a PivotTable in Access 2010 for Windows
  6m 2s
  A PivotTable can be used to change how you visualize your data, and can help you to begin analyzing the records that you have inserted into your database. This video tutorial will show you how to create a PivotTable in Access 2010 and how to use filters to display only the information that you want to see. FREE ACCESS
• 2.  Using your PivotTable in Access 2010 for Windows
  5m 28s
  Your PivotTable can be customized. In Access 2010, you can change its settings in order to adjust how it functions and how it looks. In this video tutorial, you will also find out how to export your PivotTable into Excel 2010. FREE ACCESS
• 3.  Creating a PivotChart in Access 2010 for Windows
  5m 16s
  A PivotChart is a form of graph which can be used to present your data in visual form. But first of all you are going to need to know how to select the data that you wish to include in your chart. This video tutorial will show you what you need to do to begin creating your PivotChart. FREE ACCESS
• 4.  Creating a quick report in Access 2010 for Windows
  5m 38s
  It is sometimes very useful to be able to create a report presenting the different data records contained in your database. In this video tutorial, you will find out how to create a report using the report wizard. FREE ACCESS
• 5.  Creating your own database report in Access 2010 for Windows
  7m 44s
  If you want to create a more detailed report, you are going to need to start from scratch. This video tutorial will show you how to define exactly what you want to see in your report, from the first step to the last. FREE ACCESS
• 6.  Creating a report to analyze your database's properties in Access 2010 for Windows
  5m 5s
  If you are interested in analyzing your database properties, you can tell Access to produce a property report. This allows you to extract the relevant information and present it in a clear and easy to read document. In this video tutorial, you will find out how to create this report. FREE ACCESS
• 7.  Cleaning up your database in Access 2010 for Windows
  3m 51s
  You can use the query function in Access 2010 to clean up your database. This video tutorial will show you how to create a new query which will present all the records in your table that are unmatched and lacking a relationship. FREE ACCESS
• 8.  Analyzing your database in Access 2010 for Windows
  7m 27s
  The larger your database gets, the more important it becomes to keep an eye on how it functions. In Access 2010, you can perform an analysis of your database in order to measure its performance. This video tutorial will show you how to begin using the analysis tools. FREE ACCESS