From the course: Access 2016: Queries
Join today to access over 25,300 courses taught by industry experts.
Modify a query with the design interface
From the course: Access 2016: Queries
Modify a query with the design interface
- All of the queries in Access are stored in a common programming language called SQL. SQL, or structured query language, is a powerful way to write queries but it can be a bit difficult to read or troubleshoot if you're not used to it. Luckily for us, Access provides a graphical interface to creating our queries and eliminates much of the tedium involved with reading straight SQL code. This mode is called the query design view. Let's take a look at the various areas of the design interface and how we can begin to build queries using simple mouse gestures. In this exercise I wanna create a query that reveals my customers' names and email addresses as well as the subregion of the United States that they live in, instead of just the region that we saw previously. You might remember that the subregion information is also in the states table, so we'll make use of that in our query. In order to start a new query in design view, I'll come up to the create tab and from the queries group I'll…
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.