Using the Report & Analysis Tools in Access 2016 for Windows

IN THIS COURSE

• 1.  Creating a quick report in Access 2016 for Windows
  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
• 2.  Creating your own database report in Access 2016 for Windows
  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
• 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
• 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
• 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