From the course: Access 2019: Building Dashboards for Excel
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Work with SQL view
From the course: Access 2019: Building Dashboards for Excel
Work with SQL view
- [Instructor] If you're working with a tool that queries, it's likely running some form of SQL statement in the background. We can not only see that SQL statement in Access, but we can also use it to streamline building other queries. Okay, so let's go ahead and close our UniqueWatchByUsers. If you're prompted to save changes, you can. Let's leave our unique departments up, we might want that in just a second. Let's go to our base query here, let's go to the design view, and we can close our property sheet. So this serves as the base query. It has all of the guts and features we need for most of the reports we're going to write, and I need to actually do the same thing over and over again for the different departments. So let's go to the SQL view. So once you've gone to View and changed to SQL View, you're going to notice that you have the actual SQL statement that's written here. You see those common elements like…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.