Microsoft Access 2021 Advanced: Expert Database Management

Make the leap from Access 2021 user to guru with this advanced course and bring your database skills to expert level.

What you'll learn

Understand indexing rules and guidelines

Work effectively in and customize datasheet view

Apply advanced sorting and filtering techniques

Link to tables in other Access databases

Address multi-user issues when sharing database files

Maximize the effective use of macros

Write, edit, debug, and run VBA code

Build advanced queries

Write and modify SQL statements.

Requirements

A working knowledge of Microsoft Access including how to create and manage databases. This is an advanced course.

Microsoft Access 2021 downloaded and installed on your machine (ideal but not essential)

Description

**This course includes downloadable course files to work with and follow along.**Are you already familiar with the basics of Microsoft Access and eager to delve into more advanced concepts and features? Look no further! Welcome to our comprehensive training course, Microsoft Access 2021 Advanced, specifically designed for individuals like you who want to expand their expertise and maximize the potential of this powerful database application.Building upon your current foundation with Microsoft Access, this course takes your database management skills to new heights, enabling you to tackle complex data challenges with confidence and efficiency.Our training program is tailored to meet the needs of intermediate and advanced users who seek to master the intricacies of Access 2021. Whether you are a seasoned data professional, a database administrator, a software developer, or an aspiring power user, this course will equip you with the skills and knowledge necessary to harness the full potential of Microsoft’s advanced database management techniques.Throughout the course, you will embark on an immersive learning journey, exploring a wide range of advanced topics. We will guide you through mastering complex queries, optimizing database performance, writing SQL code, developing macros, leveraging advanced forms and reports, and integrating Access with other applications and data sources.Whether you aspire to become a database expert, advance your career, or enhance your problem-solving abilities, this course will meet you at your skill level and provide the necessary guidance to become proficient in Microsoft Access 2021. Our goal is to empower you with the skills and knowledge to tackle complex data challenges, optimize performance, and leverageIn this course, you will learn how to:Create primary keysUnderstand indexing rules and guidelinesSet up the sample ‘Northwind’ databaseWork efficiently in datasheet viewCustomize datasheet viewApply advanced sorting and filtering techniquesCreate sub-datasheetsLink to tables in other Access databasesInstall and set up SQL Server ExpressSplit an Access database into front end and back endConvert tables to local tablesAddress multi-user issues when sharing database filesWork through the basics of macrosModify the AutoExec macroUnderstand macro eventsAdjust macro security settingsHandle macro errorsCustomize the quick access toolbarConvert macros to VBA codeWrite and run VBA codeUnderstand VBA error handlingCreate modules, subs, functions, IntelliSense, and variablesName variables and stringsWork with standard functionsAdd events to a databaseCreate switchboards and navigation forms.Format bound and control formsSplit formsCreate tabbed formsAdjust combo-box propertiesBuild advanced queriesWrite and modify SQL statementsUnderstand joins and join typesWork with action queriesCreate subqueriesProtect the database and VBA code.This course includes:6+ hours of video tutorials50 individual video lecturesCourse and Exercise Files to follow alongCertificate of completion

Overview

Section 1: Introduction

Lecture 1 Course Introduction

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 Set Up for Success in Access 2021

Section 2: Primary Keys and Indexes

Lecture 7 Primary Keys and Indexing Rules and Guidelines

Lecture 8 More About Indexes

Section 3: Using Datasheet View

Lecture 9 Setup the Northwind Database

Lecture 10 Work in a Datasheet View

Lecture 11 Customize Datasheet View

Lecture 12 Advanced Sorting and Filtering in Datasheet View

Lecture 13 Subdatasheets

Lecture 14 Exercise 01

Section 4: Linking to Other Access Databases

Lecture 15 Linking Two Tables to Other Access Databases

Section 5: Using ODBC and SQL Server

Lecture 16 Install SQL Server Express

Lecture 17 Setup SQL Server Express

Lecture 18 Exercise 02

Section 6: Splitting an Access Database

Lecture 19 Splitting an Access Database into Frontend and Backend

Lecture 20 Convert To Local Table

Lecture 21 Addressing Multi-user Issues when Sharing Data

Lecture 22 Exercise 03

Section 7: Macros

Lecture 23 Basics of Macros

Lecture 24 Macro on Events; AutoExec

Lecture 25 More About AutoExec

Lecture 26 Macro Security Settings

Lecture 27 Exercise 04

Section 8: The Ribbon

Lecture 28 Customize the Quick Access Toolbar and Tabs

Section 9: Visual Basic for Applications

Lecture 29 Convert Macros to VBA

Lecture 30 Run VBA Code and Error Handling

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

Lecture 32 Scope, Variable Naming and Strings

Lecture 33 Standard Functions: Logical, Case and Loops

Section 10: Access Events Model

Lecture 34 Adding Events to Assets Database

Lecture 35 Exercise 05

Lecture 36 Common Events: Form and Report Events

Lecture 37 Switchboard, Navigation Forms and Error Handling

Lecture 38 Exercise 06

Section 11: Forms

Lecture 39 Formatting Bound and Control Forms

Lecture 40 Split Forms and Macro Error Handling

Lecture 41 Creating Form with Tab

Lecture 42 Go To Combo Box and Its Properties

Lecture 43 Exercise 07

Section 12: Advanced Use of Queries

Lecture 44 Basics of Queries

Lecture 45 Syntax of SQL Statements

Lecture 46 Use of Multiple Where Criteria & Select Statements Function

Lecture 47 Joins and Join Types

Lecture 48 Exercise 08

Lecture 49 Action Queries - Part 1

Lecture 50 Action Queries - Part 2

Lecture 51 Subqueries

Section 13: Protecting the Database and Code

Lecture 52 Protect the Database and VBA Code

Lecture 53 Exercise 09

Section 14: Conclusion

Lecture 54 Course Close

Experienced database managers or those who are familiar with Access 2021/365 or older.,Anyone who wants to learn data and database management using Microsoft Access