From the course: Access Basics for Excel Users
Join today to access over 24,700 courses taught by industry experts.
Create a query
From the course: Access Basics for Excel Users
Create a query
- [Instructor] At this stage, you've created the building blocks of a database. So, how about we now unlock the power of Access using something called a query. Now, a query essentially allows you to selectively view and aggregate only the fields that you want to analyze. Let's start by opening up both tables in our database by double-clicking on them. The employment data here has a bunch of historical records about the labor force in California going back to 1990, whereas the category table here simply maps each county as either small, medium, or large based on relative population size. You'll notice that each county appears only once. Say that we want to include the area category alongside each of the counties in our employment data set, so that we can prepare reports and charts later on using all this information. All we need to do is create something called a query, which is kind of like a lookup if you're familiar with Excel. So from the create menu here, go ahead and select the…
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.