How an online database works.

This will go over how Microsoft Access databases work, this is the database software that I have been using to create databases so I will go over in detail what happens when a database is created.

Microsoft Access has many of the same componants of a regular database application, and one big difference. Access is designed to install and run all of the components on a single computer.

Access can work with remote database such as SQL Server, but is normally used as a package on a single computer using its own database.

The Access application server is called Form View.

The Access developer modules for forms, tables, etc. are called Design Views.

The modules are so closely integrated that most people don't realize that there are several different modules.

• The Jet Database Server is installed when you install Access. Whenever you open Access the database server starts. Access can also connect to SQL Server and a few other databases, but Jet is the default.

Microsoft Access is not as easy to share with other users as separate applications and databases, but it is possible to build complex and sophisticated applications with Access, especially if the application runs against a SQL Server database, these will work very well for a website that stores a lot of passwords and accont details such as Amazon.