Upsize Your MS Access Business Information to MS SQL Server

Easily upsize your business information in just a few and easy steps
Rating: 4.3 out of 5 (137 ratings)
6,800 students
Upsize Your MS Access Business Information to MS SQL Server
Rating: 4.3 out of 5 (137 ratings)
6,801 students
Easily and Safely Upsize your MS Access Business Information to SQL Server
Have an SQL Server Backend and an MS Access FrontEnd

Requirements

  • Willingness to Learn
  • Computer with MS Access
Description

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!

Who this course is for:
  • Business Analysts who work with Ms Access based information
  • Marketers who work with Ms Access based information
  • Database Managers
  • Database Administrators
Curriculum
9 sections • 19 lectures • 1h 2m total length
  • About Us
  • Course Background
  • The Ins & Outs of MS SQL Server
  • MS SQL Server Editions
  • MS SQL Server Editions
  • Which MS SQL Server Edition Should You Choose
  • Checkpoint
  • MS Access FrontEnd
  • Installing MS SQL Server 2014 Express Edition
  • Installing SSMA (SQL Server Migration Assistant)
  • Checkpoint
  • Upsizing Using SSMA (SQL Server Migration Assistant)
  • Take Care With 32bit and 64bit Application Versions
  • The Old Way - Upsize Using MS Access Upsizing Wizard
  • Checkpoint
  • Cleaning Up & Testing Your Business Information
  • Checkpoint
  • The End
  • Bonus Lecture: EARLBIRD Access to Our Other Course

Instructors
Online Trainers Specialised on Marketing and Management
Microvio Online Training
  • 3.8 Instructor Rating
  • 257 Reviews
  • 8,091 Students
  • 3 Courses

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
Ricardo Gonçalves
  • 3.8 Instructor Rating
  • 257 Reviews
  • 8,091 Students
  • 3 Courses

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.