Access 2021 Expert Tutorial

Get Ad-Free Training by becoming a member today!
[ Ссылка ]

Exercise Files: [ Ссылка ]

Who it's for: Beginners through experienced, everyday users looking to sharpen their skills and increase efficiency in Microsoft Access.

What it is: Access is Microsoft’s relational database application used to organize and store data. Access also has reporting capabilities.

What you'll learn: We start with navigating a completed database while exploring the concept of relational databases and the objects they contain. We’ll move on to learning the Access interface, so you can become comfortable in the working environment. Then, we dive into how to plan, design, and create database tables. We’ll continue by importing table data from Excel, as well as manually entering table data. Sorting and filtering techniques will be explored before we move on to exploring table relationships, the key to a successful relational database. We will create database queries, forms, and reports. We’ll spend time on learning how table relationships affect queries, how to automate queries, and how to create action queries. Our advanced training starts with Advanced Report and Form Design techniques. We will learn how to create switchboards, write macros, and use Access Visual Basic for Applications (VBA) for complex automation. We will end by covering database security and customization options.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
[ Ссылка ]

For Private Group Trainings please visit:
[ Ссылка ]

Manuals: [ Ссылка ]
Username: manuals
Password: password

Start 0:00
Introduction 0:03
Introduction to Advanced Forms and Automation 1:29
Creating Main Forms and Subforms 2:22
Using Subform Control to Connect Sub and Main Forms 6:14
Creating Tabbed Forms and Populating Pages 11:48
Populating, Aligning, and Spacing Fields and Testing Tabbed Forms 16:22
Renaming Page Tabs and Adding Form Headers to Tabbed Forms 18:28
Creating Split Forms 22:03
Adding Default Values to Form Fields for Data Entry 25:03
Adjusting the Tab Order on a Form 28:19
Adding Command Buttons to Forms for Navigation 31:20
Adding Switchboard Managers to the QAT 33:59
Adding Items to Switchboards 36:01
Introduction to Designing Macros to Automate Database Tasks 41:42
Creating and Testing AutoExec Macros 42:17
Using Message Boxes to Inform Users 45:17
Automating Parameter Queries with Macros 48:12
Viewing Related Records in a Form with Macros 51:03
Hiding and Unhiding Field Controls with Macros 52:09
Testing the Previous Macro 58:05
Using Macros to Validate Data Entry 58:49
Introduction to Access Visual Basic for Complex Automation 1:04:28
Using VBA to Secure a Form with a Password 1:05:12
Creating User Input Boxes with VBA 1:11:24
Using Logic Programming to Interpret One or Multiple Conditions 1:14:18
Advanced Forms and Automation Recap 1:18:39
Introduction to Database Security and Options 1:20:40
Splitting Databases for Table Security 1:21:41
Examining Back-End Databases 1:26:13
Moving Back-End Databases and Using the Linked Table Manager to Point to a New Path 1:27:00
Customizing Database Options 1:30:52
Applying the Compact and Repair Tool 1:34:28
Generating Database and Relationship Reports 1:36:30
Database Security and Options Recap 1:42:08
Conclusion 1:43:35

#microsoftaccess #access

(C) 2022 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

свернуть