Microsoft Access 2021 Beginner to Advanced Course Bundle

[Farid]

Microsoft Access 2021 Beginner To Advanced Course Bundle
Published 9/2023
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 6.38 GB | Duration: 13h 35m
Master Microsoft Access 2021 with this great value beginner to advanced course bundle and elevate your database skills!

Overview

Section 1: Beginners: Introduction

Lecture 1 Introduction to Access 2021

Lecture 2 WATCH ME: Essential Information for a Successful Training Experience

Lecture 3 DOWNLOAD ME: Course Exercise Files

Lecture 4 DOWNLOAD ME: Course Demo Files

Lecture 5 Downloadable Course Transcript

Lecture 6 Acquiring Access 2021

Lecture 7 What's New in Access 2021?

Lecture 8 Exercise 01

Section 2: Beginners: Get Started with Access 2021

Lecture 9 Use Database Templates

Lecture 10 Create, Save, and Open Databases

Lecture 11 Explore the Access Interface and Backstage

Lecture 12 Customize the Quick Access Toolbar

Lecture 13 Access Menus

Lecture 14 Keyboard Shortcuts and Key Tips

Lecture 15 Online Help

Lecture 16 Access Options

Lecture 17 Exercise 02

Section 3: Beginners: Work with Tables

Lecture 18 Create a Table and Fields

Lecture 19 Index Fields, Primary Keys, and Add Records

Lecture 20 Use the Lookup Wizard to Create a Drop-down List

Lecture 21 Numeric Fields and Data Validation Rules

Lecture 22 Add More Table Fields

Lecture 23 Exercise 03

Section 4: Beginners: Import Data

Lecture 24 Importing Data from Excel

Lecture 25 Import Data from a Text File

Lecture 26 Exercise 04

Section 5: Beginners: Datasheet View

Lecture 27 Design in the Datasheet View

Lecture 28 Sort and Filter in Datasheet View

Lecture 29 Enter and Modify Data in Datasheet View

Lecture 30 Exercise 05

Section 6: Beginners: Create Relationships

Lecture 31 Relationships Explained

Lecture 32 Set up Relationships

Lecture 33 Create a Link Table: Part 1

Lecture 34 Create a Link Table: Part 2

Lecture 35 Edit the Link Table

Lecture 36 Exercise 06

Section 7: Beginners: Forms

Lecture 37 Create a Form: Form Wizard

Lecture 38 Form Properties

Lecture 39 Modify a Form: Single Form vs Continuous View

Lecture 40 Forms in Layout View

Lecture 41 Forms in Design View

Lecture 42 Exercise 07

Section 8: Beginners: Subforms

Lecture 43 Setting up Subforms: Part 1

Lecture 44 Setting up Subforms: Part 2

Lecture 45 Exercise 08

Section 9: Beginners: Queries

Lecture 46 Create a Query

Lecture 47 INNER, RIGHT, and LEFT Joins

Lecture 48 Run Queries and Aggregate Numeric Data using Query Wizard

Lecture 49 Exercise 09

Section 10: Beginners: Validations and Expressions

Lecture 50 Set up More Validations and Expressions

Lecture 51 Basic Calculations using Expressions

Lecture 52 Exercise 10

Section 11: Beginners: Reports

Lecture 53 Run a Basic Report

Lecture 54 Custom Report Design

Lecture 55 Complex Reports

Lecture 56 Exercise 11

Section 12: Beginners: More Data Types

Lecture 57 Other Data Types: Yes/No

Lecture 58 Other Data Types: Attachments

Lecture 59 Exercise 12

Section 13: Beginners: More About Forms

Lecture 60 Form Controls: Option Buttons

Lecture 61 Form Themes and Design

Lecture 62 Navigation Forms

Lecture 63 Exercise 13

Section 14: Beginners: Share an Access Database

Lecture 64 Export Parts of an Access Database

Lecture 65 Database Properties and Encryption

Lecture 66 Exercise 14

Section 15: Beginners: Additional Access Features

