Dive into an intermediate-level tutorial on Microsoft Access 2021, designed for users ranging from beginners to experienced individuals seeking to enhance their skills and boost efficiency. Explore the fundamentals of relational databases and Access objects before mastering the interface. Learn to plan, design, and create database tables, import data from Excel, and manually enter information. Discover sorting and filtering techniques, and understand table relationships crucial for successful database management. Create queries, forms, and reports while exploring how table relationships impact queries. Delve into query automation and action queries. Advance your skills with report and form design techniques, switchboard creation, macro writing, and Access Visual Basic for Applications (VBA) for complex automation. Cover database security and customization options to round out your comprehensive understanding of Access 2021.
Overview
Syllabus
Start
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
