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

Unlock this course with a free trial

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

Build queries in design view

Build queries in design view - Microsoft Access Tutorial

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

Start my 1-month free trial Buy for my team

Build queries in design view

“

- Queries, like tables, have multiple views or working modes that we can use. Right now, I'm looking at the order details query in datasheet view, which displays the results. This query pulls information from the customers, phone, orders, and products tables to show me lots of detailed information rather than just the numeric ID numbers that are stored in the orders table. On the Home ribbon at the far left, you'll see we have the same View button that we saw previously when working with tables. The top half of the button will toggle back and forth between datasheet view and design view of our query. Using the bottom portion of the button, though, you'll see we have access to a third option called SQL view. Let's take a look at that one first. In SQL view, you can see the actual structured query language code that's used to collect data from each of our four database tables. Being able to read and write SQL code is a valuable skill to have, but it can be a little bit intimidating to…

Contents