Watch trailer
Course at a glance
| Release date | 8/1/2022 | |
| Level | Advanced | |
| Runtime | 3h 17m | |
| 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 covers how to do reporting, as well as report and form dialogs, advanced reports and basic macros.
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 8
Basic Reports Part 1 (47:06)
- Introduction (00:17)
- Basic Reports (04:01)
- Report Demo (06:18)
- Report Design Tool (05:28)
- Blank Report (02:20)
- Report Wizard (14:47)
- Report Layout (03:20)
- Tabular (06:58)
- Remove Layout (03:24)
- Summary (00:08)
Basic Reports Part 2 (44:07)
- Introduction (00:08)
- Layout Tools (06:59)
- Properties (03:17)
- Report Properties (08:01)
- Working with Fields (06:47)
- Overirde Formatting (04:43)
- Report Formatting (06:29)
- Printing (05:42)
- Email (01:38)
- Summary (00:18)
Module 9
Advanced Reports (51:16)
- Introduction (00:20)
- Advanced Reports (02:13)
- Report Groups (15:23)
- Details in Header (09:28)
- Calculated Fields (06:05)
- Footer Calculated Field (07:14)
- Conditional Formatting (04:57)
- Manual Headers and Footers (05:10)
- Summary (00:21)
Reports and Form Dialogs (12:50)
- Introduction (00:15)
- Reports and Forms Dialog (01:14)
- Report Parameter Form (11:08)
- Summary (00:10)
Macros (42:31)
- Introduction (00:11)
- Macros (00:49)
- Creating Macros (04:33)
- Two types of Macros (02:25)
- Action Catalog (02:35)
- Navigation Pane Macro (05:10)
- Form Macro (09:40)
- Conditions (07:57)
- Other Events (08:50)
- Summary (00:17)