Microsoft Access Expert Level 17 is 1 hour, 37 minutes long. In this class we will continue working with Action Queries. We will also do more with Union Queries, and we will begin working with Crosstab Queries, which are very similar to Excel PivotTables. We will create a project to tie all of the Action Query techniques we've learned together by archiving old unpaid orders from our system to a backup archive. Topics include:
- Archive Old Unpaid Orders
- Select & Mark Orders w Update Query
- Create a Form to Review Orders
- Append to Archive Table w Macro
- Backup Customers, Orders, Details
- Add "Write-Off" Notice to Customer Rec
- UNION Query for Reporting on Both
- More with Embedded Button Macros
- CrossTab Queries (like PivotTables)
Click here for more information on Access Expert Level 17, including a course outline, sample videos, and more. This course was recorded using Access 2013, but is also valid for Access 2007 and 2010 users. This class follows Expert Level 16. The next class in the series is Access Expert 18.
13 years ago
