In this episode, we're going to take our first steps at setting up SQL Express, our robust, local back end database that has an incredible number of uses - one of those being a hyper-compatible, awesome backend for MS Access applications! Whether you are creating that MS Access backend, databases that you will deploy in Azure, or simply robust network databases, SQL Express should definitely be in your sights if you work in the Microsoft environment. If I could recommend just ONE free tool for any Access developer to learn right now, it would be SQL Express. Hands down. It is truly incredible what you can do with it. It is one way to "level up" in database development, and opens development pathways for you with SQL Server AND Azure SQL.

We'll download and install SQL Express and the (also free) SQL Server Management Studio, a tool that will help you to build and manage your SQL Express, SQL Server, and Azure SQL databases.

Related Videos:
How I Reacted When I First Converted a MS Access App to Use a SQL Server Backend
   • How I Reacted When I First Converted ...  
How to Install and Use SQL Express
You are watching this video now!
How to Design Tables in SQL Express for Use with MS Access
   • How to Design Tables in SQL Express f...  

Join me on Patreon!
  / mackenziedataengineering  

Demo of my BZ RDP Cloaker:
https://www.patreon.com/posts/how-to-...



Check out some tech (and support my channel!):
https://www.amazon.ca/shop/seanmacken...

Want the code from this video?
http://mackenziemackenzie.com/downloads

For developers looking for a new role, check out and sign up:
https://www.toptal.com/qKaO2b/worlds-...

Needing to hire technical resources for your project? Get the best:
https://www.toptal.com/qKaO2b/worlds-...

Contact form you can find at http://www.mackenziemackenzie.com/

Follow me on social media:
  / mackenziedataanalytics  
  / seamacke  
  / seamacke  
  / seamacke  
  / psmackenzie  

Get Microsoft Office including Access:
https://click.linksynergy.com/fs-bin/...

Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try:
https://www.tubebuddy.com/seanmackenz...