2015
Lynda
Robin Hunt
1:46
English
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
Download File Size:300.95 MB