Access 2021 Full Course Tutorial (6+ Hours) Exercise Files: https://learnitanytime.com/p/exercise-files-access-2021-full-course-tutorial 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: https://www.learnitanytime.com For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Join Offsite for our online community of teachers and peers: https://www.offsitebylearnit.com Manuals: https://bit.ly/30xZb59 Username: manuals Password: password Introduction 0:03 Database Objects and the Access Interface 3:30 Creating New Databases 34:52 Entering Data into Tables 1:02:53 Relationships 1:38:15 Queries, Forms, and Reports 2:16:03 Query Reports and Complex Queries 3:06:18 Advanced Reports, Automating Queries, and Using Query Wizards 3:37:21 Action Queries 3:56:11 Advanced Forms and Automation 4:23:13 Designing Macros to Automating Database Tasks 5:04:30 Access Visual Basic for Complex Automation 5:27:16 Database Security and Options 5:43:29 Conclusion 6:06:23 #microsoftaccess #access (C) 2023 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.
Access 2021 Expert Tutorial Exercise Files: https://learnitanytime.com/p/exercise-files-access-2021-expert-tutorial 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: https://www.learnitanytime.com For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Join Offsite for our online community of teachers and peers: https://www.offsitebylearnit.com Manuals: https://bit.ly/30xZb59 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.
Access 2021 Advanced Tutorial Exercise Files: https://learnitanytime.com/p/exercise-files-access-2021-advanced-tutorial 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: https://www.learnitanytime.com For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Join Offsite for our online community of teachers and peers: https://www.offsitebylearnit.com Manuals: https://bit.ly/30xZb59 Username: manuals Password: password Start 0:00 Introduction 0:03 Introduction to Queries, Forms, and Reports 1:21 Fixing Minor Table Issues 2:46 Creating Two Queries Using the Simple Query Wizard 6:59 Creating Queries from Scratch in Design View 11:29 Customizing Queries with Criteria and Criteria Wildcards 14:49 Viewing Expanded Table Data 19:20 Creating Customer Forms Using the Form Wizard 21:00 Creating Employee Forms Using the Form Wizard 25:17 Creating Forms in Form Design View 25:44 Creating Forms by Using Save As on a Table Object 30:49 Using Forms for Data Entry 35:01 Entering Customer Records 38:31 Creating Reports by Using Save As on a Query 39:13 Creating Reports from Scratch in Design View and Adding a Logo 42:14 Queries, Forms, and Reports Recap 49:17 Introduction to Query Reports and Complex Queries 50:41 Creating Queries Using Multiple Tables with an Inner Join 53:24 Changing Queries to a Left Outer Join 56:05 Using And Or Conditions in Criteria and Multiple Criteria 58:58 Using the Like Keyword for a Range of Characters 1:03:01 Creating Custom Fields with Calculations in a Query 1:05:39 Adding Table Fields to an Existing Query and Creating a Calculated Field 1:10:49 Creating and Formatting Another Calculated Field 1:14:29 Summarizing Query Results with Grouping 1:17:00 Query Reports and Complex Queries 1:21:10 Introduction to Automation, Wizards, and Advanced Reports 1:21:44 Creating Automated Requests for Criteria 1:22:45 Using Wildcards in a Parameter Query 1:25:11 Using Range Operators in Parameter Queries 1:28:28 Crosstab Query Wizard 1:32:51 Find Unmatched Query Wizard 1:36:14 Find Duplicates Query Wizard 1:39:05 Introduction to Action Queries 1:40:34 Make-Table Action Query 1:42:17 Append Action Query 1:47:09 Update Action Query 1:49:17 Delete Action Query 1:51:41 Advanced Report Design Techniques 1:53:31 Report Design View 2:03:22 Automation, Wizards, and Advanced Reports Recap 2:06:32 Conclusion 2:07:29 #microsoftaccess #access (C) 2022 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.
Access 2021 Beginner Tutorial Exercise Files: https://learnitanytime.com/p/exercise-files-access-2021-beginner-tutorial 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: https://www.learnitanytime.com For Private Group Trainings please visit: https://www.learnit.com/private-group-classes-workshops Join Offsite for our online community of teachers and peers: https://www.offsitebylearnit.com Manuals: https://bit.ly/30xZb59 Username: manuals Password: password Start 0:00 Introduction 0:03 Database Basics 2:03 Introduction to Database Objects and the Access Interface 4:01 Accessing the Northwind Template 7:13 Exploring the Login and Homes Forms 10:23 Navigation Pane Default View and Datasheet and Design Views for Tables 13:11 Exploring Datasheet View, Design View, and SQL View for Query Objects 16:29 Exploring Form View, Layout View, and Design View for Form Objects 19:50 Exploring Report View, Layout View, Design View, and Print Preview for Report Objects 21:28 Running Macros and Exploring Design View 24:01 Examining VBA Code 26:16 Access Ribbon and Status Bar 27:23 Exploring the Relationships Window and Closing the Database 31:07 Introduction to Creating New Databases 35:23 Creating Blank Databases 41:41 Switching Default Table to Design View and Renaming the Primary Key Field 43:05 Adding Remaining Fields to the Customers Table 46:38 Field Descriptions, Format and Text Limit, and Input Mask 49:49 Using the Caption Field Property 56:52 Creating New Tables in Design View 58:43 Introduction to Entering Data into Tables 1:03:24 Manually Entering Table Data 1:03:55 Importing from Excel - Appending to Existing Table - Employees 1:06:39 Importing from Excel - Appending with Different Data Types Error - Customers 1:10:58 Importing from Excel - Adding Data into A New Table - Categories 1:14:55 Importing from Excel - Adding Data into New Tables 1:18:10 Reviewing Data Types and Field Properties for Imported Tables - Products 1:19:58 Reviewing Data Types and Field Properties for Imported Tables - Orders 1:25:01 Order Details Table - Discussing Composite Key Fields 1:27:59 Setting a Composite Key - Order Details 1:30:02 Sorting Table Data 1:32:56 Inclusive Filtering, Exclusive Filtering, and Filtering by Form 1:34:38 Introduction to Relationships 1:38:46 Adding Tables to the Relationships Window and Organizing Them 1:41:22 Common Fields Between Tables 1:45:02 Creating a One-To-Many Relationship Between Customers and Employees Tables 1:45:28 Creating Relationship Errors 1:49:59 Resolving Data Type Errors and Repopulating Table Fields 1:52:28 Manually Repopulating Table Fields 1:57:41 Creating Lookup Fields in a Table 1:58:42 Changing the Field Size of a Numeric Data Type to Resolve a Relationship Error 2:01:17 Resolving a Data Type Error and Repopulating Table Fields 2:05:55 Creating a Lookup Field in Another Table and Highlighting the Many-to-Many Relationship 2:09:54 Database Basics Recap 2:14:44 Conclusion 2:16:27 #microsoftaccess #access (C) 2022 Learnit, Inc. Any illegal reproduction of this content will result in immediate legal action.




