Join Adam Wilbert for an in-depth discussion in this video Using other Date/Time functions, part of Access 2010: Queries.
Typically, dates and times stored within your database are very specific.…Dates are usually specific to a particular day and times are specific to the minute.…When it comes time to query your data by month or year, Access provides a few…simple ways to extract just the level of precision that you need from your Date and Time fields.…Let's go to Create and we'll take a look at a new query in Design view.…We'll add tbl_DirectCustomers, tbl_Orders, and tbl_Products.…Let's go ahead and close Show Table.…Now, let's say we want to take a look at the orders that came from specific…states over a specific reporting period.…
We'll add states to our query.…We'll add State to our query and we'll add Price from the Products table.…Let's turn on the Totals row, because we want to group everything down to the State.…We could turn this Group By to a Sum to get a sum total for each state.…If we run this, Access will return a list of each state listed, we have 50…represented, and the total price that each State has contributed to our…
- 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
1. Creating Queries in Access
2. Creating Simple Select Queries
3. Creating Parameter Queries
Creating a combo box4m 30s
4. Applying Aggregate Calculations (aka Totals Queries)
5. Working with Dates in Queries
6. Understanding Conditional Statements
7. Linking It All Together
8. Alternative Query Types
- 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.