Monthly Archives: February 2014

14 – Creating A Trigger

In this post, we will be explaining what triggers are and how to create them. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

13 – Calling A Stored Procedure From Access

In order to fully maximise the effect of a SQL Server back-end, we are going to need to be able to called stored procedures from MS Access. In this post we show you how to do it. In order to view the rest of this content you will need to register for a premium account. […]

12 – Stored Procedures

In this post I will be discussing Stored Procedures, how to create them and the benefits of using them. Stored Procedures in SQL Server are similar to sub procedures in MS Access. We often have code that needs to be called in more than one location and rather than duplicate the code, it is preferable […]

11 – Functions

In this post I will be discussing Built-in functions in SQL Server and showing you how to create a User-Defined function. Featured Videos Built-In Functions User-Defined Functions In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

10 – Creating Views

In this post we will be explaining what views are and how they can be created in SQL Server. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

09 – Migrating Tables And Data To SQL Server

In this post we will be explaining how to migrate your MS Access database to your new SQL Server application. Featured Videos: Connecting To SQL Server Migrating To SQL Server Linking Tables In Access Featured Downloads HotelBookings.accdb In order to view the rest of this content you will need to register for a premium account. […]

08 – Installing SQL Server Migration Assistant

In this post we will be explaining how to install SQL Server Migration Assistant. In the video I show you where to download the assistant from but if you want you can download it from this page (below the video). Featured Videos: Installing SQL Server Migration Assistant Featured Downloads SSMA for Access5.2 In order to […]

06 – Table SQL Basics

In this post we will be explaining some basic SQL commands that will help you create the kind of tables you want to see. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

05 – Creating A Table

In this post we will explain how to create a table in our newly installed SQL Server instance. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

04 – Creating A Database

In this post I will explain how to create a database in our newly installed SQL Server instance. In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

03 – Logging On

In this post I will explain how to log on to your SQL Server installation. Ok, so you have installed your SQL Server with no issues (we hope) and now need to log on. Not exactly tricky but worth its own post. In order to view the rest of this content you will need to […]

02 – Installing SQL Server

In this post I will be explaining how to install SQL Server 2012. Featured Videos: Installing SQL Server In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.