The application program also provides a visual interface to create custom forms, tables, or SQL query. in its use of data can be inserted into Access database using either a visual form or basic spreadsheet interface. The information has been stored in an Access database can be accessed, searched, and accessed from other programs, including using Web services.
While Access is a proprietary Microsoft Access tutorial database management sys
tem (DBMS), which is already compatible with other database programs it supports Open Database Connectivity (ODBC). This allows the data to be sent to and from other database programs, such as MS SQL, FoxPro, FileMaker Pro, as well as Oracle databases.
Advantages of compatibility also allows access to serve as a back end for a database-driven Web sites. In fact, Microsoft FrontPage and Expression Web, and ASP.NET has a built-in support for Access databases. For this reason, the site is hosted on Microsoft Windows servers often use the Access database to generate dynamic content.