Overview
Coursera Flash Sale
40% Off Coursera Plus for 3 Months!
Grab it
Dive into this advanced Microsoft Access tutorial designed for users who already have foundational knowledge and want to elevate their database management skills. Throughout this 1 hour and 44 minute comprehensive training, learn to create dynamic forms with controls and calculations, design professional reports with sorting and grouping capabilities, and leverage VBA (Visual Basic for Applications) to automate tasks and enhance database functionality. The tutorial progresses through creating interactive forms, implementing form controls, adding buttons, connecting forms with queries, building detailed reports, and using VBA for advanced operations like record searching. Perfect for professionals, analysts, and database users who need to manage complex data sets, streamline workflows, or build customized database solutions that integrate seamlessly with other Microsoft Office applications.
Syllabus
Start 0:00
Introduction 0:09
Creating a Form 1:02
Working with Forms 15:43
Form Controls and Calculated Fields 21:57
Adding Buttons and Formatting Our Forms 28:00
Using Forms to Interact with Queries 33:33
Building a Report 46:28
Grouping and Sorting 1:02:45
Intro to VBA with Access 1:17:02
Searching Records with VBA 1:22:38
Taught by
Learnit Training