Question

a) What are the most important differences between MS Access and as Server database like SQL Server?

b) Does Access have any advantages over SQL Server?

c) Describe one or more scenarios where you would recommend upgrading an existing MS Access application to SQL Server. Not the use of SQL Server Express edition.

Answer 1

(a) differences:-

(i) Interface:- Access uses drag and drop query creation while sql server doesn't. So ms access can be used by naive users while to run sql server expert level users are needed.

(ii) Price:- Ms access license cost approx 200 dollar while sql server costs several thousand dollars.

(iii)Queries:- Queries in ms access includes some different keywords than sql server. for example IIF in access is similar to case in sql server.

(iv) Procedures and user defined functions:- ms access doesn't support procedure and function creation while sql server does.

(v) Recovery:- Recovery in sql server is automated while ms access files can be recovered only if it is backed up in different drive or location.

(b) Advantages of ms access over sql server:-

(i) The first advantage is that ms access is user friendly and a naive user can also create tables and run queries.

(ii) Ms access is cheaper than sql server in terms of cost.

(iii) Importing data in ms access is very easier than sql server.

(iv) Ms access has multi-user support . So ten users in same network can use acess.

(v) Ms access is .NET friendly.

(c) In organisation we need triggers to automate tasks. Ms access doesn't support triggers, In this scenario we need to use sql server. Suppose an employee salary must be increased automatically at the end of year by 2000. This task can be easily done by sql server while ms access can't do. There are a lot of other tasks needed to be done with help of triggers. So it is beneficial to upgrade ms access to sql server.

DON'T FORGET TO HIT LIKE.

THANKS BY HEART.