Access offers a variety of features for different database needs. You can use it to develop five general types of applications:
- Personal applications
- Small-business applications
- Departmental applications
- Corporation-wide applications
- Front-end applications for enterprisewide client/server databases
- Web applications
- Access as a development platform for personal applications
At a basic level, you can use Access to develop simple, personal database-management systems. The one thing to be careful of is that Access is deceptively easy to use. Its wonderful built-in wizards make Access look like a product that anyone can use. Although it's true that you can produce the simplest of Access applications without any thought for design and without any customization, most applications require at least some design and customization.
Access is an excellent platform for developing an application that can run a small business. Its wizards let you quickly and easily build the application's foundation. The ability to create macros and to build code modules allows power users and developers to create code libraries of reusable functions, and the ability to add code behind forms and reports allows them to create powerful custom forms and reports. Access is perfect for developing applications for departments in large corporations. Most departments in large corporations have the development budgets to produce well-designed applications. Although Access might be best suited for departmental applications, you can also use it to produce applications that you distribute throughout an organization.
Introduced with Access 2010 was the ability for you to use Access to build web applications, which are applications that can run in a browser.