Differences of MS Access and SQL
MS Access is a Rapid Application Development (RAD) tool that allows you to quickly build forms and reports that are bound to relational data. It comes with a file-based database engine (Jet/ACE). SQL Server is a relational database management system (RDBMS) from Microsoft that's designed for the enterprise environment.Relational database programs, such as Microsoft Office Access, use SQL to work with data. Unlike many computer languages, SQL is not difficult to read and understand, even for a novice. Like many computer languages, SQL is an international standard that is recognized by standards bodies such as ISO and ANSI.MS Access works only on Windows whereas MySQL works on almost all platforms. ... It is no good for remote access, its' connection system is not solid. It is generally useless for multiple user purposes.And you are far better using a web based interface for mysql, VB is also limited in functions and power.Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools.The Number data type in Access is a data type for different types of numbers, like Integer, Long Integer, Byte, Decimal, et cetera. The exact number type is configured using the Field Size property.