Dive into an advanced 2-hour tutorial on Microsoft Access 2021, 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 - the cornerstone of successful relational databases. Develop proficiency in creating queries, forms, and reports, including advanced techniques like automating queries and creating action queries. Delve into advanced report and form design, create switchboards, write macros, and utilize Access Visual Basic for Applications (VBA) for complex automation. Cover database security and customization options to round out your skillset. Gain hands-on experience through practical exercises and comprehensive lessons on queries, forms, reports, automation, wizards, and advanced design techniques.
Overview
Syllabus
Start
Introduction
Introduction to Queries, Forms, and Reports
Fixing Minor Table Issues
Creating Two Queries Using the Simple Query Wizard
Creating Queries from Scratch in Design View
Customizing Queries with Criteria and Criteria Wildcards
Viewing Expanded Table Data
Creating Customer Forms Using the Form Wizard
Creating Employee Forms Using the Form Wizard
Creating Forms in Form Design View
Creating Forms by Using Save As on a Table Object
Using Forms for Data Entry
Entering Customer Records
Creating Reports by Using Save As on a Query
Creating Reports from Scratch in Design View and Adding a Logo
Queries, Forms, and Reports Recap
Introduction to Query Reports and Complex Queries
Creating Queries Using Multiple Tables with an Inner Join
Changing Queries to a Left Outer Join
Using And Or Conditions in Criteria and Multiple Criteria
Using the Like Keyword for a Range of Characters
Creating Custom Fields with Calculations in a Query
Adding Table Fields to an Existing Query and Creating a Calculated Field
Creating and Formatting Another Calculated Field
Summarizing Query Results with Grouping
Query Reports and Complex Queries
Introduction to Automation, Wizards, and Advanced Reports
Creating Automated Requests for Criteria
Using Wildcards in a Parameter Query
Using Range Operators in Parameter Queries
Crosstab Query Wizard
Find Unmatched Query Wizard
Find Duplicates Query Wizard
Introduction to Action Queries
Make-Table Action Query
Append Action Query
Update Action Query
Delete Action Query
Advanced Report Design Techniques
Report Design View
Automation, Wizards, and Advanced Reports Recap
Conclusion
Taught by
Learnit Training
