From the course: Access Essential Training (Office 365/Microsoft)

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 Essential Training (Office 365/Microsoft)

Start my 1-month free trial

Build queries in Design view

“

- [Instructor] The query designer view is a very powerful tool to have at your disposal and its layout makes it easy to find answers to some very complex questions. 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'll use the CheckinDetails query that we built using the wizard to see exactly what the wizard did for us in the background and then we'll delete it and reconstruct that same query on our own, entirely in the designer. Let's go ahead and open up this query in datasheet view by double clicking on it and take a look at the home tab, we have the view button. The top portion of the button will change our view between design view here and datasheet view, which is what we were looking at. The bottom portion of the button shows us that there's actually three different views for queries, datasheet view, design view, and something called SQL view, which shows us the syntax that's living behind the query…

Contents