Author
Released
6/16/2011- Naming conventions and best practices
- Working with joins
- Using comparison operators
- Defining criteria for select queries
- Creating parameter queries
- Creating calculated fields
- Working with dates and times
- Using the Expression Builder
- Creating conditional statements
- Making, deleting and appending records
- Building reports
Skill Level Intermediate
Duration
Views
- [Voiceover] Hello and welcome to Access 2010 Queries In Depth. My name is Adam Wilbert and I'm gonna take you deep inside what I consider to be the most powerful object within an Access database. We'll start out by taking a look at creating some simple select queries to pull relevant fields from our data tables. And then we'll combine those fields for multiple tables into single datasheet. We'll then apply selection criteria to our queries to limit the records that are returned to just the subset that best satisfies our question. We'll also use calculated fields to get a new perspective on the trends hiding within your database.
We'll see how to create flexible queries through the use of perimeter requests which will allow your end users to further define what results your queries return and by automating common decision making routines through program flow functions and conditional statements, you'll save time and increase the accuracy and consistency of the data in your database. Finally, we'll see how to hook our queries back into forms and reports for added functionality and we'll apply these lessons to the creation of a flexible reporting tool, all of this is so that you can get more out of your data base than just the data you put into it.
So let's dig in to Access 2010 Queries In Depth.
Related Courses
-
Access 2010: Shortcuts
with Alicia Katz Pollock3h 43m Intermediate
-
Introduction
-
Welcome1m 6s
-
Introducing the database4m 29s
-
Previewing the course2m 49s
-
-
1. Creating Queries in Access
-
Understanding queries3m 31s
-
Using the Query Wizard5m 21s
-
-
2. Creating Simple Select Queries
-
Defining criteria5m 40s
-
Defining the column headers2m 49s
-
Exploring the property sheet7m 32s
-
Printing query results2m 41s
-
Working with joins4m 38s
-
-
3. Creating Parameter Queries
-
Creating a combo box4m 30s
-
4. Applying Aggregate Calculations (aka Totals Queries)
-
Using mathematical operators5m 46s
-
Applying text functions4m 7s
-
5. Working with Dates in Queries
-
Formatting dates4m 31s
-
Defining today's date2m 41s
-
Calculating time intervals6m 55s
-
6. Understanding Conditional Statements
-
Creating an IIf function7m 31s
-
Nesting IIf functions4m 57s
-
Using the Switch function4m 44s
-
7. Linking It All Together
-
Building the form6m 57s
-
Building the query5m 4s
-
Building the report3m 29s
-
8. Alternative Query Types
-
Finding duplicate records2m 17s
-
Creating crosstab results2m 57s
-
Creating backups1m 29s
-
Creating update queries3m 22s
-
Uniting tables3m 15s
-
-
Conclusion
-
Next Steps1m
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Welcome