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

Optimizing Access with SQL Server Video

I've been traveling the USA for the better part of two years talking about how to rev up Access with SQL Server, after hundreds of attendees, many miles traveled and more road meals than I care to remember, I finally got around to recording it. Here it is and PLEASE leave a comment below! https://yo [...]

2025-04-26T03:06:55-05:00July 31st, 2012|

Check out my Podcast from Down Under

Had a great chat with Robert Crane and the Computer Information Agency about starting an Access practice, when Access is a great tool for business and how to obtain new clients. You can hear the podcast here: Let me know your thoughts in the comment section below!   [...]

2021-06-10T04:33:00-05:00July 24th, 2012|

Recording of Access Kung-FU now available

If you did not make it to our live session you can do the next best thing, see the recording below: [vimeo]https://vimeo.com/45720384[/vimeo] If you attended the session please leave a comment below. [...]

2012-07-14T22:00:01-05:00July 14th, 2012|

Reminder: Tomorrow morning at 8 AM CST Access Kung-Fu!

Come join us tomorrow morning at 8 AM Central Daylight Savings Time, (GMT-5), for a great session on high level Access topics! To join, just go to www.join.me/accessexperts. You will need to either use the computer speakers and type your question or click on the phone icon at the top of the toolbar. [...]

2012-07-13T03:37:52-05:00July 13th, 2012|

Live on July 13th, Access Kung-FU, mastering Access session

My Access Kung-Fu is strong, join me on July 13th as I demo advanced topics I previously held this session at night, but that made it almost impossible for Europe or Asia to participate. Now you can join me this Friday at 8 AM for a two hour world wide session. Here is what you will learn: Master th [...]

2012-07-09T20:46:04-05:00July 9th, 2012|

Microsoft Surface: Get ready for Access on a tablet

Microsoft last Monday held a press conference to demo a new tablet called Surface, you can catch the 90 second summary here. One Killer Feature missing on Tablets: Corporate Databases There is no way to enter, store and upload data to corporate databases using existing tablet technologies without us [...]

2025-07-21T17:51:02-05:00June 20th, 2012|

If your client sees you as a cost center you already lost…

Access can do great things, on a short time frame and with a smaller budget than other technologies. If your client can't see the benefits of your work it's your responsibility to step up and show them how your work output should be considered as part of a profit center. Here's how: -- Perform a pay [...]

2012-05-15T21:00:39-05:00May 15th, 2012|

Subquery and the Scalar Query

Today's guest post come's from Mark Davis, a Access MVP. You can learn more about him at http://www.linkedin.com/in/markgerarddavis The concept of a subquery itself is fairly straightforward: have a query within a query. However, there are various applications of the subquery. Most frequently, a sub [...]

2012-05-07T09:13:39-05:00May 7th, 2012|

PAUG Live Blogging

This week I'm at Paug's Access conference in gorgeous Silverfalls, Oregon. I'll be live blogging here so come back here often for frequent updates over the weekend. It's sold out - again Yet again this year's conference was sold out, not because there's a ton of people here but there is a low thresh [...]

2012-05-07T01:09:22-05:00May 7th, 2012|

Using Recursion in your Access database

Today's guest post come's from Mark Davis, a Access MVP. You can learn more about him at http://www.linkedin.com/in/markgerarddavis At its simplest definition, recursion is a function that is applied to itself, or a function that is called by itself.  Here is a basic example, taken from mathematics, [...]

2012-05-03T01:12:06-05:00May 3rd, 2012|

Part 4: Switching from Production to Beta backends in SQL Server with ease.

Author note: This is the final post on a four post series on DSN-less tables in Access. You can review part one here. Take a look at part 2 here. See part 3 here. How can you test changes in the cloud with your Beta users? Once you've rolled out your Access masterpiece using SQL Server in the cloud, [...]

2025-05-24T23:43:46-05:00April 23rd, 2012|
Go to Top