Next steps

Contents

• Introduction Introduction

  • Make Excel data entry more visual

    57s
  • What you should know

    18s
  • Working with the exercise files

    49s
• 1. The Benefits of Moving to Access 1. The Benefits of Moving to Access

  • Understanding the limitations of Excel

    2m 46s
  • Understanding the limitations of Access

    3m 46s
  • Learning how queries, forms, and reports work with tables

    3m 11s
• 2. Understanding the Access Structure 2. Understanding the Access Structure

  • Work with table views

    2m 10s
  • Link data to Access

    5m 13s
• 3. Analyze Database Tables 3. Analyze Database Tables

  • Learning the basics of normalization

    2m 15s
  • Understanding table relationships

    1m 52s
  • Identify keys

    1m 15s
  • Understanding join types

    2m 55s
• 4. Build and Work with Queries 4. Build and Work with Queries

  • Create queries

    3m 14s
  • Sort and filter in a query

    3m 3s
  • Enhance queries

    4m 14s
  • Build unique data queries

    3m 47s
  • Work with SQL view

    6m 15s
  • Build aggregate data queries

    4m 39s
• 5. Export and Link Data to Excel 5. Export and Link Data to Excel

  • Import to and from Access

    2m 5s
  • Link data to Excel

    2m 15s
  • Work with external connections

    2m 15s
  • Refresh data from other sources

    1m 39s
  • Add data from connections

    1m 19s
  • Change connections

    2m 8s
• 6. Charting and Pivots in Excel 6. Charting and Pivots in Excel

  • Build sunburst charts and treemaps

    5m 9s
  • Build pivots and set refresh settings

    5m
  • Build PivotCharts

    5m 23s
  • Using slicers and timelines to filter

    2m 40s
  • Set slicer options

    3m 3s
  • Move charts

    6m 26s
  • Work with page layout

    5m 8s
• 7. Build Excel Macros for Dashboard 7. Build Excel Macros for Dashboard

  • Create macros that clear filters

    1m 27s
  • Create macros for common filters

    2m 43s
  • Create macros that navigate

    2m 27s
  • Assign macros to buttons

    3m 54s
• Conclusion Conclusion

  • Next steps

    15s