This course aims to teach learners how to navigate and work within Microsoft Access 2019, a relational database application. By the end of the course, students will be able to plan, design, and create database tables, import and enter table data, create queries, forms, and reports, understand table relationships, and utilize advanced report and form design techniques. The course covers automation through macros and Access Visual Basic for Applications (VBA), as well as database security and customization options. The intended audience ranges from beginners to experienced users seeking to enhance their skills in Microsoft Access.
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
