Author
Robin Hunt
Released
12/9/2017- Name three reasons for businesses to utilize Excel.
- Recall the uses of the screenshot option.
- Identify the steps necessary to create a table in Access.
- List three items you can add to a query.
- Determine how to maintain linked tables.
- Recognize the report object that includes step-by-step instructions and totals.
- Apply the appropriate action to run a query in macro.
Skill Level Intermediate
Duration
Views
- [Instructor] Do you find yourself doing the same, repetitive steps in Excel to generate the next version of the report? If so, this course can increase your productivity. Hi, I'm Robin Hunt. Welcome to Building Solutions Using Excel and Access 2016. In this course, I'll show you how to work with the various imports and exports, how to set your database options, how to build forms and reports, how to automate using macros and the autoexec. I hope you'll find these techniques useful when you work with Excel and Access together. Let's get started building solutions with Excel and Access.
-
Introduction
-
Welcome30s
-
-
1. Understanding How to Use Excel and Access for a Solution
-
2. Building Tables in Excel and Access
-
Maintaining linked tables1m 27s
-
3. Calculating Data in Excel and Access
-
4. Building Forms for Your Solution
-
5. Building Reports for Your Solution
-
6. Building Macros to Run Imports and Queries
-
7. Using Parameters, Queries, and Macros to Generate Datasets
-
Conclusion
-
Next steps19s
-
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: Welcome