Andy's PC Computer And Data Help! Database Applications - Part II
The Two Most Popular Databases are MS Access and MS SQL Server.
Microsoft Access provides users with one of the simplest and most flexible Database solutions on the market today. Regular users of Microsoft products will enjoy the familiar Windows look and feel as well as the tight integration with other Microsoft Office family products. This is suitable for approx 5 to 10 concurrent users (all accessing the database at exactly the same time).
SQL Server does not have its own user interface and runs only on a server. It can provide the server end of a Client-Server application. SQL Server applications typically require higher investment in programming but provide a higher level of reliability and better suited to very high volumes of transactions.
Sql server combined with Access And VBA, Or Visual Basic is an extremely powerful combination, which uses Access/VB for the Front End - Data entry, Queries, and Reports, and then Uses Sql server to store and retreive your data (the Back End). This solution is best for 10 to 10,000 concurrent users
Microsoft MS Access is by far the most popular desktop database, and resides on most computers with Microsoft MS Office. To see the broad and varied uses of Microsoft MS Access Databases, see our How Popular is Microsoft MS Access Database Page