Using the Report & Analysis Tools in Access 2019 for Windows
Access 2019 (Windows)
| Intermediate
- 5 videos | 20m 49s
- Includes Assessment
- Earns a Badge
- CPE
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 40sIn 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 46sIf 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
-
3. Customizing your report in Access 2019 for Windows4m 43sIt'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
-
4. Cleaning up your database in Access 2019 for Windows3m 5sAccess 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
-
5. Analyzing your database in Access 2019 for Windows4m 36sAnother 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.
