SQL Server is a relational database management system (RDBMS) from Microsoft. It can be used effectively to host large data tables for Microsoft Access database applications or a Web/Extranet Applications.
SQL can hold much more data than an Access database and offers improved performance, reliability and scalability.
T-SQL – Tables, Views, Stored Procedures, Functions, Indexing
SSMS – SQL Server Management Studio
SSMA – Microsoft SQL Server Migration Assistant
Security – SQL Authentication or Windows Authentication.
Configuration and implementation of SQL server as a backend database for use with Microsoft Access or Web.
Connectivity via ODBC, ADO & DAO.
Migration of Access databases to SQL server, either manually or by using the efficient SSMS tool – with data type mapping and maintaining relationships and indexes.
Optimising SQL and implementing views to improve overall database performance.