Calculate in Access tables

Contents

• Introduction Introduction

  • Increase productivity by leveraging Excel and Access together

    55s
  • What you should know

    18s
  • Exercise files

    1m 25s
• 1. Understanding How to Use Excel and Access for a Solution 1. Understanding How to Use Excel and Access for a Solution

  • How Excel and Access can work together

    3m 25s
  • Use the Problem Steps Recorder

    2m 37s
  • Use Microsoft Office screenshots

    2m 28s
• 2. Building Tables in Excel and Access 2. Building Tables in Excel and Access

  • Create Access database tables

    6m 24s
  • Import and link Excel data as tables

    6m 51s
  • Create Access tables from Excel data

    2m 13s
  • Create basic queries using tables

    2m 21s
  • Work with the Linked Table Manager

    3m 55s
• 3. Calculating Data in Excel and Access 3. Calculating Data in Excel and Access

  • Calculate in Excel versus Access

    5m 31s
  • Common formulas for data mining in Excel

    7m 4s
  • Calculate in Access tables

    2m 17s
  • Calculate totals in Access queries

    2m 42s
• 4. Building Macros to Run Imports and Queries 4. Building Macros to Run Imports and Queries

  • Save imports and exports

    7m 48s
  • Action queries in Access

    5m 54s
  • Build macros to run on-demand queries

    6m 53s
• 5. Building Reports for Your Solution 5. Building Reports for Your Solution

  • Build a basic report

    4m 47s
  • Build parameter queries

    6m 5s
  • Build reports on your new queries

    5m 53s
  • Export information back to Excel

    6m 29s
• 6. Building Forms for Your Solution 6. Building Forms for Your Solution

  • Build forms and navigation forms

    8m 43s
  • Add reports to your navigation form

    5m 11s
  • Build forms for parameter queries

    8m 41s
  • Add command buttons for navigation

    4m 3s
  • Build macros on events

    4m 49s
• 7. Using Parameters, Queries, and Macros to Generate Datasets 7. Using Parameters, Queries, and Macros to Generate Datasets

  • Build data links to Excel

    5m 24s
  • Create macros that export data

    7m 33s
  • Use the AutoExec macro in Access

    2m 20s
  • Set the Access database options

    3m 17s
  • Finalize and run the solution

    4m 23s
• Conclusion Conclusion

  • Next steps

    33s