Lynda - Building Solutions Using Excel 2013 and Access 2013 Together - 396888
Lynda - Building Solutions Using Excel 2013 and Access 2013 Together
What happens when you combine Excel and Access? You get the best of both programs. Learn how to use Excel 2013 to get the most out of Access 2013 and save time building database solutions and running reports. Robin Hunt shows how to import and link to Excel data, run calculations in Excel and Access, build forms and reports in both programs, and automate tasks with macros, including the AutoExec startup macro in Access.


Table of Contents

  • Introduction
  • 1. Understanding How to Use Excel and Access for a Solution
  • 2. Building Tables in Excel and Access
  • 3. Calculating Data in Excel and Access
  • 4. Building Forms for Your Solution
  • 5. Building Reports for Your Solution
  • 6. Building Macros to Run Imports and Queries
  • Conclusion
  • Lynda - Building Solutions Using Excel 2013 and Access 2013 Together


    Information
    Members of Guests cannot leave comments.




    rss