Student Reviews
( 5 Of 5 )
1 review
Video of 10. Microsoft Access 2016: Aggregate Data With Functions and Group By SQL Queries in Microsoft Access course by Programming Made EZ channel, video No. 10 free certified online
In this video on aggregate data with functions and group by in a SQL query, Steve Bishop gives you a tutorial on how to perform calculations on your data to extract pertinent information about your business. After watching this lesson you will know how to find the averages, sum, count, minimum, or maximum values of a column organized according to the values in a field. This is where things start to get a bit more data science oriented but it's important to know how to do these aggregate function and grouping of data.
This how to video tutorial is part of a series of videos that are tutorials on various topics involving Access 2016, visual basic for applications (vba), structured query language (SQL), and basic form design (UI). These lessons on Access 2016 will help you create applications for your business or personal use that will make you more efficient at organizing your data.
Click here for the Work Files for this series:
https://github.com/Xipooo/Access2016BasicWorkFiles
Click here for the Microsoft Access 2016 Basics Playlist:
https://www.youtube.com/playlist?listPLYMOUCVo86jEHeRS72VtrasGNvnk0V1pO
#MicrosoftAccess #VBA #SQL #Access2016 #Programming