Using the query design environment is a core component of the Access development process. Adam will outline the various screen interface elements, and demonstrate how to pull fields out of related data tables and combine them in a new query. The visual nature of the design interface helps minimizes entry errors and gives greater control over the query recordsets.
- 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 find the query design button.…
- Creating a query with the wizard
- Defining query criteria
- Using comparison and wildcards in criteria
- Working with joins
- Creating parameter queries
- Using the built-in functions in Access
- Summarizing data
- Aggregating records with totals
- Working with dates
- Creating alternative queries: unmatched, crosstab, and more
- Writing queries with SQL
Skill Level Intermediate
1. Introduction to Access Queries
2. Creating Simple Select Queries
3. Creating Parameter Queries
4. Use the Built-In Functions
5. Aggregating Records with a Totals Query
6. Working with Dates in Queries
7. Understanding Program Flow Functions
8. Alternative Query Types
9. Writing Queries with Structured Query Language
Explore the basics of SQL5m 59s
10. Useful Query Tricks
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.