Find online courses made by experts from around the world.
Take your courses with you and learn anywhere, anytime.
Learn and practice real-world skills and achieve your goals.
MS Access is one of the most used business productivity tools around.
Businesses of all sizes use it - you can find it on home and small businesses as well as on medium and big businesses alike.
It can be used to manage small tasks or projects but it can also be used to manage an entire business day to day operation.
Whatever the case there will probably come a time when your business will outgrow the technical capabilities of a MS Access database or application.
When that time comes you'll probably want to transfer your business information into a more powerful database management system (SQL Server) - but at the same time you'll still want to keep on using your familiar forms and reports (MS Access).
This course is precisely aimed at helping and teaching you how to make this migration/upsizing, by guiding you through a few easy steps, alongside a handful of tutorials.
Hope You Enjoy The Course - See You Inside!
Not for you? No problem.
30 day money back guarantee.
Learn on the go.
Desktop, iOS and Android.
Certificate of completion.
|Section 1: Who We Are|
|Section 2: Why You Should or Have Subscribed This Course|
|Section 3: From MS Access to MS SQL Server|
Prepare & Backup Your Business Information
|Section 4: MS SQL Server|
The Ins & Outs of MS SQL Server
MS SQL Server Editions
|Quiz 1||1 question|
Identify the main SQL Server Editions Available
|Section 5: Choices, choices ...|
Which MS SQL Server Edition Should You Choose
|Quiz 2||1 question|
MS Access FrontEnd
|Section 6: Installing & Setting Up|
Installing MS SQL Server 2014 Express Edition
Installing SSMA (SQL Server Migration Assistant)
|Section 7: Upsizing Your Business Data to MS SQL Server|
Upsizing Using SSMA (SQL Server Migration Assistant)
Take Care With 32bit and 64bit Application Versions
The Old Way - Upsize Using MS Access Upsizing Wizard
|Section 8: Wrapping Things Up|
Cleaning Up & Testing Your Business Information
|Section 9: Congratulations|
Bonus Lecture: EARLBIRD Access to Our Other Course
Our Experience & Expertise is based on Marketing, Entrepreneurship & Training - the professional background of our instructors has taken us through the automotive, financing,banking, accounting, realty and information systems sectors - in the projects we've been a part of we've gained significant experience & expertise on Marketing, CRM & Loyalty, Business Intelligence, Project Management, Product Development & Management, Communication, Incentives & Commercial Activation as well as Training - for more details please check the LinkedIn Profiles of our Instructors.
Entrepreneur, Marketer & Instructor - with a professional background that has taken me through the automotive, financing,banking, accounting, realty and information systems sectors - in the projects I've been a part of I've gained significant experience & expertise on Marketing, CRM & Loyalty, Business Intelligence, Project Management, Product Development & Management, Communication, Incentives & Commercial Activation as well as training - for more details please check my LinkedIn Profile.