Overview
-
Learn strategies and techniques that can help you work smarter with Excel and Access 2019, and avoid needing to manually rebuild each time you run reports by building solutions.
Syllabus
-
Introduction
- Increase productivity by leveraging Excel and Access together
- What you should know
- Exercise files
- How Excel and Access can work together
- Use the Problem Steps Recorder
- Use Microsoft Office screenshots
- Create Access database tables
- Import and link Excel data as tables
- Create Access tables from Excel data
- Create basic queries using tables
- Work with the Linked Table Manager
- Calculate in Excel versus Access
- Common formulas for data mining in Excel
- Calculate in Access tables
- Calculate totals in Access queries
- Save imports and exports
- Action queries in Access
- Build macros to run on-demand queries
- Build a basic report
- Build parameter queries
- Build reports on your new queries
- Export information back to Excel
- Build forms and navigation forms
- Add reports to your navigation form
- Build forms for parameter queries
- Add command buttons for navigation
- Build macros on events
- Build data links to Excel
- Create macros that export data
- Use the AutoExec macro in Access
- Set the Access database options
- Finalize and run the solution
- Next steps
