Using the Report & Analysis Tools in Access 2019 for Windows

Access 2019 (Windows)    |    Intermediate
  • 5 videos | 20m 49s
  • Includes Assessment
  • Earns a Badge
  • Certification CPE
Likes 15 Likes 15
To get the most out of a database, you can extract data and analyze data patterns. Reports allow you to extract and view the information you need. You can also get a clear global view of a database by keeping your data clean. Once you have created a database, it is important to know how to analyze and interpret data. In this 5-video Access 2019 course, you will discover how to create reports, as well as how to create custom and automatic reports to extract needed information. Also, learners will observe how to clean up a database and analyze the database itself. Begin by creating a quick report, then learn how to create a database report from scratch. This leads to exploring how to customize a report, for example, formatting text and inserting additional items, modifying the layout or page orientation. Next, explore cleaning up a database; Access Speech is a useful query that can be used to clean up a database file. Conclude the course by observing how to analyze a database.

WHAT YOU WILL LEARN

  • create a quick report
    create a database report from scratch
    customize a report
  • clean up a database
    analyze a database

IN THIS COURSE

  • Playable
    1.  Creating a quick report in Access 2019 for Windows
    4m 40s
    In Access, 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 will do the formatting and page… FREE ACCESS
  • Playable
    2.  Creating your own database report in Access 2019 for Windows
    3m 46s
    If you want greater control over the way in which your Access 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… FREE ACCESS
  • Locked
    3.  Customizing your report in Access 2019 for Windows
    4m 43s
    It's important to know how to customize a report once you've created it. For example, you can format the text and insert additional items. You can also change its layout and page orientation. FREE ACCESS
  • Locked
    4.  Cleaning up your database in Access 2019 for Windows
    3m 5s
    Access 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… FREE ACCESS
  • Locked
    5.  Analyzing your database in Access 2019 for Windows
    4m 36s
    Another way of ensuring the integrity and accuracy of your records and data values in Access is to run a performance or table analysis. These tools can check your data tables for inconsistencies, such as data that has… 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.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE