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 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 screen displays…a view of the tables that we're pulling data from.…
If you need a deeper dive into the topics discussed, check out Adam's 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