From the course: Learning Access for Office 365

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Create a query using the wizard

Create a query using the wizard

From the course: Learning Access for Office 365

Start my 1-month free trial Buy for my team

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…

Contents