Using the Report & Analysis Tools in Access 2016 for Windows

Access 2016 (Windows)    |    Intermediate
  • 5 videos | 28m 2s
  • Includes Assessment
  • Earns a Badge
Rating 4.5 of 15 users Rating 4.5 of 15 users (15)
For data to be useful, it must be accurate and presented in a meaningful way. Learn how to use the Access 2016 tools to create and customize reports, and to analyze and clean your data to help ensure data integrity.

WHAT YOU WILL LEARN

  • Creating a quick report
    Creating your own database report
    Customizing your report
  • Cleaning up your database
    Analyzing your database

IN THIS COURSE

  • 5m 45s
    In Access 2016, a report can be used to present information that has been extracted from your database. You can create a very quick table by simply selecting the table you wish to use. Access 2016 will do the formatting and page layout for you, meaning that all you have to do is print it out. FREE ACCESS
  • 7m 29s
    If you want greater control over the way in which your Access 2016 report is presented, you can create your own from scratch. You can select the fields that are displayed, the way in which the columns are laid out, and add a title and time and date stamps. FREE ACCESS
  • Locked
    3.  Customizing your report in Access 2016 for Windows
    4m 52s
    Access 2016's reports work in a similar way to mail merge documents. Once you have created a blank page, you can add data fields which will be used to display the data table's corresponding values. You can change the structure of the report and the data will be automatically adjusted, without it affecting the data values themselves. FREE ACCESS
  • Locked
    4.  Cleaning up your database in Access 2016 for Windows
    3m 28s
    Access 2016 features a query that can be used to clean up your database file. It can search for data or field inconsistencies, incomplete values, and even unmatched records. Removing or correcting these items can ensure that your database runs as smoothly as possible. FREE ACCESS
  • Locked
    5.  Analyzing your database in Access 2016 for Windows
    6m 28s
    Another way of ensuring the integrity and accuracy of your records and data values in Access 2016 is to run a performance or table analysis. These tools can check your data tables for inconsistencies, such as data that has been incorrectly formatted. You can even use the tools to split existing data tables and correct spelling mistakes and typing errors. 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.

YOU MIGHT ALSO LIKE

Rating 3.9 of 21 users Rating 3.9 of 21 users (21)
Rating 4.5 of 1331 users Rating 4.5 of 1331 users (1331)

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.8 of 13 users Rating 4.8 of 13 users (13)
Rating 3.9 of 120 users Rating 3.9 of 120 users (120)
Rating 4.1 of 218 users Rating 4.1 of 218 users (218)