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.
Overview
Syllabus
Start
Introduction
Form Wizard and Form Design
Form Design By Yourself
Data Entry with Forms
Creating Reports for Data Output
Forms Recap
Adding Relationship Security
Testing Referential Integrity
Controlling Query Results with Join Types and Controlling Query Results with Join Types
Creating Complex Queries with Multiple Criteria
Calculating Data with Queries
Advanced Query Calculations
Summarizing Data with Grouping
How Relationships Affect Queries Recap
Introduction to Automated Queries, Action Queries, and Advanced Report Design
Automating Queries with Parameters
Using Query Wizards
Action Queries - Making Tables
Action Queries - Appending Queries
Action Queries - Updating Queries
Action Queries - Deleting Queries
Advanced Report Design Techniques
Using Property Sheets for Report Design
Adding Button Controls to a Report
Conclusion
Taught by
Learnit Training
