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
Rating 4.6 of 19 users Rating 4.6 of 19 users (19)
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

  • 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 layout for you, meaning that all you have to do is print it out. FREE ACCESS
  • 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 title and time and date if you wish. 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 your database runs as smoothly as possible. 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 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

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Rating 4.4 of 438 users Rating 4.4 of 438 users (438)
Rating 4.4 of 77 users Rating 4.4 of 77 users (77)
Rating 4.3 of 364 users Rating 4.3 of 364 users (364)