Access 2019 Advanced Tutorial
Dive into an advanced 2-hour tutorial on Microsoft Access 2019, designed for users ranging from beginners to experienced. Master the intricacies of relational databases, starting with navigation and interface familiarization. Learn to plan, design, and create database tables, import data from Excel, and manually enter information. Explore sorting, filtering, and table relationships crucial for database success. Develop skills in creating queries, forms, and reports, with emphasis on how relationships impact queries. Advance to automated and action queries, and delve into advanced report and form design techniques. Gain expertise in creating switchboards, writing macros, and utilizing Access Visual Basic for Applications (VBA) for complex automation. Conclude with insights on database security and customization options, equipping you with comprehensive knowledge to efficiently organize and manage data in Access 2019.