In this movie, Adam introduces SQL. SQL, or Structured Query Language, is the syntax that powers all of the queries in Access and many other database systems on the market. Reading and understanding the SQL code, and understanding the various clauses within, is useful for troubleshooting as well as developing more complex queries.
- [Voiceover] Behind all of the queries…that we've constructed in this course…is a language called SQL.…SQL stands for Structured Query Language…and at any point in the design of a query in Design View,…you can switch your view…to see the code that's being written in this language.…While almost all of the queries…that you'll need to create…can be created in the Design View,…I think it's a valuable exercise…to review the SQL code periodically…in order to get used to its syntax.…Most database systems on the market today…use similar syntax in their query languages…and knowing SQL is a highly marketable skill.…Let's create some simple queries in Design View…and then take a look at them in SQL mode.…
I wanna create a new query here…based around our customers…and I'm just gonna add two fields,…the first name and the last name.…Now on the Design tab of the ribbon,…if I come over here to the View button…and press the bottom half of that button,…you'll see my different modes…and you can see I can go into SQL View here.…In SQL View, you can see the two lines of code…
- 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.