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