Building Solutions Using Excel 2013 and Access 2013 Together

Learn to how to use Excel to get the most out of Access 2013 and save time building database solutions and running reports.

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.

These techniques are the key to better personal productivity data systems. Start watching now.

Introduction

• Welcome
• What you should know before watching this course
• Using the exercise files

1. Understanding How to Use Excel and Access for a Solution

• Understanding Excel and Access can work together
• Using the Problem Step Recorder

2. Building Tables in Excel and Access

• Creating Access database tables from scratch
• Importing and linking Excel data as tables
• Creating Access database tables from Excel tables
• Creating basic queries using tables

3. Calculating Data in Excel and Access

• Calculating in Excel 2013 versus Access 2013
• Common formulas for data mining in Excel
• Calculating in Access 2013 tables
• Calculating in Access 2013 queries

4. Building Forms for Your Solution

• Building a basic form in Excel tables
• Setting the database options
• Adding command buttons for navigation

5. Building Reports for Your Solution

• Building parameter queries using forms
• Setting dropdowns for parameters
• Building reports on your new queries
• Adding the new reports to your navigation form
• Exporting information back to Excel

6. Building Macros to Run Imports and Queries

• Building an import/export macro
• Appending and updating queries in Access 2013
• Building macros to run on demand queries
• Understanding the AutoExec macro in Access
• Assigning and building macros on events and buttons

Conclusion

• Next steps