Too Long; Didn't Watch Tutorials
Too Long; Didn't Watch Tutorials
  • Видео 71
  • Просмотров 201 368
Quick and Scalable Approaches for Automating MS Access Database Backups
In this tutorial, I’ll show you how to create an automated backup system for your MS Access database using a simple batch file and VBA. Learn how to ensure your important data is securely backed up to a subfolder with a timestamp, all while keeping your workflow efficient. Whether you're a beginner or an experienced Access user, this step-by-step guide will walk you through the entire process. I will show you a manual process just running the batch file or triggering on a MS Access button, semi-automate when the form loads, or fully automate each morning using the Task Scheduler in MS Windows. There are a bunch of ways to do this, these are just a few approaches I use. Let me know if you ...
Просмотров: 132

Видео

Start Data Analysis with PowerShell: The Windows Tool You Already Have
Просмотров 5821 день назад
In this video, I walk you through a comprehensive PowerShell script that performs various statistical analyses on a dataset. PowerShell is a scripting language that comes included with Windows, but can also be used on Mac or Linux computers. The script discussed in the video reads data from a CSV file and provides insights into age and race distributions, including: (1) Importing the CSV Datase...
Automatically Updating your Excel Spreadsheet with the latest Olympic Medal Stats (No Coding)
Просмотров 1,2 тыс.Месяц назад
In this video, you'll learn how to seamlessly integrate real-time Olympic data into your Excel spreadsheet. Discover the step-by-step process to set up an automated system that keeps your data current with the latest results and statistics from the Olympic games. Don't know how to code? Don't worry - in this special edition video, I won't be using any code! We will utilize Microsoft Excel's web...
How to Add Interactive Popups to Individual Answer Options in Qualtrics
Просмотров 147Месяц назад
Enhance your Qualtrics survey by adding interactive popups to individual answer options! In this tutorial, I will show you how to create both buttons and hyperlinks that trigger informative popup messages for each specific answer choice. This will work with most, if not all survey answer types (including matrix questions). This simple yet powerful technique can provide additional information or...
How to Automate Outlook Appointment Deletion with Excel VBA: Step-by-Step Tutorial
Просмотров 57Месяц назад
In this video, I’ll show you how to automate the deletion of Outlook appointments using Excel VBA! Do you want to delete all appointments in a certain time range? Maybe just appointments with certain characteristics such as upcoming lunches? I got you covered! Whether you're managing a busy schedule or handling multiple appointments, this tutorial will help you streamline the process and save t...
How to Automate MS Excel Save Log Creation in 5 Minutes
Просмотров 702 месяца назад
In this tutorial, you'll learn how to create an audit tracking log in Excel using VBA (Visual Basic for Applications) every time your spreadsheet is saved. This step-by-step guide will show you how to automatically track who saved your Excel file and when they did. Perfect for office settings and anyone looking to enhance their data auditing capabilities! What You'll Learn: - How to set up VBA ...
Add Sound Clips to your Microsoft Access Database (Sound Effects, Music)
Просмотров 1852 месяца назад
In this video, I will walk you through the step-by-step process of adding audio clips to enhance your Microsoft Access database applications. Whether you're looking to add sound effects, voice prompts, or music, this tutorial will guide you through the necessary steps to make your MS Access projects more interactive and engaging. We are going to work with WAV files since that is the preferred f...
How to Use the OpenFDA API with Python & R (Data Science Tutorial)
Просмотров 2173 месяца назад
In this tutorial, I will help you get started with learning how to extract data from the OpenFDA API using both Python and R. We will work with medication adverse event data, which is among the easiest of the FDA datasets to use as a firstimer. Whether you're a beginner or an experienced coder, this guide will help you understand how to make API requests, handle the response, and process the da...
Automating PubMed Article and Manuscript Data Retrieval with Python Using the NCBI API
Просмотров 7513 месяца назад
This brief tutorial will dive into automating the retrieval of PubMed data using Python - that's right, add as many criteria as you want and create tons of query search combos. I will guide you through the entire process, from setting up the Entrez API (which in our case, just means providing an email in our code), setting up search lists, fetching article data, and converting our data into a u...
Qualtrics Survey JavaScript Popups Part 2: Adding Bolded or Underlined Text + Images!
Просмотров 3384 месяца назад
Welcome back to the Qualtrics survey JavaScript Popup Series! In this highly anticipated sequel, we're taking things up a notch by introducing you to the power of Bootstrap modal popups. Many of you really liked the JavaScript popups I showed you in late 2022, but some of you wished it were possible to implement bolded or underlined text. Others asked if it was possible to embed a picture in th...
Creating Virtual Patients: How to Simulate & Synthesize a Healthcare Patient Cohort Dataset in R
Просмотров 724 месяца назад
Thanks for checking out this video where we merge the realms of synthetic and simulated data to craft comprehensive patient datasets using R. This tutorial is designed for enthusiasts at the intersection of healthcare, data science, and privacy, offering a step-by-step guide to the principles and practices of generating synthetic patient data for simulation purposes. In our case, we are creatin...
Opening a Form in Microsoft Access Based on Specific Values in a Report
Просмотров 3615 месяцев назад
This detailed guide is crafted for professionals and new users alike aiming to streamline their database processes. From beginner basics to advanced strategies, this video provides the insights you need to master form filtering and enhance your reporting capabilities. Have a list of people or unique values you have in a datasheet style report and just want to click a button to open that specifi...
Error-Free Emails in MS Outlook: Tools & Tricks to Eliminate Typos, Mistakes and Personal Bad Habits
Просмотров 1365 месяцев назад
Struggling with typos in your Outlook emails? You're not alone. Typos can make a bad impression, lead to misunderstandings, or even change the meaning of your message. But fear not! This comprehensive guide is here to help you navigate the world of error-free emailing within Microsoft Outlook. In this video, we delve into powerful strategies and tools designed to minimize and eliminate typos an...
Automate Microsoft Excel: Import Massive CSVs into Separate Sheets with VBA
Просмотров 976 месяцев назад
Are you dealing with gigantic CSV files and need a smart way to organize and analyze your data in Excel? Look no further! In this step-by-step tutorial, we dive into the world of Excel VBA to show you how to automatically import data from large CSV files into Excel, dividing them into manageable chunks of 1,000,000 (or less) rows each, placed neatly into their own tabs. Whether you're a data an...
Embedding External Sound Clips & Videos from Websites into Qualtrics Surveys: A Step-by-Step Guide
Просмотров 9126 месяцев назад
Embedding External Sound Clips & Videos from Websites into Qualtrics Surveys: A Step-by-Step Guide
A Demonstration of Using MS Access & VBA to Link to or Scrape Data from the Web - Wikipedia Example
Просмотров 1,1 тыс.7 месяцев назад
A Demonstration of Using MS Access & VBA to Link to or Scrape Data from the Web - Wikipedia Example
Creating a Detailed Dataset of Trials from Clinicaltrials.gov using Python (Beginner Friendly)
Просмотров 1,2 тыс.7 месяцев назад
Creating a Detailed Dataset of Trials from Clinicaltrials.gov using Python (Beginner Friendly)
Cleaning the Sheets: An Approach to Automatically Fix Misaligned Data in MS Excel with VBA and Regex
Просмотров 1637 месяцев назад
Cleaning the Sheets: An Approach to Automatically Fix Misaligned Data in MS Excel with VBA and Regex
Exploring ChatGPT's Ability to Decode, Analyze, and Output Data from Scanned Questionnaires
Просмотров 1058 месяцев назад
Exploring ChatGPT's Ability to Decode, Analyze, and Output Data from Scanned Questionnaires
Mastering Custom ID Creation in MS Access: A Dual Approach with & without VBA code
Просмотров 1,3 тыс.8 месяцев назад
Mastering Custom ID Creation in MS Access: A Dual Approach with & without VBA code
How to Create a Variable to Track User Clicks on URL Links in Qualtrics Surveys
Просмотров 9159 месяцев назад
How to Create a Variable to Track User Clicks on URL Links in Qualtrics Surveys
Analyze Interview Transcripts for Individual Speaker Grade Levels w/ Python
Просмотров 4809 месяцев назад
Analyze Interview Transcripts for Individual Speaker Grade Levels w/ Python
Create a Script to Change Excel Macro Settings Outside of MS Office
Просмотров 7229 месяцев назад
Create a Script to Change Excel Macro Settings Outside of MS Office
MS Access Data Visualizations You Thought Weren't Possible: Plotly Bubble Charts
Просмотров 43210 месяцев назад
MS Access Data Visualizations You Thought Weren't Possible: Plotly Bubble Charts
Bridging the Generations: ChatGPT Meets Fortran - AI + the Grandfather of Programming Languages
Просмотров 33210 месяцев назад
Bridging the Generations: ChatGPT Meets Fortran - AI the Grandfather of Programming Languages
Embedding Websites in your Qualtrics Survey w/ Iframes and Link to Frequently Changing/Updated Data
Просмотров 1,8 тыс.10 месяцев назад
Embedding Websites in your Qualtrics Survey w/ Iframes and Link to Frequently Changing/Updated Data
Use Python to ghostwrite/simulate typing any text in any application for as long as you want
Просмотров 26611 месяцев назад
Use Python to ghostwrite/simulate typing any text in any application for as long as you want
Geocoding in Python Made Easy: Plot map data using GeoPy - Even if you don't have Latitude/Longitude
Просмотров 1,7 тыс.11 месяцев назад
Geocoding in Python Made Easy: Plot map data using GeoPy - Even if you don't have Latitude/Longitude
MS Access Update Queries - Make data changes in bulk/mass to your table and save loads of time!
Просмотров 935Год назад
MS Access Update Queries - Make data changes in bulk/mass to your table and save loads of time!
Mastering Text Data Management in MS Access: 5 of the Most Essential Functions + Bonus Macro!
Просмотров 596Год назад
Mastering Text Data Management in MS Access: 5 of the Most Essential Functions Bonus Macro!