Lecture 67 Compact and Repair

Lecture 68 Printing and Database Documenter

Lecture 69 Exercise 15

Section 16: Beginners: Course Close

Lecture 70 Course Close

Section 17: Advanced: Introduction

Lecture 71 Course Introduction

Lecture 72 WATCH ME: Essential Information for a Successful Training Experience

Lecture 73 DOWNLOAD ME: Course Exercise Files

Lecture 74 DOWNLOAD ME: Course Demo Files

Lecture 75 Downloadable Course Transcript

Lecture 76 Set Up for Success in Access 2021

Section 18: Advanced: Primary Keys and Indexes

Lecture 77 Primary Keys and Indexing Rules and Guidelines

Lecture 78 More About Indexes

Section 19: Advanced: Using Datasheet View

Lecture 79 Setup the Northwind Database

Lecture 80 Work in a Datasheet View

Lecture 81 Customize Datasheet View

Lecture 82 Advanced Sorting and Filtering in Datasheet View

Lecture 83 Subdatasheets

Lecture 84 Exercise 01

Section 20: Advanced: Linking to Other Access Databases

Lecture 85 Linking Two Tables to Other Access Databases

Section 21: Advanced: Using ODBC and SQL Server

Lecture 86 Install SQL Server Express

Lecture 87 Setup SQL Server Express

Lecture 88 Exercise 02

Section 22: Advanced: Splitting an Access Database

Lecture 89 Splitting an Access Database into Frontend and Backend

Lecture 90 Convert To Local Table

Lecture 91 Addressing Multi-user Issues when Sharing Data

Lecture 92 Exercise 03

Section 23: Advanced: Macros

Lecture 93 Basics of Macros

Lecture 94 Macro on Events; AutoExec

Lecture 95 More About AutoExec

Lecture 96 Macro Security Settings

Lecture 97 Exercise 04

Section 24: Advanced: The Ribbon

Lecture 98 Customize the Quick Access Toolbar and Tabs

Section 25: Advanced: Visual Basic for Applications

Lecture 99 Convert Macros to VBA

Lecture 100 Run VBA Code and Error Handling

Lecture 101 Create Modules: Subs, Functions, Intellisense and Variables

Lecture 102 Scope, Variable Naming and Strings

Lecture 103 Standard Functions: Logical, Case and Loops

Section 26: Advanced: Access Events Model

Lecture 104 Adding Events to Assets Database

Lecture 105 Exercise 05

Lecture 106 Common Events: Form and Report Events

Lecture 107 Switchboard, Navigation Forms and Error Handling

Lecture 108 Exercise 06

Section 27: Advanced: Forms

Lecture 109 Formatting Bound and Control Forms

Lecture 110 Split Forms and Macro Error Handling

Lecture 111 Creating Form with Tab

Lecture 112 Go To Combo Box and Its Properties

Lecture 113 Exercise 07

Section 28: Advanced: Advanced Use of Queries

Lecture 114 Basics of Queries

Lecture 115 Syntax of SQL Statements

Lecture 116 Use of Multiple Where Criteria & Select Statements Function

Lecture 117 Joins and Join Types

Lecture 118 Exercise 08

Lecture 119 Action Queries - Part 1

Lecture 120 Action Queries - Part 2

Lecture 121 Subqueries

Section 29: Advanced: Protecting the Database and Code

Lecture 122 Protect the Database and VBA Code

Lecture 123 Exercise 09

Section 30: Advanced: Conclusion

Lecture 124 Course Close

Beginner Access 2021 users who want to explore the software's functionalities,Users new to Microsoft Access 2021 and those upgrading from previous software versions,Experienced database managers or those who are familiar with Access 2021 wanting to expand their skills and explore the software's more advanced features,Anyone who wants to learn data and database management using Microsoft Access

Microsoft Access 2021 Beginner to Advanced Course Bundle (6.38 GB)

KatFile Link(s)

[To see links please register or login]

RapidGator Link(s)

[To see links please register or login]