Tutorials, Resources & Training Videos

for Microsoft Access, Excel, SQL, VBA, Power Query, Power BI, PowerApps, Flow Automation, Macros, Database Design & More

​

Links to our and other tutorials, documentation, tools, samples, tips and other helpful reference materials for PowerAccess, Microsoft Access, SQL & VBA as well as Query, Macro, Report, Form & Table Design.

​

PowerAccess Tutorials

​

• PowerSQL & PowerAccess Query Design Examples

• Converting Excel Formulas to Access Database & SQL Queries with PowerAccess

​

​

Intro to Microsoft Access Tutorial Sequence

​

1. Introduction to Access (from Quackit)

2. Create a Database

3. Create a Table

4. Create a Table in Design View

5. Create an Input Mask

6. Add Data to Table

7. Import Data from a CSV File

8. Create a Relationship

9. Create a Lookup Table

10. Create a Query

11. Create a Query with User Input

12. How to use the Expression Builder

13. Export Data to Excel (and XML)

14. Create a Form

15. Add a Combo Box to a Form

16. Create a Report

17. Create a Macro

18. Backup a Database

19. Split a Database

20. Make an Executable Database

​

​

Microsoft Access Tutorials

​

• Access 2016: Getting Started in Access @ GCF LearnFree.org (Best Tutorial Sequence - Written + Screenshots + Videos)

• Access 2016: Create a Database @ Quackit (Quick Start Link)

• Access Tutorials List @ LearnFree

• Access Tutorials Lists @ Quackit

• Introduction to Microsoft Access 2016 @ FunctionX (More Technical Tutorial)

​

​

SQL How-To By Topic

​

• SQL Introduction

• SQL Syntax

• SQL Select

• SQL Where

• SQL Order By

• SQL Top

• SQL Distinct

• SQL In

• SQL Alias

• SQL Join

• SQL Inner Join

• SQL Outer Join

• SQL Insert

• SQL Update

• SQL Delete

• SQL Functions

• SQL Count

• SQL Create

• SQL Create Database

• SQL Create Table

• SQL Create Index

• SQL Alter Table

• SQL Summary

​

Advanced Microsoft Access

​

• Deploying Microsoft Access Databases - Deployment Options and Compiled, Protected .ACCDE or .ACCDR Files (Our Tutorial)

• Custom Ribbon Bar Menu for End-Users

​

​

VBA & Macro Designer

​

• VBA Macros + Macro Designer (VBA & Macro Designer Tutorial - LinkedIn Article)

• Access 2016: Create a Macro @ Quackit

• Introduction to Access Programming @ Microsoft

​

​

Query Design & SQL

 

• Create a Simple Query in Design View @ Quackit

  • How to Use the Expression Builder

• Designing a Simple Query @ LearnFree

  • More Query Design Options

• Introduction to Queries @ FunctionX (includes Query Designer & SQL)

• SQL Functions Reference @ W3Schools (Not Access-specific, some functions not available in Access)

​

Access How-To by Topic

 

From Quackit, going beyond the "Intro to Microsoft Access Tutorial Sequence" tutorials listed for them

​

Databases

​

• Create a Blank Database

• Create a Database from a Template

• Save a Database as a Template

• Open a Database in Exclusive Mode

• Password Protect a Database

• Encrypt a Split Database

• Remove the Password from a Database

• Import a SQL Server Database into Access

• How to do a Mail Merge

​

Tables

​

• Create a Table in Datasheet View

• Create a Table in Design View

• Create a Linked Table

• Create a Linked Table to SQL Server

• How to use the Linked Table Manager

• Update Linked Tables after the Backend Changes Location

• Export a list of Linked Tables to Excel

• Create a Totals Row

• Create a Calculated Field

 

Queries

​

• Create a Simple Query in Design View

• Create a Parameter Query

• Find Duplicate Records

• How to use the Crosstab Query Wizard

• Create a Crosstab Query in Design View

• Convert a Normal Query to a Crosstab Query

• Convert a Crosstab Query to a Normal Query

• Fix Missing Fields in a Crosstab Query

 

Forms

​

• How to Create a Blank Form

• Create a Form from a Table

• Add a Lookup Control to a Form

• How to Resize Form Controls

• How to Change a Form's Background Color

• How to Change a Form Header's Background Color

• Add a Subform to an existing Form

• How to Create a Subform from a Table

 

Reports

​

• Create a Report from a Table

• How to Group a Report

• Create a Grouped Report using the Report Wizard

• Group a Report by Multiple Fields

 

Database Tools

​

• Create a Database Diagram

• How to use the Database Documenter

• Compact & Repair a Database Manually

• Compact & Repair a Database Automatically

• How to Display an Object's Dependencies

​

Microsoft Access Technical Tutorial Sequence

​

1. Introduction to Microsoft Access (from FunctionX)

2. Introduction to Tables and Data

3. Introduction to Data Relationships

4. Managing Data Relationships

5. Anatomy of a Table

6. Introduction to Form/Report Design

7. Characteristics of a Form

8. Introduction to Controls Design

9. Form/Report Design and the Location of Controls

10. Design Maintenance on Forms & Reports

11. The Appearance of Windows Controls

12. Form Layout

13. Events and Macros

14. Introduction to Categories of Windows Controls

15. Controls Containers and Delimiters

16. Button-Based Controls

17. Combo and List Boxes

18. Objects, Pictures, and Attachments

19. Introduction to Expressions and Functions

20. Strings

21. Numeric Values

22. Expressions and Functions in Numeric Values

23. Conditional Values

24. Date and Time Values

25. Data Import and Export

26. Introduction to Record Maintenance

27. Creating a Report

28. Characteristics of a Report

29. Grouping Records on a Report

30. Introduction to Queries

31. Topics on Data Selections

32. Introduction to Sorting Records

33. Topics on Sorting Records

34. Introduction to Filtering Records

35. Introduction to Data Analysis

36. Filtering by Patterns

37. Other Topics on Filtering Records

38. Special Windows for Data Analysis

39. Data Analysis and Logical Conjunctions

40. Data Analysis and Logical Disjunctions

41. Introduction to Data Joins

42. Queries and Data Joins

43. Data Joins and Relationships

44. Special Queries

45. SQL Aggregate Functions

46. Introduction to Data Analysis With Charts

47. Types of Charts

​

​

VBA Technical Tutorial Sequence

​

1. Introduction to MS Access and VBA

2. Introduction to Variables and Data Types

3. Introduction to Procedures and Functions

4. Introduction to Built-In Functions

5. Introduction to Classes and Objects

6. The Properties of a Class

7. Enumerations

8. Introduction to Strings

9. String-Based Functions

10. Introduction to Date Values

11. Introduction to Time Values

12. Introduction to Conditions

13. Conditional Statements and Functions

14. Boolean Conjunctions and Disjunctions

15. Conditional Selections

16. Introduction to Collections

17. Counting and Looping

18. Error Handling

​

​

Microsoft Access Tools & Resources

​

• How to Repair Microsoft Access Databases and Avoid Corruption for Multi-User Databases [Tutorial with Free Tool Downloads]

• Stellar Phoenix Access Database Repair Utility

• Jet Compact Utility for Advanced Microsoft Access Database Repair

​