Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Building Solutions Using Excel 2013 and Access 2013 Together

via LinkedIn Learning

Go to class Write review

Details

Go to class

Provider

LinkedIn Learning
Pricing

Free Trial Available
Languages

English
Certificate

Certificate Available
Duration & workload

1-2 hours
Sessions

On-Demand

Found in

Overview

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.

Syllabus

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

Taught by

Robin Hunt

Reviews

Start your review of Building Solutions Using Excel 2013 and Access 2013 Together