Extended Cut List

Extended Cut Directory
Here is a list of all of my Extended Cut videos. If you're not familiar, many of my TechHelp videos have Extended Cuts which are "deep dives" into the topic. Not every TechHelp video has an Extended Cut, but the ones I do have are listed here. And of course the only way to view the Extended Cut videos is to JOIN as at least Silver Member. What are you waiting for? Join today!

#	Age	Category	Description	Summary	Seen
1	9 hours	Access	Field Selector	Microsoft Access Let Users Choose Which Fields Appear on a Continuous Form
2	6 days	Access	Highlight Text	Highlight All Matching Words for a Search in a Text Box in Microsoft Access
3	19 days	Access	Search Matches	Microsoft Access Highlight Which Fields Match Your Search
4	26 days	Access	Chop Off Decimals	Microsoft Access Hide Decimal Places Without Rounding - Here's the Fix
5	37 days	Access	BOF EOF	Microsoft Access BOF & EOF Explained. Why Check Both for an Empty Recordset?
6	43 days	Access	Overlapping Days	How to Calculate Overlapping Days in Two Date Ranges in Microsoft Access
7	2 months	Access	Class Modules	Microsoft Access VBA Class Modules Explained for Beginners
8	2 months	Access	Logged On	Is Anyone Still Logged On? How to Tell if Anyone is Using Your Microsoft Access Database
9	2 months	Windows	1940 To 2040	Why Windows Changes 1940 to 2040. Adjust the 2-Digit Year Cutoff. Extended Cut for Microsoft Access!
10	2 months	Access	Form Open Time	How to Track How Long a Form Was Open in Microsoft Access Without a Timer Event
11	2 months	Access	Power Apps 2	Power Apps for Microsoft Access & SQL Server (Build a Mobile Front End), Part 2
12	3 months	Access	Fitness 79	Microsoft Access Subform Load Order Timing: Referencing Controls Across Subforms
13	3 months	Access	Write to Clipboard	How to Write Data from Multiple Fields to the Clipboard in Microsoft Access
14	3 months	Access	Design Changes	How To List Recently Changed Objects in Microsoft Access (Forms, Queries, Reports & Tables)
15	4 months	Access	Already Open	Already Open? How to Prevent Multiple Instances of a Microsoft Access Database From Opening
16	4 months	Access	Are You There 3	Are You There? Automatically Log Users Out After Inactivity in Microsoft Access, Part 3
17	4 months	Access	MsgBox Timer 2	How To Create A Countdown Message Box In Microsoft Access - MsgBox with Timer, Part 2
18	4 months	Access	Kanban Board 2	Build a Kanban Board in Microsoft Access - Part 2
19	5 months	Access	Report Columns	How To Create Multiple Columns In Microsoft Access Reports With Text Wrapping
20	5 months	Access	Password Manager 2	How To Build A Password Manager & Generator In Microsoft Access Step By Step, Part 2
21	5 months	Access	Form Controls	How to Use Form Controls as Query Criteria in Microsoft Access - Search Form
22	6 months	Access	Fitness 73	How to Build a Data-Driven Multi-Level Menu in Microsoft Access Using a List Box - Fitness #73
23	6 months	Access	Questionnaire	How to Build a Data-Driven Questionnaire & Survey Database in Microsoft Access
24	6 months	Excel	Comments & Notes	How to Use Comments & Notes in Microsoft Excel - Why Excel Has Two Comment Systems
25	6 months	Access	Filter Subform	How to Filter a Microsoft Access Subform With a Combo Box
26	6 months	Access	Filter Subform	How to Filter a Microsoft Access Subform With a Combo Box
27	6 months	Access	MkDir	How to Create File Folders in Microsoft Access VBA Using the MkDir Statement
28	7 months	Access	Subreports	How To Use Subreports In Microsoft Access To Put Multiple Reports On One Printable Page
29	7 months	Access	Update Field	How To Create An Update Field VBA Helper Function In Microsoft Access
30	7 months	Access	Escape Key	How To Cancel A Long Running VBA Loop With The Escape Key In Microsoft Access
31	7 months	Access	Prevent Errors	How To Prevent Errors When Referencing One Form From Another In Microsoft Access
32	8 months	Access	Sleep Countdown	How To Add a Visible Sleep Countdown Timer Delay in Microsoft Access
33	8 months	Access	Self Cleaning Log	How To Create A Self Cleaning Log In Microsoft Access And Automatically Delete Old Records
34	8 months	Access	Copy Web Page Data 2	How To Copy Web Page Data Into Microsoft Access From Sites Like Amazon And Walmart, Part 2
35	8 months	Access	Fitness 68	Why Microsoft Access Ignores Your Decimal Places (And How to Force It to Behave) Fitness #68
36	9 months	Access	Arrow Key Nav	How To Use Arrow Keys To Navigate Records And Fields In Microsoft Access (Just Like Excel)
37	9 months	Access	App Settings 3	How To Create Configurable System Settings GetSetting And PutSetting In Microsoft Access, Part 3
38	9 months	Access	Duplicate Check	Detect But Allow Duplicate Check Numbers in Microsoft Access
39	9 months	Access	Size Problems	Detect & Prevent Microsoft Access Size Problems Before Your Database Crashes!
40	9 months	Access	Holiday Cards	Holiday Greeting Card Mailing List Database for Microsoft Access. Christmas, Hanukah, Kwanzaa, etc.
41	10 months	Access	Locked Out	Locked Out - How To Bypass Microsoft Access Startup and Get Into Your Database Design
42	10 months	Access	Fitness 61	How to Load Template Data For Records in Your Microsoft Access Database - Fitness #61
43	10 months	Access	Warn Just Once	How to Show a Warning Only Once in Microsoft Access Forms
44	10 months	Access	Fitness 58	Type 2300, Get 11pm. Enter 24-Hour (Military) Time Automatically in Microsoft Access - Fitness #58
45	11 months	Access	Fitness 54	How to Let Users Type Equations Directly Into a Field in Microsoft Access - Fitness #54
46	11 months	Access	Fitness 53	How to Make a Select All Checkbox for Yes/No Fields in Microsoft Access Forms - Fitness #53
47	11 months	Access	Fitness 49	How to Enter Excel-Style Equations in Any Text Box in Microsoft Access - Fitness Part #49.
48	11 months	Access	Fitness 45	Create a Button to Copy an Item Using a Recordset in Microsoft Access - Fitness Part 45.
49	11 months	Access	Chatbot With Memory	How to Make an OpenAI Chatbot in Microsoft Access That Remembers Conversations
50	12 months	Access	Fitness 39	Microsoft Access Fitness Database Part 39: Use the KeyDown Event to Control User Tab Keystrokes
51	12 months	Access	Fitness 38	Microsoft Access Fitness Database Part 38: Managing Combo Box Events with TempVars and AfterUpdate
52	12 months	Access	Fitness 35	Microsoft Access Fitness Database Part 35: Add Daily Totals to Form Footer, Fix Combo Box Defaults
53	12 months	Access	Images From OpenAI	Generate AI Art in Microsoft Access with the OpenAI (ChatGPT) DALL-E API
54	13 months	Access	RecordsetClone	RecordsetClone vs DoCmd.FindRecord - a Better Method for Finding Records in Microsoft Access
55	13 months	Access	Fitness 27	Microsoft Access Fitness Database Part 27: Display & Edit Time Portion Only of a DateTime Field
56	13 months	Access	Fitness 21	Microsoft Access Fitness Database Part 21: Synchronizing Meal Parent and Subform Records
57	13 months	Access	Fitness 20	Microsoft Access Fitness Database Part 20: Handling Nulls With Referential Integrity, Add New
58	13 months	Access	Fitness 16	Microsoft Access Fitness Database Part 16: Validating Required Input with the Before Update Event
59	14 months	Access	Fitness 14	Microsoft Access Fitness Database Part 14: Aggregate Query for Meal Totals, Meal List Form
60	14 months	Access	Fitness 10	Microsoft Access Fitness Database Part 10: Using RecordsetClone to Navigate Form Records
61	14 months	Access	Fitness 7	Microsoft Access Fitness Database Part 7: Detect Form Open State, IsLoaded Function, Event Handler
62	14 months	Access	Fitness 6	Microsoft Access Fitness Database Part 6: Combining Filters, SQL Where Clause, ApplyFilters Sub
63	14 months	Access	Fitness 3	Microsoft Access Fitness Database Part 3: Food Group Table, Combo Box, Continuous Form, Query Alias
64	14 months	Access	Fitness 2	Microsoft Access Fitness Database Part 2: Food Table Design, Nutrition Macros, Food Form, Hyperlink
65	14 months	Access	Faster DLookup 2	Faster Than DLookup: Speed Up Your Microsoft Access Code & Forms with This Simple Technique, Part 2
66	15 months	Access	Accounts Payable 7	Microsoft Access Accounts Payable, Part 7: Advanced VBA Tricks, Show Unpaid Only, Report Details
67	16 months	Access	Storing Duplicate Data 3	How To Store Historical Customer Address Data for Accurate Orders in Microsoft Access, Part 3
68	16 months	Access	Popup Over Control 2	How to Open a Popup Form Over the Active Control and Return a Value in Microsoft Access, Part 2
69	17 months	Access	Do Records Exist?	Check If Records Exist in Microsoft Access: DLookup vs DCount vs Recordset
70	17 months	Word	Drop Down	How to Make Drop-Down Combo Boxes in Microsoft Word (Members: Get Data from Microsoft Access)
71	18 months	Access	Multiple Cascading 5	How to Make Multiple Cascading Combo Boxes in Microsoft Access, Part 5
72	18 months	Access	Kill Access	How To Automatically Kill a Frozen Microsoft Access Task Using a Batch File for Quick Resets
73	18 months	Access	Numbered Form Items	How to Automatically Number List Items in a Form in Microsoft Access
74	18 months	Access	Optimistic v Pessimistic	Optimistic vs. Pessimistic Record Locking in Microsoft Access: Which One Should You Use?
75	19 months	Access	Add To Word Doc	How To Automate Adding Client Data to Word Documents with Microsoft Access VBA Automation
76	19 months	Word	Batch Convert	How To Batch Convert Word Files to PDF Using VBA in Microsoft Word Without Third-Party Tools
77	19 months	Access	Remove Extra Spaces	How to Remove Extra Spaces, Tabs, & Line Breaks and Clean Up Long Text Fields in Microsoft Access
78	20 months	Access	Distribute Text	How to Use Distribute Text Alignment in Microsoft Access Forms and Reports for Even Column Text
79	20 months	Access	Round Up Cents 2	Round Up Cents: How to Round Up Pennies Automatically (Like a Ferengi) in Microsoft Access, Part 2
80	20 months	Access	Job History 3	How to Show Most Recent Job History for Candidates in Microsoft Access, Part 3
81	2 years	Access	SelStart & SelLength	How to Use SelStart and SelLength in Microsoft Access VBA to Manipulate the Cursor and Selection
82	2 years	Access	OpenForm Unfiltered	How to Open a Microsoft Access Form to a Specific Record Without Filtering
83	2 years	Access	Totals Not Saved	Totals Not Saved: Why Storing Calculated Values in Microsoft Access Can Cause Problems
84	2 years	Access	Employee Training 11	Tracking Employee Training and/or Certifications in Microsoft Access, Part 11
85	2 years	Access	Subform Goto First Field 2	Navigate Form Sections and Set Focus on First Field of First Record in Subform in MS Access, Part 2
86	2 years	Access	Shift Click	How to Perform a Different Action on Button Click with Shift Key Pressed in Microsoft Access
87	2 years	Access	Scroll Wheel & Continuous Forms	Stop Scroll Wheel from Moving Records in Continuous Forms While in Notes Field in Microsoft Access
88	2 years	Access	Title Case 2	How to Convert Text to Title Case for Movies, Books, and Songs in Microsoft Access, Part 2
89	2 years	Access	Filter By DOB 2	Filtering Long Customer Lists by Date of Birth in Forms and Combo Boxes in Microsoft Access, Part 2
90	2 years	Access	Send Email with PowerShell	How to Send Email Using PowerShell in Microsoft Access (No Mail Program Required!)
91	2 years	Access	Big Button Form 6	Dynamic Forms with Big Buttons for Data Entry in Microsoft Access, Part 6
92	2 years	Access	Security Flaw 2	Identifying a Security Flaw with Linked Tables in a Microsoft Access Database (and How to Fix it), Part 2
93	2 years	Access	Sex & Gender 2	How to Store Multiple Options for Sex & Gender in Your Microsoft Access Database, Part 2
94	2 years	Access	Shipping Label 2	How to Print a Shipping Label for a Customer with a Separate Ship To Address in Microsoft Access, Part 2
95	2 years	Access	Convert ISO Date Time 2	How to Convert a Full ISO 8601 Date Time Value to Microsoft Access, Part 2
96	2 years	Access	Text Box Hints	How to Display Text Box Hint Instructions Until the User Enters a Value in Microsoft Access
97	2 years	Access	Find Replace VBA	How to Find and Replace VBA Code in Microsoft Access
98	2 years	Access	Account Statements 3	Create Account Statements for Microsoft Access Check Register with Separate Credit & Debit, Part 3
99	2 years	Access	Blackout Times	How to Set Blackout Times for your Microsoft Access Database to Prevent User Logons
100	2 years	Access	Multiple Addresses 5	How to Store Multiple Addresses for a Customer in Microsoft Access, Part 5
101	2 years	Access	Export to Word 2	Export to Word, Part 2: Export Microsoft Access Reports to Word and Preserve Formatting, Lines, etc.
102	2 years	Access	AI Chef Helper 2	Integrate OpenAI (ChatGPT) for Recipe Ideas into the Microsoft Access Chef's Kitchen Helper, Part 2
103	2 years	Access	Who Had Item 2	How to Determine Who Had a Specific Item on Specific Date in Microsoft Access, Part 2
104	2 years	Access	Images Subfolder	How to Store Images in a Database Subfolder to Prevent Broken Links in Microsoft Access
105	2 years	Access	Table of Contents 3	How to Generate a Table of Contents or Index for a Microsoft Access Report, Part 3
106	2 years	Access	Easy Search Form 2	A Simple Multi-Field Search Form for Microsoft Access with Zero Programming, Part 2
107	2 years	Access	F to C	How to Convert Temperatures from Fahrenheit to Celsius and Vice Versa in Microsoft Access
108	2 years	Access	Initial Sort Order	Setting an Initial Sort Order for Records in a Table in Microsoft Access
109	2 years	Access	Delete Files	Microsoft Access Clean Up: Delete Temporary Files Automatically with the VBA Kill Command
110	2 years	Access	Colored Data Bars	Create Colored Data Bars in Microsoft Access Combining Data Bars with Color Scales
111	2 years	Access	Spawn Copies 2	How to Spawn Multiple Copies of the Same Database in Microsoft Access, Part 2
112	2 years	Access	Next Payment Date	Calculate Next Credit Card Payment or Reporting Dates in Microsoft Access
113	3 years	Access	Edge Browser 7	Using the New Edge Browser Control in Microsoft Access, Part 7: Navigation Events
114	3 years	Access	Next Leap Year	How to Calculate the Next Leap Year Following a Given Year in Microsoft Access VBA
115	3 years	Access	Custom MsgBox 8	Create a Custom Dynamic MsgBox in Microsoft Access Using VBA. Part 8: Format Properties
116	3 years	Access	Custom MsgBox	Create a Custom Dynamic MsgBox in Microsoft Access Using VBA. Part 1: Dialog Forms
117	3 years	Access	Force Change PW 3	Microsoft Access Security: Force Periodic Password Changes, Part 3
118	3 years	Access	Database Server 5	Transform Your Microsoft Access Back-End into a Makeshift Database Server - Part 5
119	3 years	Access	Cache Locally	How to Cache Data Locally to Improve Read-Only Form and Report Performance in Microsoft Access
120	3 years	Access	OpenAI Part 2	Unlocking the Potential of ChatGPT in Microsoft Access via OpenAI's API - Part 2
121	3 years	Access	Decision Tree 6	Building a Decision Tree Database in Microsoft Access. Part 6: Drag-and-Drop Images
122	3 years	Access	Shared Library	How to Create a Library File Containing Shared Subs and Functions in Microsoft Access
123	3 years	Access	Option Group	Using Option Groups in Microsoft Access: Procedure Tracking
124	3 years	Access	MoveSize	Controlling Opening Form Position in Microsoft Access with the MoveSize VBA Command
125	3 years	Access	For Each Loop	For Each Next Loops in Microsoft Access VBA. Loop Thru Controls on a Form.
126	3 years	Access	Arrays	Mastering Static Arrays in Microsoft Access VBA with a Dice Roll Simulator
127	3 years	Access	Do Until Loop	Do Until Loops in Microsoft Access VBA
128	3 years	Access	Task Priority	Optimizing Microsoft Access Performance: How to Adjust Task Priority in Windows
129	3 years	Access	List Open Programs	List All Open Programs on the PC with Microsoft Access VBA and the EnumWindows Function
130	3 years	Access	RunSQL v Execute	What's the Difference Between DoCmd.RunSQL and CurrentDb.Execute in Microsoft Access
131	3 years	Access	AutoSave	AutoSave Form Data at Timed Intervals in Microsoft Access
132	3 years	Access	Parse Lines	How to Parse Lines in a Textbox and Create Individual Records in Microsoft Access
133	3 years	Access	Count Records	How to Count the Number of Records in a Continuous Form with Criteria in Microsoft Access
134	3 years	Access	Import Text	Data Sharing Simplified: Importing Text into a Microsoft Access Table
135	3 years	Access	Export Text	Data Sharing Simplified: Exporting Tables or Queries as Text from Microsoft Access
136	3 years	Access	Cascade Delete	Proper Use of Cascade Deletes in Microsoft Access Databases
137	3 years	Access	Expense Tracker	How to Track Your Recurring Expenses in Microsoft Access
138	3 years	Access	Account Balances 9	How to Track Your Account Balances & Daily Transactions in Microsoft Access, Part 9
139	3 years	Access	Account Balances 8	How to Track Your Account Balances & Daily Transactions in Microsoft Access, Part 8
140	3 years	Access	Account Balances 7	How to Track Your Account Balances & Daily Transactions in Microsoft Access, Part 7
141	3 years	Access	Account Balances 6	How to Track Your Account Balances & Daily Transactions in Microsoft Access, Part 6
142	3 years	Access	Account Balances 4	How to Track Your Account Balances & Daily Transactions in Microsoft Access, Part 4
143	3 years	Access	Account Balances 3	How to Track Your Account Balances & Daily Transactions in Microsoft Access, Part 3
144	3 years	Access	Account Balances 2	How to Track Your Account Balances & Daily Transactions in Microsoft Access, Part 2
145	3 years	Access	Tab in Text Box	Add Tab Spacing Functionality to Text Boxes in Microsoft Access
146	3 years	Access	Different Page Headers	How to Create a Different Page Header for the First Page of a Microsoft Access Report
147	3 years	Access	Search As You Type	How to Create a Search-As-You-Type Box in Microsoft Access
148	3 years	Access	Two Spaces	How to Fix Records Where Users Typed Two Spaces After a Period in Microsoft Access
149	3 years	Access	Prevent Shutdown	How To Prevent Accidental Shutdown Of Your Microsoft Access Database
150	3 years	Access	TempVars	Using TempVars as a Powerful and Flexible Alternative to Variables in Microsoft Access
151	3 years	Access	Email Report	How to Use the SendObject Command to Email an Invoice or Other Report in Microsoft Access
152	3 years	Access	Calculator 7	How to Build an On-Screen Calculator in Microsoft Access VBA - Part 7
153	3 years	Access	User Level Security 3	User Level Security Part 3: Allow Users to Only View, Edit Records They Created in Microsoft Access
154	3 years	Access	Company Logo	How To Add A Company Logo To Your Main Menu In Microsoft Access And Link It To Your Website
155	3 years	Access	Quickly Run SQL	How to Quickly Execute SQL Commands Without Building a Query in Microsoft Access
156	3 years	Access	Print Multiple Invoices	How to Select Multiple Invoices to Print at One Time in Microsoft Access
157	3 years	Access	Double-Entry	Double-Entry Accounting in Microsoft Access
158	3 years	Excel	Timestamp	Timestamp Rows with Microsoft Excel VBA
159	3 years	Access	Next Business Day	How to Find the Next or Previous Business Day in Microsoft Access
160	3 years	Access	Requery in Place	How to Requery a Continuous Form in Microsoft Access Without the Focus Moving
161	3 years	Access	Database Launcher	Create a Database Launcher that Opens Other Microsoft Access Databases
162	3 years	Access	Available Credit	How to Show a Customer's Available Credit in Microsoft Access
163	3 years	Access	Multiple YN	How to Replace Multiple Yes/No Fields With Properly Relational Solution in Microsoft Access
164	3 years	Access	Max Value	How to Find the Maximum Value of Multiple Fields in the Same Record in Microsoft Access
165	3 years	Access	IP Addresses	Storing IP Addresses in Microsoft Access, Prevent Duplicates, Sort Numerically
166	3 years	Access	Group On Top	How to Make a Sorted Report in Microsoft Access with Specific Contacts Grouped On Top
167	3 years	Access	Images From Web	Display Images from the Web in your Microsoft Access Forms and Reports Using the Image Control
168	3 years	Access	Signatures	How to Collect Signatures on Forms in Microsoft Access with the InkPicture ActiveX Control
169	3 years	Access	Select in Subform	How to Select a Specific Record in a Subform in Microsoft Access
170	4 years	Access	Transaction Tables	Three Methods for Creating Tables to Track Transactions in Microsoft Access
171	4 years	Access	Future Dates Only	Always Move Dates Entered MM-DD to the Future in Microsoft Access. Appts, Followups, Payments, etc.
172	4 years	Access	Edit Mode	Prevent Accidental Edits and Deletions by Requiring Users to Go Into Edit Mode in Microsoft Access
173	4 years	Access	Date Buttons	Create Buttons to Change a Date Field in Microsoft Access. Move Up/Down Days or Weeks With One Click.
174	4 years	Access	Archive Records	Archiving Old Data in your Microsoft Access Database
175	4 years	Access	Merge Tables	How to Merge Tables From Multiple Sources Into One Master Database in Microsoft Access
176	4 years	Access	Zero Length	Allow Zero Length. The Difference Between Null and Zero Length String. Indicate No Middle Name.
177	4 years	Access	Multi Language	How to Display Microsoft Access Database Labels, Buttons, and Other Controls in Multiple Languages
178	4 years	Access	Age Demographics	Get a Count of Customers by Bracketed Age Demographic Group Ranges in Microsoft Access
179	4 years	Access	Check Spelling	How to Check Spelling in Microsoft Access Forms
180	4 years	Access	Online Images	Display Online Images & Web Pages in Your Microsoft Access Database Using the Web Browser Control
181	4 years	Access	Report Border	How to Draw a Border Around a Report Page in Microsoft Access with the Line Command
182	4 years	Access	InputBox	Use the InputBox Function in Microsoft Access VBA to Prompt for User Input, e.g. a Manager Password
183	4 years	Access	Resize Forms	Resize Microsoft Access Forms for Different Screen Sizes & Resolutions Using Anchoring. Zoom In/Out.
184	4 years	Access	Button Shortcut Keys	Use Shortcut Keys, Default, and Cancel Properties to Push Command Buttons in Microsoft Access
185	4 years	Access	Verify Credit Cards	How to Verify Credit Card Numbers and Expiration Dates in Microsoft Access
186	4 years	Access	New Hire Emails	How to Automatically Assign Email Addresses to New Hires in Microsoft Access
187	4 years	Access	Event Countdown	Build an Event Countdown Reminder Popup Form in Microsoft Access
188	4 years	Access	Transpose Data	Transpose Data in Excel and Properly Normalize it in Microsoft Access
189	4 years	Access	Limit Long Text	Set a Maximum Size Limit for Long Text (Memo) Fields in Microsoft Access
190	4 years	Access	Document Index	Building a Searchable Document Index in Microsoft Access (Word Docs, PDF Files, Text Files, etc.)
191	4 years	Access	Play Video	How to Play a Video or Audio File in a Microsoft Access Form Using the Windows Media Player Control
192	4 years	Access	Product Catalog	Creating a Product Catalog Report in Microsoft Access with Multiple Images (Pictures) Per Record
193	4 years	Access	Sales Chart	Create a Chart Showing Monthly Sales in Microsoft Access using Modern Charts, Forecast in Excel
194	4 years	Access	Rounding Errors	How to Fix Rounding Errors in Microsoft Access when Calculating Commissions, Sales Tax, etc.
195	4 years	Access	Project Budgets	Relationships with More than 2 Tables in Microsoft Access: Assign Orders to Projects for Budgeting
196	4 years	Access	Find Record Combo	Microsoft Access Search: Find a Record on My Form Based on the Value I Selected in my Combo Box
197	4 years	Access	Large Check Box	How to Create a Large, Custom-Sized Checkbox in Microsoft Access Forms & Reports
198	4 years	Access	Avg, Rank, Median	How to Calculate the Average, Rank, and Median Values of a Set of Records in Microsoft Access (DAvg, DMedian)
199	4 years	Access	Terms of Sale Text	How to Select Different Terms of Sale Text for Invoices Based on Type of Sale in Microsoft Access
200	4 years	Access	List Items Set Value	How To Set the Return Value in a Combo Box After Using a List Items Edit Form in Microsoft Access
201	4 years	Access	Add Anything	Any Anything You Want to a Record in a Microsoft Access Database. User Editable Supplemental Fields.
202	4 years	Access	Multi-Table Forms	Editing Records in Multi-Table Forms in Microsoft Access (Forms Based on Multiple Table Queries)
203	4 years	Access	Gift Certificates	Build a Database for Creating, Printing, and Tracking Gift Certificates in Microsoft Access
204	4 years	Access	Rounding	Rounding Numbers in Microsoft Access. Understanding Int, Fix, Round, and Banker's Rounding
205	4 years	Access	Order Discount	Add a Discount Percentage Rate to your Order Form and Invoice in Microsoft Access
206	4 years	Access	Multivalued Fields	Microsoft Access Multivalued Fields: What They Are, How to Use Them, and When You Should Avoid Them
207	4 years	Access	Export to Word	How to Export a Report from Microsoft Access to a Microsoft Word Document
208	4 years	Access	Database Title & Icon	Change the Microsoft Access Application Title & Icon on Windows Taskbar, Desktop, Forms, & Reports
209	4 years	Access	Filter Characters	How to Remove Unwanted Characters from a Microsoft Access Text Field with a Custom Filter Function
210	4 years	Access	Have Not Ordered	Design a Query in Microsoft Access Showing Customers Who Have Not Ordered a Specific Product
211	4 years	Access	Flashcards	How to Make a Flashcard Program in Microsoft Access. For Studying, Tests, Quizes, etc.
212	4 years	Access	Grouping	How to Use Sorting & Grouping Levels in Microsoft Access Reports. Create a Grouped Report, Summary
213	4 years	Access	Click to Sort	How to Make Click To Sort Column Headers in your Microsoft Access Continuous Forms
214	4 years	Access	File Sharing	Using Microsoft Access with File Sharing Services: Dropbox, OneDrive, Google Drive, etc.
215	4 years	Access	Too Many Tables	Building Too Many Tables to Store Similar Types of Data in Microsoft Access. Consolidate Your Data.
216	4 years	Access	Trusted Location	How to Set Up a Trusted Location (Folder) for your Microsoft Access Databases - Runtime Only Too!
217	4 years	Access	Validate Email	How to Validate an Email Address in Microsoft Access. Use an Input Mask or Validation Rule?
218	4 years	Access	Tasks	Design and Build a Task Management Database in Microsoft Access
219	4 years	Access	Play Sound	How to Make a Beep or Play a Sound with Microsoft Access. Play 3 Beeps in a Row.
220	4 years	Access	SQL with Access	TechHelp: Learn SQL in Microsoft Access
221	4 years	Access	Year to Date	How to Calculate Year-to-Date (YTD) and Month-to-Date (MTD) Sales Totals in Microsoft Access.
222	4 years	Access	Watermark	How to Insert a Watermark in your Microsoft Access Reports. Background Images. Pictures. Logos.
223	4 years	Access	Quick Access Toolbar	Customize Microsoft Access Quick Access Toolbar. Add Features. Open Forms, Reports. Run Macros.
224	4 years	Access	Normalizing Data	Normalizing Data in Microsoft Access Databases. What Normalization Means. How To Fix Bad Tables.
225	4 years	Access	Prevent Duplicates	Prevent Duplicate Products or Services in an Order in Microsoft Access with a Composite Key
226	4 years	Access	DatePart	Microsoft Access DatePart Function: Get Specified Part of a Date (Year, Quarter, Month, Week, etc.)
227	4 years	Access	Form Footer Totals	How to Calculate Line Item Totals and Form Footer Totals in Microsoft Access (Sum Function)
228	4 years	Access	Duplicate Record	Create a Duplicate of an Existing Record in Microsoft Access (Record Operations, Duplicate Record)
229	4 years	Access	Work Days	How to Calculate Work Days Between Two Dates in Microsoft Access. Similar to Excel NETWORKDAYS.
230	4 years	Access	Yes/No Fields	Using Microsoft Access Yes/No Fields, Check Boxes, Toggle Buttons, Combo, List Boxes, & Count Totals
231	4 years	Access	Next Appointment	How to Calculate the Next Recurring Appointment Date for a Regular Customer in Microsoft Access
232	4 years	Access	New Record on Top	How to Add New Record on the Top of a Continuous Form in Microsoft Access
233	4 years	Access	Zoom	Microsoft Access Zoom Dialog Box. Make Text Larger and Easier to Read with Shift-F2
234	4 years	Access	System Defaults	Get Default Values For Fields from a Table in your Microsoft Access Database. System Defaults Table.
235	4 years	Access	List Box Filter	How to Use a List Box to Filter Records in Microsoft Access
236	4 years	Access	Help Desk	How to Build a Microsoft Access Help Desk Trouble Ticket Database System
237	4 years	Access	Subforms	How to Create a Form with a Subform to Show Related Records in Microsoft Access
238	5 years	Access	Input Mask	How to Use an Input Mask in Microsoft Access. Telephone Numbers, ZIP Codes, Dates, More.
239	5 years	Access	Seasonal Address	How to Specify a Seasonal Mailing Address for Customers in a Microsoft Access Database
240	5 years	Excel	Conditional Formatting	Use Conditional Formatting to Highlight Items Over Budget in Microsoft Excel
241	5 years	Access	Purge Image Gallery	How to Purge the Image Gallery to Save Space in your Microsoft Access Databases + Compact & Repair
242	5 years	Access	Rich Text	How to Use Rich Text Formatting in your Microsoft Access Forms & Reports. Color, Fonts, Bold, More!
243	5 years	Access	Search Form 2.0	Microsoft Access Multi-Field Search Form 2.0 New and Improved Features!
244	5 years	Access	Import Multiline Cells	How to Import Data from Excel into Microsoft Access with Multiline Text (Cells with Line Breaks)
245	5 years	Access	Prevent Close	How to Prevent Users from Closing Forms in Microsoft Access Unless Specific Conditions Are Met
246	5 years	Access	Random Records	How to Select Random Records in Microsoft Access. Top X. Random Number Generator. Randomize.
247	5 years	Access	Currency Symbols	Using Multiple World Currency Symbols in Microsoft Access
248	5 years	Access	Control Tip Text	Use the Control Tip Text and Status Bar Text Properties to Show Help with a Control in Microsoft Access
249	5 years	Access	Link to Excel	How to Link Microsoft Access to a Microsoft Excel Workbook to Read Live Data without Importing
250	5 years	Access	Moving Average	Calculate a Moving Average in Microsoft Access (Rolling Average, Rolling Mean, Moving Mean)
251	5 years	Access	Surveys	Collect Survey Results with Google Forms and Import to Microsoft Access. Questionnaires. Polls.
252	5 years	Access	Data Collection	Microsoft Access Data Collection. How to Send Customers an Email to Update their Information.
253	5 years	Access	Open Report	Open a Report to Show a Specific Record in Microsoft Access. Display a Single Customer Record
254	5 years	Access	Pseudo Control	Create a Custom Pseudo Control in Microsoft Access. Arched Meter Using 100% Access Native Components
255	5 years	Access	Conditional Formatting	How to use Conditional Formatting in Microsoft Access to Color Code Tasks Due Now, Future, Past Due.
256	5 years	Access	Text Messages	How to Send SMS Text Messages to a Mobile Cell Phone from Microsoft Access
257	5 years	Access	Open Form	Open a Form to a Specific Record in Microsoft Access - Open Form to Specific Customer
258	5 years	Access	Date Only	How To Format Microsoft Access Date/Time Values to Show the Date Only Unless a Time is Specified
259	5 years	Access	Relink Tables	How to Relink Tables when your Back-End Microsoft Access Database File has been Moved
260	5 years	Access	Birthdays	Create a List of Birthdays in Microsoft Access using the Month, Day, and DateSerial Functions
261	5 years	Access	Groups	How to Put Customers Into Groups and Search for them in Microsoft Access Databases
262	5 years	Access	DMin	Using DMin in Microsoft Access to Find the First Order a Customer Placed (Earliest Date)
263	5 years	Access	Track Log On	Tracking User Logon & Logoff from Microsoft Access. Logging When Users Start and Exit the Database.
264	5 years	Access	Sliders	Using the Slider ActiveX Control in Microsoft Access
265	5 years	Access	Convert Currency	Currency Conversion in Microsoft Access. How to Switch from USD to EUR, CAD, AUD, etc. Exchange Rate
266	5 years	Access	Export HTML	Export Microsoft Access Reports as HTML Documents to View in Web Browser
267	5 years	Access	Letter Writer	Microsoft Access Letter Writer. Store, Print, Email Correspondence Without Using Word.
268	5 years	Access	Inventory	Microsoft Access Inventory Management System - Tracking Product Inventory, Stock Quantity on Hand
269	5 years	Access	Access on a Phone	How can I use my Microsoft Access Database on my Phone or Tablet? Android or iPhone/iPad
270	5 years	Access	Prevent Deletion	Preventing Record Deletion in Microsoft Access. Only Allow Delete if Customer is Inactive.
271	5 years	Access	Union Query	Combine Records from Multiple Tables or Queries Together Using a Union Query in Microsoft Access
272	5 years	Excel	Stock History	Microsoft Excel STOCKHISTORY Function - How to Get Stock History Data Automatically in Excel 365
273	5 years	Access	Navigation	Microsoft Access Switchboards and Navigation Forms. Why NOT To Use Them! Create Your Own Menu Forms
274	5 years	Access	Concatenation	Combine Two or More Fields Together Using Concatenation in Microsoft Access
275	5 years	Access	Hyperlinks	Hyperlink Fields in Microsoft Access and Why You Should NOT Use Them
276	5 years	Access	Intro to VBA	Introduction to Programming in Visual Basic for Applications (VBA) in Microsoft Access (Access VBA)
277	5 years	Access	Relational Combo	Relational Combo Boxes in Microsoft Access - Get the Values from Another Table or Query. Not In List Event
278	5 years	Access	Vehicle Maintenance	Building a Vehicle Maintenance Database in Microsoft Access. Log Service, Costs, Dates, Mileage.
279	5 years	Access	Cascading Combo Boxes	Microsoft Access Cascading Combo Boxes - One Combo Box Selection Filters a Second Combo Box
280	5 years	Access	Loan Payments	Tracking Loan Payments in Microsoft Access. Calculate Amount Paid, Due. Loan Management.
281	5 years	Access	Stock Portfolio	Viewing Your Stock Portfolio Data in Microsoft Access by Linking to an Excel Spreadsheet
282	5 years	Excel	Stock Portfolio	Track Your Stock Portfolio with Automatic Price Updates in Microsoft Excel 365
283	5 years	Access	Dashboards	Creating a Dashboard Form in Microsoft Access. Using DSum and Modern Charts to Display Sales Info
284	5 years	Access	Error Messages	How to Handle the Most Common Error Messages in Microsoft Access. Troubleshoot. Identify. Fix.
285	5 years	Access	Hide Inactive	Hide Inactive Customers from Combo Boxes in your Microsoft Access Forms - Hiding Inactive Records
286	5 years	Access	Event Enrollment	Event Enrollment in Microsoft Access (Also Students in Classes, People on Trips, Employee Training)
287	5 years	Access	Membership Database	Build a Microsoft Access Membership Database. Create Recurring Monthly Billing, Orders, Invoices.
288	5 years	Access	First Monday	How to Find the First Monday of the Month in Microsoft Access - DateSerial, WeekDay Functions
289	5 years	Access	Missing Months	Missing Months: Show All Months for a Yearly Sales Report in Microsoft Access Even if Missing Sales
290	5 years	Access	Center Vertically	How to Center Text Vertically in Labels and Text Boxes in Microsoft Access (Vertical Alignment)
291	5 years	Access	DCount	DCount in Microsoft Access: Count Records in a Table or Query. Show Order Count on Customer Form
292	5 years	Access	64-Bit Access	Make Your Microsoft Access Databases Safe with 32-Bit and 64-Bit Versions of Office, PtrSafe
293	5 years	Access	Relationships	Microsoft Access Relationships: Relating Multiple Tables, Relational Data, One-to-Many, Many-to-Many
294	5 years	Access	Splash Screen	How to Create a Startup Shortcut and Splash Screen to Hide the Microsoft Access Branding
295	5 years	Access	Command Buttons	Microsoft Access Buttons: Use Command Buttons to Navigate Thru Records or Open/Close Another Form
296	5 years	Access	AutoText	AutoText: Inserting Stock Reply Text Into Note / Memo / Long Text Fields in Microsoft Access
297	5 years	Access	String Functions	Use String Functions to Validate Part Numbers in Microsoft Access: Left, Right, Mid, Len, InStr
298	5 years	Access	Print Documents	How To Create, Manage, and Print Documents with Microsoft Access. Scan or Select from a Combo Box.
299	5 years	Access	Import Excel	Import Data into Microsoft Access from Microsoft Excel, CSV Files, and Fixed-Width Text Files
300	5 years	Access	Send Email	How to Send Email from Microsoft Access using Microsoft Outlook and Bypass the Security Warning
301	5 years	Access	Multi-Field Find	Use Find & Replace and Filter By Form to Search on Multiple Fields in your Microsoft Access Database
302	5 years	Access	Month-Over-Month	How to Compare Month-Over-Month (Previous Month and Same Month Last Year) Sales in Microsoft Access
303	5 years	Access	MsgBox	How to Use the MsgBox Command in Microsoft Access VBA to Create an Are You Sure? Prompt.
304	5 years	Access	Show/Hide Buttons	Show/Hide Buttons Based on Value of a Field in each Record in a Continuous Form in Microsoft Access
305	5 years	Access	Quote, Invoice, Receipt	Quotation, Invoice, Receipt - How to Change Orders Between Them in Microsoft Access Order Entry
306	5 years	Access	DLookup	How to use the DLookup Function to Look Up a Value from a Table or Query in Microsoft Access.
307	5 years	Access	Markup	How to Calculate Sale Price, Profit, Gross Margin, from Unit Cost and Markup in Microsoft Access
308	5 years	Access	Data Entry	Create a Data Entry Form in Microsoft Access OR Open an Existing Form in Data Entry Mode
309	5 years	Access	Split Commissions	Learn How to Split Commissions Between Employees or Sales Reps per Job in Microsoft Access
310	5 years	Access	Close Form	Close an Open Form in Microsoft Access using the DoCmd.Close VBA Command and an OnClose Event
311	5 years	Access	Combining Names	Combining Names of Couples in Greetings in Microsoft Access with Same or Different Last Names.
312	5 years	Access	Volume	Calculate Volume in Microsoft Access - Create a Cubic Measurement Calculator. Good for Landscaping.
313	5 years	Access	Age, Part 2	Calculating Age Part 2: Check the Accuracy of Calculations in my Original Microsoft Access Age Video
314	5 years	Excel	Text to Columns	Microsoft Excel Text to Columns: Split a Comma-Separated List of Text into Multiple Cells / Columns
315	5 years	Access	Accounts Receivable	Add Accounts Receivable to your Microsoft Access Order Entry & Invoicing Database. Who Owes Money?
316	5 years	Access	Time & Billing	Microsoft Access Time & Billing Database - Invoice Your Customers For Time Spent. Time Tracking.
317	5 years	Access	Multi-Table Update	Microsoft Access Update Query: Values from Another Table to Normalize a Field. Plus add World Flags!
318	5 years	Access	Profit & COGS	Calculating Net Profit and Cost of Goods Sold (COGS) in your Microsoft Access Order Entry Database
319	5 years	Access	Record Locks	Record Locking: Preventing Multiple Users from Editing the Same Data in Microsoft Access
320	5 years	Access	Customer Pricing	Customer-Specific Product Pricing for your Microsoft Access Order Entry Invoicing System
321	5 years	Access	Backup Access	Backup Your Microsoft Access Databases - Proper Steps for Backing Up Your ACCDB Database Files
322	5 years	Access	VLOOKUP in Access	Microsoft Access Equivalent of an Excel VLOOKUP Function with Approximate Match using DLookup, DMax
323	5 years	Access	Value From a Form	Get a Value from an Open Form in Microsoft Access using Forms!FormName!FieldName Notation
324	5 years	Access	Can Grow, Shrink	Learn How to Use the Can Grow & Can Shrink Properties in Microsoft Access Reports
325	5 years	Access	Change Case	Change Between UPPER, lower, and Proper Case in your Microsoft Access Databases
326	5 years	Access	Default Value	How to Set a Field's Default Value in Microsoft Access. Default City, State, Zip, Today's Date.
327	5 years	Access	Database Password	How to Set and Remove a Password in Your Microsoft Access Databases, Encrypt with Password
328	5 years	Access	Stored or Calculated	When to Use a Stored Value Instead of a Calculated Value in Microsoft Access
329	5 years	Access	QR Codes	How to Display QR Codes in your Microsoft Access Database Forms
330	5 years	Access	Barcode Printing	Printing Custom Barcode Labels from your Microsoft Access Database
331	5 years	Access	Barcode Scanning	Scanning Barcodes (UPC, ISBN, EAN, etc.) to Lookup Products in your Microsoft Access Database
332	5 years	Access	Timesheets	Timesheets in Microsoft Access: Calculating Total Hours Worked for Employees or Customer Billing
333	5 years	Access	Widows & Orphans	Widow / Orphan Protection for Records in Microsoft Access - Prevent Data With Missing Relationships
334	5 years	Access	Access Runtime	Distributing Your Database with the Free Microsoft Access Runtime Edition Developer Extensions
335	5 years	Access	Table-Level Validation	How to use a Table-Level Validation Rule to Check Multiple Fields in a Record in Microsoft Access
336	5 years	Access	Images	Display Images in your Microsoft Access Forms and Reports Without Storing Them in the Database!
337	5 years	Access	Not Updateable	Why Does My Form or Query Say This Recordset is not updateable in Microsoft Access?
338	5 years	Access	Filter Records	Filter Microsoft Access Form Data to Search for Records Quickly and Easily
339	5 years	Access	Favorite Customers	Display Your Favorite Customers in a List Box on Your Main Menu in Microsoft Access
340	5 years	Access	Report Listbox	Use a List Box or Combo Box to Display Specific Reports to Print in your Microsoft Access Database
341	5 years	Access	On Double Click	Using the On Double Click Event in Microsoft Access to Open a Customer Record or Increment a Date
342	5 years	Access	On Click	Using the On Click Event in Microsoft Access to Increment a Date Field by One Day. OnClick. Label.
343	5 years	Access	DMax	Using the DMax Function in Microsoft Access to Return the Largest Value, Most Recent Date, DMin
344	5 years	Access	Flashing Text	Create Flashing Text in Microsoft Access Forms Using a Timer Event - Blinking Red/White Text Box
345	5 years	Access	Many-to-Many	Using Many-to-Many Relationships in Microsoft Access to Track Employee Certifications, Courses, etc.
346	5 years	Access	IIF Function	Immediate IF in Microsoft Access - If/Then in a Single Function - Conditional
347	5 years	Access	Appointments	Microsoft Access Appointment Database - Scheduling, Calendar, Tasks, To-Do Items, Planner
348	5 years	Access	Aggregate Query	Aggregate Query in Microsoft Access to Show Customer Count by State. Totals. Group By.
349	5 years	Access	Dymo Labels	Printing to a Dymo LabelWriter 450 in Microsoft Access - Print One Mailing Label to Specific Printer
350	5 years	Access	Arrange Tabular	Use the Tabular Layout on the Arrange Menu in Microsoft Access to Quickly Arrange Form Fields
351	5 years	Access	Calculated Fields	Calculated Fields in Microsoft Access - How to Perform Calculations in Queries and Form Footer Totals
352	5 years	Access	Suppress Warnings	Suppress Warning Messages for Microsoft Access Action Queries
353	5 years	Access	Caps Lock On Off	Turn Caps Lock, Num Lock, and Scroll Lock ON or OFF with Microsoft Access VBA using SendKeys
354	5 years	Access	Help System	Build a Context-Sensitive Help System For Your Microsoft Access Databases
355	5 years	Access	Form Auto Resize	How to Use the AutoSize Form Property to make your Microsoft Access forms stay exactly the size you want when you save them.
356	5 years	Access	Enter Parameter Value	What Does the Enter Parameter Value Error in Microsoft Access mean?
357	5 years	Access	Reminder Popup Date	How To Create Popup Reminders Based On Dates With Timer Events And Snooze Button in Microsoft Access
358	5 years	Access	Order By, Filter On Load	Microsoft Access Order By On Load, Filter On Load Properties
359	5 years	Access	Reminder Popup	Timer Event for Reminders. Display a Popup in Microsoft Access
360	5 years	Access	Separate Username in Email	How To Split Username From Domain in an Email Address Using Queries and String Functions in Microsoft Access
361	5 years	Access	Last Name, First	How To Display Last Name First Name Together in Combo Boxes with Company Names in Microsoft Access
362	5 years	Access	Invoicing	Order Entry System with Invoice Report Template for Microsoft Access
363	5 years	Access	Switch Function	Use the Switch Function as an Alternative to Nested IIFs
364	5 years	Access	Select Multiple Records	How To Select Multiple Customer Records For Printing Custom Reports On Demand in Microsoft Access
365	5 years	Access	How to Handle BCE Dates	How To Store and Display BCE and CE Historical Dates Outside Normal Range in Microsoft Access
366	5 years	Access	Move Up Down Using Keyboard	How To Move Up and Down Between Records Using Arrow Keys in Continuous Forms in Microsoft Access
367	5 years	Access	Conditional Formatting Null	Use an expression to use conditional formatting to highlight Null values in Microsoft Access
368	5 years	Access	Manage Rental Inventory	How To Automatically Check In Rental Inventory Items After Due Date and Track Status in Microsoft Access
369	5 years	Access	Automatic Record Numbering	How To Automatically Number and Renumber Records Sequentially When Adding or Deleting in Microsoft Access
370	5 years	Access	Fast Form Update	How To Quickly Assign Technicians and Update Records Using Buttons in Continuous Forms in Microsoft Access
371	6 years	Access	Convert Query SQL to VBA	How To Convert Query SQL to VBA Code With Line Breaks, Quotes, and Copy to Clipboard in Microsoft Access
372	6 years	Access	Alphanumeric Grouping	How To Group Records Alphanumerically With The DMax Function And Find Page Numbers in Microsoft Access
373	6 years	Access	Year End Sales Report	How To Create Automated Year End Sales Reports With Monthly Totals and Aggregate Queries in Microsoft Access
374	6 years	Access	Import New, Changed Records	Import New and Changed Records. Update Pricing from Vendor.
375	6 years	Access	AutoTab to Next Field	AutoTab to Automatically Move to Next Field when Finished Typing
376	6 years	Access	15-Minute Increments	How To Force 15-Minute Increments for Time Card Data Entry Using Validation Rules in Microsoft Access
377	6 years	Access	Outer Joins	Missing Records! Show All Records with Outer Join
378	6 years	Access	Progress Bar Form Completion	How To Show Form Completion Progress With a Progress Bar and Percent Complete in Microsoft Access
379	6 years	Access	Group Sales By Month	How To Group and Sum Sales by Month and Year Using Aggregate Queries in Microsoft Access
380	6 years	Access	Percent of Total in Charts	How To Display Percentages in Queries and Modern Pie Charts Using Modern Charts in Microsoft Access
381	6 years	Access	Checklists	How To Create Daily Safety Checklist With Auto Date Time and Archive History in Microsoft Access
382	6 years	Access	Add Records	How To Automatically Add Followup Appointment Records With Specific Dates Using VBA in Microsoft Access
383	6 years	Access	Highlight Duplicates	Highlight Duplicate Values with Conditional Formatting in Microsoft Access
384	6 years	Access	Chef's Kitchen Helper	How To Find Possible Recipes Based On Available Ingredients and Inventory in Microsoft Access
385	6 years	Access	Continuous Forms	Continuous Forms in Microsoft Access. Click to Open Specific Product.
386	6 years	Access	Simple Security	Simple Security for Microsoft Access Databases. Create ACCDE File.
387	6 years	Access	Access v Excel	Microsoft Access v Microsoft Excel: Which is Better? When to Use Each.
388	6 years	Access	Wildcard Search & Like	How To Use Wildcard Searches with the LIKE Keyword To Find Email Domains in Microsoft Access Queries
389	6 years	Access	Tab Control	How to Use a Tab Control to Group Other Controls Together in Microsoft Access
390	6 years	Access	Hide Page Footer on First Page	How To Hide the Page Footer on the First Printed Page of a Report in Microsoft Access Reports
391	6 years	Access	Search Button	Single-Field Search Button in Microsoft Access
392	6 years	Access	DateAdd	Use the DateAdd Function to Add Whole Calendar Months to Date Values in Microsoft Access
393	6 years	Access	Calculate Age	How to Properly Calculate Age from Date of Birth in Microsoft Access
394	6 years	Access	Blank Template	Microsoft Access Blank Database Template
395	6 years	Access	Don't Delete Data	Don't delete records in Microsoft Access. Mark them inactive instead. Soft delete.
396	6 years	Access	Check Register	Microsoft Access Check Register Database
397	6 years	Access	Progress Bar	How To Display a Custom Progress Bar With or Without ActiveX Controls in Microsoft Access Using VBA
398	6 years	Access	Daylight Saving Time	Daylight Saving Time UTC in Microsoft Access
399	6 years	Access	Employee Time Clock	How To Create an Employee Time Clock Form With Clock In and Out Buttons Using VBA in Microsoft Access
400	6 years	Access	Between Wrong	Be Careful Searching Dates. Between May Return Unexpected Results.
401	6 years	Access	Total Time Spent	Calculate Total Time Spent on a Job with DateDiff
402	6 years	Access	Map Overlay	Overlay Data on a Map or Image in Microsoft Access
403	6 years	Access	Helper Data	Consolidate Tables with Helper Data in Microsoft Access
404	6 years	Access	Multiple Phone Numbers	Store Multiple Phone Numbers in Microsoft Access
405	6 years	Access	Create Function	Create Your Own Function in Microsoft Access
406	6 years	Access	Update Queries	How to Create Update Queries in Microsoft Access
407	6 years	Word	Insert Horizontal Lines	How To Add Horizontal Lines, Borders, and Signature Lines in Microsoft Word Documents Easily
408	6 years	Access	Split Your Database	How and Why to Split Your Microsoft Access Database
409	6 years	Access	Nested Subforms	How To Create Multiple Nested Continuous Subforms for Departments Courses Classes in Microsoft Access
410	6 years	Word	Add Perspective to Images	How To Add Perspective And 3D Rotation Effects To Images Using Format Picture In Microsoft Word
411	6 years	Word	Mirror Margins	How To Set Up Mirror Margins, Custom Margins, and Gutter Space for Binding in Microsoft Word
412	6 years	Access	Aggregate Calculations	How To Calculate Values Like Date Differences Using Aggregate Query Results in Microsoft Access
413	6 years	Access	Open Database Exclusively	Open Database Exclusively in Microsoft Access
414	6 years	Access	Export Reports to PDF	How To Export Reports to PDF with One Click Using VBA in Microsoft Access for Easy Emailing
415	6 years	Access	Command Line Parameters	How To Use Command Line Parameters, Switches, and Arguments When Opening a Database in Microsoft Access
416	6 years	Access	Track Changes	Track Changes to Data - Audit Trail - Log User Activity - Record Edits
417	6 years	Access	Custom Form Backgrounds	How To Create Custom Form Backgrounds and Change Title Bar Color and Buttons in Microsoft Access
418	6 years	Access	Aesthetics	Form Design Aesthetics Professional Looking Controls, Buttons
419	6 years	Access	Compact & Repair	How To Compact and Repair Your Database Efficiently and Prevent Corruption in Microsoft Access
420	6 years	Access	Query Criteria	How To Use Criteria In Queries To Filter Records By State Or Date In Microsoft Access
421	6 years	Access	List Box with Format and Color?	How To Add Formatting and Color to List Boxes and Create Color-Coded Lists in Microsoft Access
422	6 years	Access	Tab Stop, Order, Cycle	Microsoft Access Tab Stop, Tab Order, Cycle Records on a Form
423	6 years	Access	Map Location	How To Open Google Maps to Any Location Stored in Your Microsoft Access Database with One Click
424	6 years	Access	Self Join Relationships	Build a Genealogy Database to Track Family Ancestry. Self-Join Relationships.
425	6 years	Access	ByRef v ByVal	ByRef v ByVal in VBA. Creating an Increment Operator.
426	6 years	Access	Count Characters	How To Count Specific Characters and Lines in a String With a For Next Loop in Microsoft Access VBA
427	6 years	Word	Double Spacing	How To Double Space Documents, Show Paragraph Marks, And Select All Text in Microsoft Word
428	6 years	Access	NZ Function	How To Use the NZ Function to Convert Null Values to Zero or Default Values in Microsoft Access
429	6 years	Access	AfterUpdate & DLookup	AfterUpdate Event & DLookup - Look up Values from Table to a Form
430	6 years	Access	Turn Off Warnings	How To Turn Off Action Query Warning Messages for Update, Delete, Append Queries in Microsoft Access
431	6 years	Access	Maximize Application Window	How To Maximize or Restore the Application Window Automatically on Startup in Microsoft Access
432	6 years	Access	Subform in a Continuous Form	How To Display a Subform Inside a Continuous Form and Sync Record Lists in Microsoft Access
433	6 years	Access	Odd or Even	How To Determine If a Number Is Odd or Even Using the Mod Operator and IIF Function in Microsoft Access
434	6 years	Access	Sync Remote Database	How To Sync Two Separate Databases Without Internet Access and Avoid Key Collisions in Microsoft Access
435	6 years	Access	Sequential Numbers	How To Create Custom Sequential Order Numbers Without Gaps for Reporting Purposes in Microsoft Access
436	6 years	Access	Restore Deleted AutoNumber	How To Restore Deleted AutoNumber IDs and Recover Lost Records Safely in Microsoft Access Databases
437	6 years	Access	Custom Sort Order	How To Use a Custom Sort Order for Forms and Reports to Display Records in Microsoft Access
438	6 years	Access	Disallow Editing Data	How To Allow Adding But Prevent Editing Or Deleting Existing Records In Microsoft Access Forms
439	6 years	Access	Select Primary Customer	How To Indicate the Primary Person for Accounts or Families Using a Yes No Field in Microsoft Access
440	6 years	Access	On Current	On Current Event in Microsoft Access