The real flexibility and power of the Query object can only be developed through the Design view. By changing the mode, you gain access to a much larger set of possibilities for combining your data together. In this movie, Adam will use the values already present in the database to calculate additional columns of information.
- [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 wanna start using…the query design view.…I'm gonna go ahead and open 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 screen displays a view…
If you need a deeper dive into the topics discussed, check out Adam's Office 365: Access 2016 Essential Training course.
- Loading a premade template database
- Exploring the interface
- Defining data types
- Creating tables
- Defining table relationships
- Editing forms
- Creating queries and reports
- Editing reports in Layout view