In this video, learn how to build queries that total data in Access.
- [Instructor] Even though the syntax may vary…for most of the calculations you build in Excel,…if you can build it in Excel,…you can typically build it in Access.…Let's create some total queries…which would be the equivalent of sum.…Our auto sum or auto average that you would find in Excel.…Let's make a copy of our short list.…I'll right click and choose copy,…and then I'll right click and choose paste.…Let's go ahead and name this count by department.…
There's my new count by department query.…I'll go ahead and double click it.…This already has all of the details that I need.…I just want to add the department name…and then I want count the people.…So I would do an auto sum in Excel,…but it would be a little bit of a challenge.…Maybe I would do a subtotal by department.…Let me show you how we do this in Access.…I'll go change to my design view.…I really want to show the department name,…so I'm going to go ahead and delete these three columns.…Let me just swipe it across,…and then I'll drag that department name into the list.…
Author
Released
11/30/2018- How Excel and Access can work together
- Using the Problem Steps Recorder
- Leveraging screen capture tools
- Building tables in Excel and Access
- Creating basic queries using tables
- Maintaining linked tables
- Calculating in Excel versus Access
- Building forms
- Building macros to run on-demand queries
- Generating datasets using parameters, queries, and macros
Skill Level Intermediate
Duration
Views
Related Courses
-
Excel: PivotTables in Depth
with Curt Frye3h 38m Intermediate -
Access 2019: Forms and Reports
with Adam Wilbert4h 20m Intermediate
-
Introduction
-
Exercise files1m 25s
-
1. Understanding How to Use Excel and Access for a Solution
-
2. Building Tables in Excel and Access
-
3. Calculating Data in Excel and Access
-
Calculate in Access tables2m 17s
-
4. Building Macros to Run Imports and Queries
-
Save imports and exports7m 48s
-
Action queries in Access5m 54s
-
-
5. Building Reports for Your Solution
-
Build a basic report4m 47s
-
Build parameter queries6m 5s
-
-
6. Building Forms for Your Solution
-
Build macros on events4m 49s
-
7. Using Parameters, Queries, and Macros to Generate Datasets
-
Build data links to Excel5m 24s
-
-
Conclusion
-
Next steps33s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press 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: Calculate totals in Access queries