Upsize Your MS Access Business Information to MS SQL Server
3.4 (44 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,297 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Upsize Your MS Access Business Information to MS SQL Server to your Wishlist.

Add to Wishlist

Upsize Your MS Access Business Information to MS SQL Server

Easily upsize your business information in just a few and easy steps
3.4 (44 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
3,297 students enrolled
Last updated 1/2016
English
Price: Free
Includes:
  • 1 hour on-demand video
  • 5 Supplemental Resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • Easily and Safely Upsize your MS Access Business Information to SQL Server
  • Have an SQL Server Backend and an MS Access FrontEnd
View Curriculum
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 is the target audience?
  • Business Analysts who work with Ms Access based information
  • Marketers who work with Ms Access based information
  • Database Managers
  • Database Administrators
Students Who Viewed This Course Also Viewed
Curriculum For This Course
19 Lectures
01:02:54
+
Who We Are
1 Lecture 00:35
About Us
00:35
+
Why You Should or Have Subscribed This Course
1 Lecture 04:35
Course Background
04:35
+
From MS Access to MS SQL Server
2 Lectures 07:18
Course Roadmap
03:11

Prepare & Backup Your Business Information
04:07
+
MS SQL Server
2 Lectures 06:50
The Ins & Outs of MS SQL Server
01:44

MS SQL Server Editions
05:06

Identify the main SQL Server Editions Available

MS SQL Server Editions
1 question
+
Choices, choices ...
2 Lectures 05:14
Which MS SQL Server Edition Should You Choose
05:14

Checkpoint
1 page

MS Access FrontEnd

MS Access FrontEnd
1 question
+
Installing & Setting Up
3 Lectures 07:04
Installing MS SQL Server 2014 Express Edition
05:49

Installing SSMA (SQL Server Migration Assistant)
01:15

Checkpoint
1 page
+
Upsizing Your Business Data to MS SQL Server
4 Lectures 13:44
Upsizing Using SSMA (SQL Server Migration Assistant)
08:12

Take Care With 32bit and 64bit Application Versions
02:18

The Old Way - Upsize Using MS Access Upsizing Wizard
03:14

Checkpoint
1 page
+
Wrapping Things Up
2 Lectures 08:51
Cleaning Up & Testing Your Business Information
08:51

Checkpoint
1 page
+
Congratulations
2 Lectures 03:43
The End
03:43

Bonus Lecture: EARLBIRD Access to Our Other Course
1 page
About the Instructor
Microvio Online Training
4.5 Average rating
152 Reviews
3,886 Students
3 Courses
Online Trainers Specialised on Marketing and Management

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.

Ricardo Gonçalves
4.5 Average rating
152 Reviews
3,886 Students
3 Courses
Entrepreneur, Marketer & Instructor

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.