What Front end applications SQL server to be used?

Asked By harry ggaston 0 points N/A Posted on - 02/07/2013

Hello! I just need help! I am currently into database administration. I want to know what front end applications SQL server should I be using to input data easily? Thank you!

• Status: Open
• Question Views: 841
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by Parisi Petrusic

Go To Solution

Best Answer

Best Answer

Answered By Parisi Petrusic 0 points N/A #166400

What Front end applications SQL server to be used?

Hello,

 

Since you are using the SQL server as the back-end MS Access is an excellent front-end tool for the SQL Server back-end.  It is a very good rapid development environment for front-end applications, while the databases are safely hosted by the SQL Server, as long as you know how to optimize performance. I am attaching a very excellent document collected from the Internet that demonstrates you the basics of using Access as a client-server application so that you can take advantage of the  power of the SQL Server while employing the skills you have on Access. 

 

If you take a walk-through on the attached presentation, it can be a great guide to taking steps toward MS Access and placing before your back-end.

 

Best Regards,

Parisi

 

About Parisi Petrusic

Questions
2

Answers
100

Best Answers
12

• Vote Up 0 Vote Down

• Posted on - 02/14/2013
• Question Category: MS SQL Server

Answered By Sinky Lynn 0 points N/A #166401

What Front end applications SQL server to be used?

Hello,

In most situations the front end applications are either tailor made for the customer needs or at times custom made to suit customer needs. In other situations web based front end applications are also used to interact with the database

However, it is easier to provide the customer with a much familiar interface to interact with the database on the backend. This brings developers to using Ms Access or Ms Excel as their front end applications.

Below is a link showing on how to configure Excel to act as your front end application

https://www.lifewire.com/excel-front-end-to-sql-server-2495398

About Sinky Lynn

Questions
2

Answers
35

Best Answers
3

• Vote Up 0 Vote Down

• Posted on - 02/18/2013
• Question Category: MS SQL Server