Juan Soto

About Juan Soto

Juan Soto is the President of IT Impact Inc., a Microsoft Access MVP for 14 consecutive years, and a database and AI consultant with over 32 years of experience. He specializes in Microsoft Access with SQL Server backends, helping businesses of all sizes design secure, stable, and scalable data environments. As AI tools continue to reshape the business landscape, Juan has expanded his expertise to help small businesses harness the power of artificial intelligence — from practical automation to smarter decision-making — making cutting-edge technology accessible without the enterprise price tag. A recognized voice in the Microsoft Access and AI communities, Juan is a frequent speaker at user groups and tech conferences nationwide and a sought-after podcast guest. He enjoys sharing practical insights on database architecture, AI integration, and modern business solutions with audiences of all technical levels. If you’d like Juan to speak at your next event, user group, or podcast, you can reach him here.
jsoto@itimpact.com

Create Delete and Update Audit Tables in Microsoft SQL Server

Create Delete and Update Audit Tables in Microsoft SQL Server This is a modification to an earlier tip I wrote, whereas this code will only record delete changes, my earlier article will record delete and update changes to the data. I found code online by Brett Kaiser and I modified it for my purpos [...]

2021-06-11T07:45:45-05:00June 15th, 2015|

9 Microsoft Access Developer Interview Questions

9 Microsoft Access Developer Interview Questions A few weeks back, I created a post called 9 Interview questions to ask Microsoft Access Developers, and I challenged my loyal readers to try and answer them. Below are the questions and answers. 1. What is a collection? Answer: A group of objects held [...]

2021-06-11T07:47:35-05:00April 24th, 2015|

9 Interview Questions to Ask Microsoft Access Developers

Recently we've been interviewing a lot of Microsoft Access Developers, we don't like to ask your run-of-the-mill questions like, ''Tell me your three strengths and three weaknesses,'' or ''What's your dream job?'' Aside from our vacancy actually being your dream job, we're less interested in the flu [...]

2022-01-07T08:47:03-06:00April 7th, 2015|

Microsoft Access Seminars in Denmark and Spain

Microsoft Access Seminars in Denmark and Spain [EN] We are excited to announce two big events that we are honored to present to you all. This summer Juan Soto, Access MVP and President of IT Impact, will be touring Europe and presenting a one-day MS Access Seminar, Discover the Power of Your Data. I [...]

2021-06-11T07:50:59-05:00March 24th, 2015|

How to Open Your MS Access Application Like a Custom Application

How to Open Your MS Access Application Like a Custom Application Level of Difficulty Easy Applies to MS Access Versions Access 2000+ Overview: Sometimes, when we create a full blown application, utility, or departmental tool, we only want to see the opening form pop up on the screen and leave the fu [...]

2021-06-11T07:54:05-05:00February 4th, 2015|

SQL Server Update Breaks Microsoft Access Application

SQL Server Update Breaks Microsoft Access Application UPDATE 12/3/14: Please visit Darren's blog for the latest on this issue, than come back here to see some solutions to this problem. You can visit Darren's blog here. My inbox has been flooded by reports around the world of Access suddenly being s [...]

2021-06-11T07:55:32-05:00November 21st, 2014|

Microsoft Access User Group Webinars for November

Microsoft Access User Group Webinars for November We are happy to announce not one but four Access User Group (AUG) meetings this month. This is a wonderful opportunity open to novice and professional developers to learn new tricks. Each webinar is free and you don’t have to be a member to participa [...]

2025-05-21T08:33:39-05:00November 6th, 2014|

We’re Hiring: Senior Microsoft Access Consultant

We’re Hiring: Senior Microsoft Access Consultant IT Impact Inc. is a world leader in developing Microsoft Access solutions, and we are looking for a Senior Microsoft Access Consultant. Notice this is a consulting position and not a developer position. We need someone who understands business, who ca [...]

2021-06-11T07:56:55-05:00October 14th, 2014|

Chicago Event: Stored Procedures in MS Access

Juan Soto will be presenting next week at the Chicago Access User Group (CAUG). This is a great opportunity to network with other software developers and Access users, as well as a perfect venue to share tips, techniques, and ideas. Join CAUG’s kick-off meeting with Juan Soto, Microsoft Access MVP, [...]

2021-11-23T07:29:55-06:00September 18th, 2014|
Go to Top