How to Design Tables in SQL Express for Use with MS Access

In this episode, we take a look at how to craft a table in SQL Express (or SQL Server, or Azure SQL) for the purpose of integrating it with a Microsoft Access front end. The free SQL Express (formerly MSDE) has a long history of tight integration specifically with MS Access, and they were even shipped together for a long time. Building off of our last video in this playlist where we installed and configured SQL Express, in this episode we'll design our first table and demonstrate my top choices on how to build table fields in SQL Express that directly translate to specific field types in MS Access. This allows us to build and link tables that run flawlessly in the MS Access front-end environment, so that your form, report, and VBA designs execute exactly as you intend, but on a bigger, more scalable, more feature rich back-end database. Let's go!
Related Videos:
How I Reacted When I First Converted a MS Access App to Use a SQL Server Backend
• How I Reacted When I F...
How to Install and Use SQL Express
• How to Install and Use...
How to Design Tables in SQL Express for Use with MS Access
You are watching this video now!
Make sure to watch the previous episode on How to Install and Use SQL Express: • How to Install and Use...
Join me on Patreon!
/ mackenziedataengineering
Demo of my BZ RDP Cloaker:
www.patreon.co...
Check out some tech (and support my channel!):
www.amazon.ca/...
Want the code from this video?
mackenziemacken...
Interested in transforming your career or finding your next gig?
system.billzon...
Want my team to do a project for you? Let's get to it!
system.billzon...
Contact form you can find at www.mackenziema...
Follow me on social media:
/ mackenziedataanalytics
/ seamacke
/ seamacke
/ seamacke
/ psmackenzie
Get Microsoft Office including Access:
click.linksyne...
Got a KZbin Channel? I use TubeBuddy, it is awesome. Give it a try:
www.tubebuddy....
#sqlserver #msaccess