From the course: Access 2019 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Build queries in Design view

Build queries in Design view

From the course: Access 2019 Essential Training

Start my 1-month free trial

Build queries in Design view

“

- [Instructor] The Query Designer is one of the most powerful tools available to you inside of Access, and its layout makes it easy to find the answers to some very complex questions that you might have about your data. One way to begin exploring the Query Design environment is to take a look at an existing query to see how it was put together. We're gonna use the check-in details query that we created in the last movie with the Wizard to see exactly what the Wizard did for us in the background, and then what I wanna do is delete that query and then re-construct it from scratch using the Query Design environment to help us out. To get started, let's go ahead and right click on our query here, the check-in details query, and open it straight up into Design View. Another way you can do it is to double click on it to open it up in Data Sheet View and then come up here to the View button and switch its view into Design View by clicking on the top part of it. The Design environment is…

Contents