Posted	Video Title			Length	Notes
	Playlist: Learn Access By Crystal			This is a sequential list of videos for learning Access.
2026             Goto Top
2026-10-18	Word Document from Access Query using VBA - Run and Change			15:28	How to call VBA code to create a Word document from an Access query. Three examples using open-source code. Use Word to change documents.
2024             Goto Top
2024-07-17	How does Bubble Sort work?			5:50	Line-by-line walkthrough of VBA code to sort a string array using bubble sort.
2023             Goto Top
2023-08-23	SQL Spacer VBA and Access Add-in			6:58	Quickly make SQL Statements easier to understand by inserting spaces and line breaks where it makes sense. Untangle logic, inspect something that was constructed in VBA and doesn't work quite right, create documentation, and more. Run the VBA code and get the result to put somewhere yourself, or open the Access database with a convenient form and also set up to be an Add-in if you want it to be available anytime you're in Access.
2023-07-17	How To Draw Birthday Balloons in Access			21:26	It's Steve's birthday! He's in a group of Access developers that I meet with. Shared my screen and opened the Access database that you can download. PartyWords were modified for Steve to add terms like Access and Chocolate. Then Access made a fun birthday card with ballons for him, a few times. Look at the VBA code and see how it works. Download ACCDB: Draw Birthday Balloons in Access
2023-05-04	Report Draw Reference for Access			5:03	Short video about the web page with my notes as I was learning about drawing on Access reports. It has syntax, values, and explanations. I hope it will be a good reference for you too. Web page: Report Draw Reference and VBA Syntax
2023-02-20	Draw the Moon on Access Reports			0:30	Draw the moon on Access reports using VBA in any phase, any position, any color, any size.
2023-01-17	Draw a Rainbow on Access Reports			10:14	Liven up your Access reports with rainbows! Learn how it's done or simply how to call the Draw_Rainbow procedure.
2023-01-05	Read Word Selection using Access			8:32	Use Access to read information from the Word selection. Show the text that's selected on an Access form. If a field is found, display it. If the field is also a document property (DOCPROPERTY), show the property name. If there's a format specified, show it.
2022             Goto Top
2022-12-25	Draw Christmas Tree and Star on Access Report			7:36	♫ on the first day of Christmas, Access gave to me a star on a Christmas Tree ♫ Web page, VBA and ACCDB to: Draw a Christmas Tree and Star
2022-09-06	Word Document Properties and Fields			14:05	Properties are a great way to substitute data in your Word document. When the value of a document property is changed, everywhere it is referenced also changes. No find and replace needed, just update the document! Web page: Word Built-in and Custom Document Properties, and VBA
2022-07-26	Sort Access form by any column of any combo box.			19:21	See the magic of prefacing a control name with "Lookup_" Web page with Download database and VBA Code to sort a form by combo columns.
2022-06-29	Big Checkbox in Access with Conditional Formatting			2:18	See how a textbox can be used to look and behave like a checkbox. Make the checkbox whatever size you want, change its color, and set conditional formatting. Click on it to change its value and appearance.
2022-02-15	fix Northwind 2. Structure Contacts			21:05	Examine how contact information is being stored in the Northwind template and what you can do to make it better.
2021             Goto Top
2021-08-20	Document Access Tables to Excel			10:16	Document your Access database tables to Excel! Make a list of all the tables, a data dictionary, and more. Document_Tables2Excel VBA Code
2021-07-03	Word - Save your Table as a Template			9:21	I'm writing a book about Microsoft Access, and Word is helping me. I'll show you how to save a template table so you can make a new table that has the format of a table that you like.
2021-06-13	fix Northwind 1. Relationships Diagram			22:05	What's wrong with Northwind? Let's fix it! This is part 1 -- we're starting with the relationships diagram. Northwind Traders is a fictitious company created by Microsoft to showcase features in Microsoft Access. It's great for ideas, but is just a starting point. Let's find out what to do to make this a serious application for business use.
2020             Goto Top
2020-11-01	Hierarchical Relationships in Access			7:24	Hierarchical relationships are common in real data. Create a simple hierarchical structure in an Access database by putting a foreign key in the same table as the primary key. We'll make 2 queries to show the hierarchy by using one table multiple times, one from bottom-up, and one from top-down. SQL, Relationships, modify RowSource of a combo box to show more columns.
2020-09-24	Make Records in a Cross-Reference Table with VBA			7:24	Shows how to use code I posted to normalize data automatically! You just need to tell it a few things, and this free tool can save you a lot of time. Everything is open and the code is discussed in the video. Cross-Reference VBA Code
2020-09-16	Add New Data with NotInList VBA for Combo box			7:24	Add to a combo box list using the NotInList event by adding a record to the table for its RowSource. Pass the table name, field name, new data, and response to a general function that constructs and runs an SQL statement. NotInList VBA Code
2020-07-04	Draw American Flag using VBA			8:34	Draw a picture of an American flag on an Access report, any size, any position, using VBA Line and Print methods. American Flag VBA Code
2020-06-29	Merge Data from Access into a Microsoft Word Letter			5:01	How to how to merge data from Access into a letter you write with Microsoft Word, from the Word side
2020-04-22	Get Northwind Database for Microsoft Access (cc)			5:01	How to get the popular Northwind Database template for Microsoft Access!
2020-03-29	Import/Export QAT			12:52	The Quick Access Toolbar (QAT) can help you work faster and be more productive. Learn how to customize it. Save time by exporting and importing the QAT definitions.
2020-02-28	RowSourceType Callback Function			12:33	The RowSourceType property of a combo box or list box determines how Microsoft Access will get the data to show for the list of choices. Did you know that, instead of picking Table/Query, Value List, or Field List, you can actually put a custom callback function name here?!? I'll show you how to do that :)
2019             Goto Top
2019-10-29	Unit Circle			27:06	Math. Learning the Unit circle helps you master Trigonometry and calculate where points are. What is Sine, Cosine, and Tangent for different angles? and how are they calculated? How 360° and other angles relate to pi radians. Do you want to know how tall a tree is? There is an easy way to figure it out. I created this video tutorial to show how the math worked for my analog clock in Access. Then I saw a bigger purpose, for anyone. To understand a circle, we use the Pythagorean Theorem and right triangles. The graphics were done with an Access report using the Circle, Line, and Print methods. Teachers and developers ... for more information and clickable index, visit msaccessgurus.com/Teach/UnitCircle.htm
2019-05-17	Shuffle Data Imported from Excel			24:45	After data is imported from Excel, shuffle it into the different tables where it needs to go. Append customers from product order information and create an expression for a calculated field. Many people start data in Excel and then fail to properly structure it when it goes into Access. Hopefully this tutorial will get you on the right path!
2019-04-23	How to Make and Install an Access Add-In			11:51	An add-in lets you run code in any database without having to import modules, so they can save time and make your code more accessible. An add-in can have a form pops up in another database, just like it was really there. Hopefully this tutorial will take the big mysery out of add-ins, and maybe you'll make some cool ones! ... or just use the add-ins here that are Free and not protected so you can learn since they are just ACCDBs that have been renamed. Now add-ins seem easy, but they weren't when I first tried! like most everything. If there are add-ins you aren't using, you can uninstall them. If you leave add-in files in the Menu Add-ins folder, they are easy to put back again.
2019-03-27	Import Excel Spreadsheet into Access			14:15	Use the import wizard in Microsoft Access to import an Excel spreadsheet. Change data type. Choose table name. Modify table design. Create an update query. Read the April 2019 Access article in the Technology section of SFmagazine for related information.
2018             Goto Top
2018-09-25	Highlight Current Record			8:53	How to Highlight Current Record in an Access continuous or datasheet form that shows muliple records. Download Highlight Current Record with Conditional Formatting and VBA. Read article.
2018-05-12	Analog Clock with Moving Hands + Sounds in Access			4:28	Analog Clock in Access! Optionally, you can also play a sound as each second ticks by. download Clock.
2018-04-16	Wrapper Function that Calls Excel for Query in Access			13:25	Wrapper Function to call Excel so you can get results in a query. Calculate payments for loan offer information stored in a table. In a query, you can define a column with a calculated field that calls a wrapper function to use Excel's PMT function. The values for fields and calculated fields are passed. Display columns in Color using Format. Use VBA to do the magic, and understand each statement in the code as it is explained.
2018-04-07	Use Excel's PMT function in Access!			15:47	Use Excel worksheet functions in an Access form. What Excel has, Access can use. See a form in Access that collects data and then uses Excel's PMT function. Just click the "Calculate" button, and voila! As a user, you have no idea that Access just went out to Excel to do a calculation. VBA can reference Excel, and use what it has. Late-binding. Form Unload. Object variables. With... End With. Validate data so if required information is missing, the user gets a message, is then placed where data needs to be filled, and code processing stops. download Excel PMT Calculator in Access. Read article.
2018-02-20	Create custom functions in Access using VBA			10:45	Write a custom function in VBA ... user-defined function, or UDF. Use your new function in a query. If you can create a complex expression, then you also have the logic to write VBA too -- give it a try! Use the Debug, or Immediate, Window to explore dates ... and 'convert' them to numbers (they already are -- but see dates displayed as a number too). Read article.
2017             Goto Top
2017-12-01	Synchronize List Box in Access using SQL and VBA			10:35	Modify SQL with VBA. If you have never written code or looked at an SQL statement before, no problem! ... give it a try. Many doors open to cool things. Learn how to synchronize a list box (or combo box, since they are similar) to dynamic data on a form ... such as showing list of orders for the active customer. Read article1. Read article2
2017-11-09	Subform to show Calculations in Microsoft Access			10:32	Use a subform to show calculations. In depth look at a subform control that shows the sum of orders and payments for a customer. Explore properties and see how to aggregate, get statistics, and synchronize results for your data. Calculations are in an underlying query that feeds the Record Source of the subform, which is linked to the mainform using Link Master Fields and Link Child Fields. Additional properties: Source Object, Name, Width, Height, Top, Left, Border Color, Border Style, Special Effect, Visible, Locked, and Enabled. Read article.
2017-10-15	Mainform + Subforms for Payments			8:38	Mainform + Subforms. Mainform collects payment information for customer purchases. See how subforms and listboxes are used to dynamically show calculated data based on information displayed on the main form. Enter key behavior setting in the Access Options. Anchoring. Read article.
2017-09-17	What is a Combo Box? Microsoft Access			11:25	Combo boxes are a fantastic way to show meaningful information whilst actually storing something that may be cryptic to the human eye. A combo box is a combination of a list box and a text box. Learn how to change a textbox control into a combo box. Properties: Name, Row Source, Column Count, Column Widths, List Width, Column Heads, Status Bar Text. Read article.
2017-07-27	How to Create Calendar Reports from Access Queries ... as shareable Web Pages - easy!			8:57	Do you have data with dates? See how easy it is to show your data on a calendar with a free tool you can download. Use a query to line up your data, and then presto! Calendar! Read article.
2017-07-09	Access Query - Triangles, Circles, Compare Previous Stock Price			11:19
2017-06-17	Bar Graphs in Access Query using Unicode			6:53
2016             Goto Top
2016-10-19	Access -- Polish Reports			25:01
2016-09-08	Grouped Report using Wizard in Access then Modify			16:53
2015             Goto Top
2015-06-09	How To Migrate Data from Desktop to Access App			32:35
2015-01-28	How To Make Video Captions, Free Microsoft Access Tool			6:59
2014             Goto Top
2014-12-09	Learn Access -6- Create a Continuous (Multiple Items) Form in Microsoft Access			28:02	Lesson 6. Create a Continuous form, or Multiple Items form, to display many records at a time. Modify, add, name, select, align, resize, and best-fit controls. Switch between Form and Design Views. Property Sheet. Change textbox to combo box, hide first column, set the RowSource using query designer. Field descriptions are Status Bar Text. Shift-F2 for Zoom box. Import QAT. Write VBA. Tracking fields with the date/time record added and edited. download Contact Template QAT customization files: 2010 . 2018             Goto Top music by April Kelly, "Blow Me Away", songs, new
2014-10-21	Projects, Tasks, and Time in contact Template for Microsoft Access			03:25
2014-10-12	Access Contact Template Contact Management System, CMS			30:43	Shows free Contact Template download for Access with tables for names, addresses, phones, emails, websites, lists, notes, attachments, plus about 80 tables you can customize for your business and personal needs. Also has several forms, reports, and a report menu that processes criteria. Uses VBA. The contact template is a split application, with front-end and back-end, and a folder below for referenced files. It is meant for teaching and is also a useful application you can customize. download Contact Template music by Ken Gaines, "Pride of the Morning", "Razzmatazz"
2014-09-21	Tool: ListFiles tool using Lawyer example			7:54
2014-08-14	How To Make a Graph with Microsoft Access			7:44
2014-08-12	Tool and Code: Manipulate Graphs in Microsoft Access using VBA			22:05
2014-07-31	Learn Access -5- Modify Data Structure			4:11	music by Melanie Phippard, "Malibu Barbie"
2014-06-12	Tool: Analyzer for Microsoft Access			5:50	music by Mark Davis, "Beacons"
2014-05-29	Tool: Document Query Calculated Fields			4:09	music by JD Live, Slade
2014-02-25	Tool: Channel Tracker			2:19	Database to keep track of YouTube video information (#Views, Likes, Dislikes). Because page format keeps changing, the scrape feature no longer works in the download mentioned, but you can see how it was done.
2013             Goto Top
2014-01-30	Office App Store: JavaScript API Tutorial for Office using Excel 2013			15:16	music by Jubal Lee Young, "Greed Is The Creed" w/band, solo
2013-07-07	Learn Access -4- Tables and Relationships			36:05	music by JD Live, Colors of the Lonely
2013-01-01	Access: Fill Missing Value, Tracking field			2:29
2013-01-01	Access: Filter By Selection			1:03
2012             Goto Top
2012-12-18	Access Defaults ... take a tour ...			16:21
2012-12-18	Access - Requery a Query Shortcut			1:21
2012-12-16	PowerPoint: Change Slide Number			0:58
2012-12-16	PowerPoint: Apply Theme from Another Presentation - Document Screenshots			1:05
2012-12-16	Get Path and Filename for Access, Excel, Word, and PowerPoint			2:58
2012-12-16	Word: Figure Captions, Azure Management Portal, Table of Figures			3:20
2012-12-16	Access QAT (Quick Access Toolbar): Alignment Icons			2:57	Customize the QAT and show it below the ribbon. To make it really fast to line up controls when designing forms and reports, add icons to align them. Other useful commands are ordering (bring to front, send to back), grouping and ungrouping, changing views, ... and the list goes on.
2012-12-15	Word: Create Table from Text, Table of Tables			3:50
2012-09-22	Add Save As Icon to QAT captions in English, Français, Dutch, and Deutsch			2:15	QAT. Add SaveAs to the Quick Access Toolbar to make saving with a new name faster and more efficient. For instance, modify a query and quickly save it with a new name. Try this in Excel, Word, and PowerPoint too!
2012-09-14	How to Insert Foreign and Special Characters -- Deutsch, English			2:28
2012-08-02	Tip: Enforce Referential Integrity (RI) on Access Relationships			3:13
2012-04-02	Convert VLOOKUP equations to Access, by Crystal -- VLOOKUP Week			23:42
2012-03-30	Excel VLOOKUP to Calculate Distances using Latitude & Longitude, by Crystal -- VLOOKUP Week			15:06
2012-01-29	Crystal's Code Documenter - Free Utility for Access 2007 and 2010			12:26
2012-01-02	Learn Access -3- Build a Database -- music by David Bailey			8:01	music by David M. Bailey, "One More Day"
2011             Goto Top
2011-06-11	Access Utilities: Simil Fuzzy String Matching by Tom van Stiphout, VBA -- English, Dutch, French			9:58
2011-02-23	Access Utilities: Tony's Auto FE Updater			7:05
2009             Goto Top
2009-11-02	Access 2010: Outlook-Style Calendar in Browser, by Albert Kallal			6:54
2009-06-09	Learn Access -2.C- Planning Fields and Relationships -- English, French -- music by Mark Davis			10:00	music by Mark Davis, "Broken Ground"
2009-03-10	Learn Access -2.B- Planning Database Fields			9:59	music by Ken Gaines, "Pool", Live performances, YouTube channel
2009-02-17	VBA -- Winner by Random Draw			6:16
2009-02-13	Learn Access -2.A- Planning Design -- English French Portugese			9:28	music by Jubal Lee Young, "I Don't Know What I Want"
2009-01-27	Learn Access -1- Perspective -- English, French, Portugese			9:46	music by Doug Clark Steiger, "These Hands", Play Album
MY PRESENTATIONS             Goto Top
2026-09-20	AL: Exploring UserFoms - Access, Word, Excel, PowerPoint, VBA applications			46:15	What are UserForms, what do they do, and and how do they work? Explore two userforms that you can download and use yourself, and see how to create a userform using Access that will also work in Word, Excel, PowerPoint, and more. Download userforms with source code, steps to create a UserForm to Change CaSe
2026-03-20	AL: Recursive Functions			52:55	What are Recursive Functions and why would you use one? How do you design and use a recursive function? Step-thru VBA code for List files recursively by Allen Browne and another procedure to save relationship paths. Also discussions about vbNullString, Collections, and Memory. Download presentation + ACCDB databases for ListFile and RelPath
2025-10-22	AL: Expressions, Custom/Built-in Functions, Processing deep dive, VBA, Access, SQL with Adrian Bell			1:02:36	Where can you use expressions? Many, many places. Explore expressions: what they are, how to build them, and where they are used -- and where built-in and custom functions can be used. What's the difference between the different ways to process? VBA Function Reference
2025-03-03	AEA: Data Types with Crystal and Kent (17:54)			17:54	overview of Data Types in Access and SQL Server
2024-12-11	AP: Creating Add-ins that run in Access and Office			33:04	Access is a great tool right out of the box and many of us never go much beyond that basic tool kit. Yet, there are times when we say to ourselves, “Wouldn’t it be nice to have a way to make this task easier?” That’s where add-ins come in. How to create an Access Addin, with Geoffrey L. Griffith Here's the followup videos Part 1 and 2 for : 1. Creating COM Add-Ins Using VSTO by Geoff 2. Creating COM Add-Ins Using VSTO by Geoff
2024-11-10	AEA: Access and SQL Server Relationships + Indexes,with Kent Gorrell and Adrian Bell			1:07:43	Document Relationships. Migrating data from Access to SQL Server. Understand how bitwise AND works.
2024-03-15	AL: Access Tab Control, Unicode, Format (Excel too)			53:08	Three topics: (1) Tab Control (2) Unicode, and (3) Format The Tab Control is great at organizing controls and subforms. Change styles, or don’t show tabs at all and use buttons that can have COLOR to switch pages. How to add space around captions. Use Unicode characters for checkboxes and other places to display characters that look like images except you can change size and color! Get handy tool to lookup characters you might want to use. Change the Format to show cool text without any code -- works in Excel too!
2023-12-23	AP: Modify Word Document Properties with Access			58:41	Word document properties give you a powerful way to substitute data that’s stored in Access. However, the user interface to manage them in Word is inadequate. You'll learn how to do it all in Access instead.
2023-11-25	AL: 2 free tools: List Access Objects, and VBA Code Documenter, step-thru OpenBypass, with Adrian Bell and Peter Cole			1:03:31	Overview of two free tools with source code to document Access databases and VBA projects. See how to use them, and dig into some VBA. 1. List objects for all Access databases in and under a path. Did you write something great but don’t remember where it is? This tool can help you find it, and use for documentation. 2. Read the VBA in a project. Get a list of all the modules, procedures, lines of code, and references, for Access, Word, Excel, PowerPoint, and more.
2023-03-23	AL: Loop and Link CSV Files in Access using Queries			54:51	Access is great at reading data from other places. Tool to get data from CSV files by looping through files in a folder (and subfolders if desired) and linking CSV files as queries. With VBA code that runs SQL statements, new records are added and existing records are updated. What got imported and when is tracked.
2022-06-20	Word Automation from Access VBA Deep Dive			52:58	Create professional Word documents from Access using Word Automation. This is a deep dive into code to create content with text, images, fields, and hyperlinks, format, save, and open the finished document with VBA. AccessUserGroups.org, Access Lunchtime Word Automation VBA Reference and Download
2022-06-02	Drawing Shapes in an Access Report - Elements and Atoms			1:20:28	Learn how to draw on reports! See examples of different types of reports that use drawing. Use the Line Method to draw lines and rectangles, which can be filled with any color, and have any color for the border. Use the Circle method to draw circles, ellipses, and arcs (open and closed). Like Line, any color can be used to fill closed shapes. Use the Print method to write text. AccessUserGroups.org, Access Pacific Report Draw Reference
2022-05-04	Classic vs Modern Charts			1:15:43	Compare Classic and Modern Charts. What are the benefits and shortcomings of each? AccessUserGroups.org, Access Europe
2021-12-28	Beginning Access Developer, Part 4 - VBA! with Maria Barnes			57:12	Fast-paced lesson on VBA. Get exposed! See the possibilities! This is the last part of a series for beginning Access developers. User defined functions, reusing code, dimensioning variables, macro actions and converting to VBA, parameters, modifiers, TempVars, properties, locals, watch, call stack, immediate window, collections, options, compiler directives, VBA Shortcut Keys, and more. AccessUserGroups.org, Access Lunchtime
2021-09-02	Get Extended File Properties from Windows with free Access tools, with Colin Riddington			58:15	What is the metadata that you don't normally see? Overview of free tools by Wayne Phillips (EverythingAccess.com) and Colin Riddington (isladogs.co.uk) Currently, there are more than 300 extended file properties such as the size of a picture or the duration of a video that is now a piece of cake to get! AccessUserGroups.org, Access Pacific
2021-08-31	Beginning Access Developer, Part 3 – Queries, with Maria Barnes			57:12	Queries are powerful! And there are lots of different types of queries you can create with Access. Learn how they can do so much more than just select data Much of what this covers is beyond where a beginner will go ... but knowing what's possible is important. AccessUserGroups.org, Access Lunchtime
2021-02-23	Beginning Access Developer, Part 2 – Forms, Reports, Macros, QAT, with Maria Barnes			52:16	create various forms and reports, formatting, sections, grouping and sorting, error indicators. Ribbon and Quick Access Toolbar (QAT). Macros - AutoExec, AutoKeys. Trust Center and security. AccessUserGroups.org, Access Lunchtime
2020-12-29	Tips and Shortcuts for the Beginning Access Developer, Part 1, with Maria Barnes			54:03	Overview of Tables, Queries, Forms, and Reports -- database design, indexes, relationships, tables, and queries. Different ways to create tables and paste data in from other places. Relationships and Indexes. Shortcuts to navigate, edit, launch features like the Zoom box or Spell Checker, do Window things, enter data, and more. Properties and some settings for options. Creating queries. Lots of Shortcuts! AccessUserGroups.org, Access Lunchtime ShortcutKeys PDF
2020-08-25	Making and Using Access Add-Ins			49:09	How to create and install an Add-in for Microsoft Access, and how to fix some of the errors that you might encounter. AccessUserGroups.org, Access Lunchtime Help page for making add-ins
2020-04-24	CalendarMaker			16:02	Quick overview of how to make calendar reports from any query Access DevCon CalendarMaker database
2020-01-17	CalendarMaker			49:05	Easily make calendars from any query AccessUserGroups.org, Access ET CalendarMaker database