Watch trailer
Course at a glance
| Release date | 8/1/2022 | |
| Level | Intermediate | |
| Runtime | 2h 38m | |
| Closed captioning | Included | |
| Transcript | Included | |
| eBooks / courseware | N/A | |
| Hands-on labs | N/A | |
| Sample code | N/A | |
| Exams | Included |
Course description
Microsoft Access is a database management system (DBMS) used to store and manage data allowing a user to create forms, query information and create reports. This course focus on a deep dive into Querying data as well as Advanced query features, action queries and parameter queries.
Prerequisites
Knowledge of data types, database structure and use of other Microsoft tools and interface ribbons is very useful, but not required.
Meet the expert
I’m Kari Hoien. I have a Bachelors degree in Business and Accounting from Concordia College in Moorhead, I was a CPA and went on to get my Masters in Education Technology from Pepperdine in Malibu, California. I have been working as a trainer and consultant for Microsoft Office products for more than 20 years and I’ve helped clients in almost every industry in a wide range of different capacities and applications. I have taught thousands of people how to use Microsoft Office apps (Excel, Access, Outlook, PowerPoint etc). I have done stand-up classroom style training, virtual training, on-demand training, self-paced training, executive training, one-on-one training – you name it – I've probably done it. I LOVE teaching people how to use these everyday programs better, ways to save time so you can work SMARTER and have more time for the things that you love. Thanks so much for allowing me to help you learn.
Course outline
Module 4
Basic Queries Part 1 (48:21)
- Introduction (00:21)
- Basic Queries (01:46)
- Query Overview (02:04)
- Queries (08:09)
- Edit Data (01:46)
- Query types (04:15)
- Select - Action - Crosstab (03:37)
- Cross Tab Query (01:04)
- Action vs. Select Query (01:10)
- Create Select Query (07:11)
- Sorting and Filtering (00:33)
- Query Wizard (00:07)
- Query Wizard Demo (01:50)
- Sorting and Filtering in a Query (00:20)
- Sorting (07:10)
- Filters (06:42)
- Summary (00:08)
Basic Queries Part 2 (46:28)
- Introduction (00:08)
- Criteria in Query (00:13)
- Using Criteria (01:59)
- And and OR Queries (01:52)
- Using AND and OR (11:42)
- Common Query Operators (01:49)
- Using Operators (04:36)
- Wildcard (04:00)
- Is Null (01:54)
- Greater and Less Than (04:28)
- Multi-Table Queries (00:46)
- Multi-Table Query Demo (12:40)
- Summary (00:14)
Module 5
Advanced Query Features (28:47)
- Introduction (00:16)
- Advanced Query Features (01:23)
- Create Calculated Fields (05:17)
- Operators (00:23)
- Using Operators (02:20)
- Create Functions in Query (04:36)
- Nested Queries (06:25)
- Total Queries (07:49)
- Summary (00:14)
Action Queries (22:31)
- Introduction (00:12)
- Action Queries (01:54)
- Action Query Demo (09:47)
- Append Query (04:00)
- Delete Query (06:22)
- Summary (00:13)
Parameter Queries (12:10)
- Introduction (00:09)
- Parameter Queries (00:56)
- Parameter Query Demo (05:27)
- No Product Code Example (03:37)
- Between Operator (01:21)
- Parameter Order Matters (00:27)
- Summary (00:12)