From the course: Learning Access 2016
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Edit queries in Design view
- [Voiceover] The query wizard gave us a good head start. But it doesn't reveal the wealth of options that are available when pulling information out of the database. For full control, you'll want to start using the Query Design View. I'm going to go ahead and up the query that we started in the last movie. And I'll just double-click on it here in the Navigation pane. Now if we come up to the View menu, you might notice that we have a option here for SQL View. Queries in Access, and indeed many other database programs, use a language called Structured Query Language or SQL. Feel free to take a peek at what that code is by selecting this option here in the View button. This is the code that the wizard created for us in the last movie. Now, if you know SQL, you can type in and modify the query here. Or you can use the graphical user interface in the Design View. Let's come back to the View button. And this time we'll switch our View to Design View instead. Now, the top portion of the…
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.