In this video, Adam will introduce the example database for H+ Sport, a company that manufactures a line of athletic clothing. He'll show you the tables and data that will be used throughout the course, including the customers, products, and order details. A quick primer on how to navigate the Access 2016 interface will also be covered.
- [Voiceover] This course focuses primarily on queries…which are only one of Microsoft Access's…five main object types.…In order to get the most out of this course,…you should have a basic, working knowledge…of the other four types;…namely, tables, forms, reports, and macros.…Now there's no need to be an expert in their application,…but you should feel comfortable knowing what each object is…and what they're used for.…Throughout this course, we'll be working…with a database created for a company called H+ Sport,…which manufactures a line of athletic clothing.…When jumping into a new database,…it's always a great idea to take a few minutes…to review the data tables and relationships…in order to familiarize yourself…with the contents you'll be working with.…
In the navigation pane,…over here on the left-hand side of the screen,…you'll notice that we have several data tables…that have already been established…and hold our information about H+ Sport,…their customers, and the products that they've ordered.…To see what these are let's just start with…
- 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.