Building Solutions Using Excel 2013 and Access 2013 Together
Created By
Robin Hunt via LinkedIn Learning
- 0
- 1-2 hours worth of material
- LinkedIn Learning
- English
Course 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.
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.
Course Circullum
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Understanding Excel and Access can work together
- Using the Problem Step Recorder
- 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
- Calculating in Excel 2013 versus Access 2013
- Common formulas for data mining in Excel
- Calculating in Access 2013 tables
- Calculating in Access 2013 queries
- Building a basic form in Excel tables
- Setting the database options
- Adding command buttons for navigation
- 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
- 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
- Next steps
Item Reviews - 3
Submit Reviews
This Course Include:
Introduction
- Welcome
- What you should know before watching this course
- Using the exercise files
- Understanding Excel and Access can work together
- Using the Problem Step Recorder
- 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
- Calculating in Excel 2013 versus Access 2013
- Common formulas for data mining in Excel
- Calculating in Access 2013 tables
- Calculating in Access 2013 queries
- Building a basic form in Excel tables
- Setting the database options
- Adding command buttons for navigation
- 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
- 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
- Next steps
- Provider:LinkedIn Learning
- Certificate:Certificate Available
- Language:English
- Duration:1-2 hours worth of material
- Language CC: