Upsize Your MS Access Business Information to MS SQL Server

Easily upsize your business information in just a few and easy steps
3.7 (40 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,275 students enrolled
Free
Start Learning Now
  • Lectures 19
  • Length 1 hour
  • Skill Level All Levels
  • Languages English
  • Includes Lifetime access
    30 day money back guarantee!
    Available on iOS and Android
    Certificate of Completion
Wishlisted Wishlist

How taking a course works

Discover

Find online courses made by experts from around the world.

Learn

Take your courses with you and learn anywhere, anytime.

Master

Learn and practice real-world skills and achieve your goals.

About This Course

Published 10/2015 English

Course 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!

What are the requirements?

  • Willingness to Learn
  • Computer with MS Access

What am I going to get from this course?

  • Easily and Safely Upsize your MS Access Business Information to SQL Server
  • Have an SQL Server Backend and an MS Access FrontEnd

What 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

What you get with this course?

Not for you? No problem.
30 day money back guarantee.

Forever yours.
Lifetime access.

Learn on the go.
Desktop, iOS and Android.

Get rewarded.
Certificate of completion.

Curriculum

Section 1: Who We Are
About Us
00:35
Section 2: Why You Should or Have Subscribed This Course
Course Background
04:35
Section 3: From MS Access to MS SQL Server
Course Roadmap
03:11
Prepare & Backup Your Business Information
04:07
Section 4: MS SQL Server
The Ins & Outs of MS SQL Server
01:44
MS SQL Server Editions
05:06
1 question

Identify the main SQL Server Editions Available

Section 5: Choices, choices ...
Which MS SQL Server Edition Should You Choose
05:14
Checkpoint
1 page
1 question

MS Access FrontEnd

Section 6: Installing & Setting Up
Installing MS SQL Server 2014 Express Edition
05:49
Installing SSMA (SQL Server Migration Assistant)
01:15
Checkpoint
1 page
Section 7: Upsizing Your Business Data to MS SQL Server
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
Section 8: Wrapping Things Up
Cleaning Up & Testing Your Business Information
08:51
Checkpoint
1 page
Section 9: Congratulations
The End
03:43
Bonus Lecture: EARLBIRD Access to Our Other Course
1 page

Students Who Viewed This Course Also Viewed

  • Loading
  • Loading
  • Loading

Instructor Biography

Microvio Online Training, 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.

Instructor Biography

Ricardo Gonçalves, 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.

Ready to start learning?
Start Learning Now