From the course: Learning Access for Office 365
Join today to access over 22,700 courses taught by industry experts or purchase this course individually.
Create a query using the wizard
From the course: Learning Access for Office 365
Create a query using the 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 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 back out. To do this, we are going to leverage the query object, and it's my favorite part of the whole system. Because our cables are related together, we can use queries to merge details across the related fields. To do this, I'm gonna 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 are going to choose field from the individual tables that we'd like to see in our query. Now I'd like to expand the room assignment 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.