From the course: Learning Access 2016
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create a query using the Query Wizard
From the course: Learning Access 2016
Create a query using the Query Wizard
- [Voiceover] Storing your data in a database is a great first step, but the real benefit comes when it's time to get that data back out. More importantly, you'll want that data to help inform decisions that need to be made or to start to reveal patterns that you can take action on. In other words, you put your data into a database, but you want to get information backed out. To do this, we're going to leverage the query object. And it's my favorite part of the whole system. Because our tables are related together, we can use queries to merge details across the related fields. To do this, I'm going to come up to the create tab and find the query group here in the middle. Let's start with the Query Wizard. The first step asks us which type of query we'd like to make. I'm gonna use the simple Query Wizard here, and press OK. Next, we get to choose the fields from the individual tables that we'd like to see in our query. Now, I'd like to expand the room assignments data to be able to…
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.