Report & Analysis Tools in Access 2010 for Windows

Access 2010 (Windows)    |    Intermediate
  • 8 videos | 46m 29s
  • Earns a Badge
Likes 12 Likes 12
A PivotTable can be used to change how data is visualized and help with analyzing database records. Discover how to create and use PivotTables and PivotCharts, and use database reporting and cleanup in Access 2010.

WHAT YOU WILL LEARN

  • Creating a PivotTable
    Using your PivotTable
    Creating a PivotChart
    Creating a quick report
  • Creating your own database report
    Creating a report to analyze your database's properties
    Cleaning up your database
    Analyzing your database

IN THIS COURSE

  • Playable
    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… FREE ACCESS
  • Playable
    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… FREE ACCESS
  • Locked
    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… FREE ACCESS
  • Locked
    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
  • Locked
    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
  • Locked
    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… FREE ACCESS
  • Locked
    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… FREE ACCESS
  • Locked
    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… FREE ACCESS

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.