|
 |
Microsoft Access
Development
We offer professionally designed database applications
customized to the clients business practices. We can design applications
in all versions of Microsoft Access, Microsoft SQL Server. We also
utilize Microsoft Visual Basic/C# .NET.
Microsoft Access is a relational database management system developed by
Microsoft. Access ships as a stand alone product or is included in
MS Office Professional and above. Availability and ease of use has made
MS Access a popular choice for many businesses and developers. Access
provides a way to rapidly create what is called ad-hoc or
"Quick-n-Dirty" database applications. Even though Access provides users
and developers with a lot of power for little effort is often
misleading. Access is very powerful application development tool not
only for novice users, but for professional developers as well.
Many
professional developers use Access to create more robust applications
for mobile and office users. Larger businesses many times use a more
robust database "back-end" such as Oracle, MS SQL Server, DB2, MySQL,
just to name a few. Using Access as a "front-end" or user interface to
the larger database engines enables developers to provide businesses
with a more mature application without sacrificing the benefits and
familiar interface of Access.
Benefits of using
Access for users
-
Allows users to use prebuilt database templates for common jobs.
-
Gives users a host of wizards to do basic database tasks
-
Provides users a way to share information more effectively with
other users
-
Quickly develop "canned" reports
Benefits of using
Access for developers
-
Provides an Integrated Development Environment (IDE) for writing
code
using Visual Basic for Applications (VBA)
-
Access connects to a host of data sources using Open Data Base
Connectivity (ODBC)
-
Use VBA coding for tighter integration with other Microsoft based
applications. Especially, MS Office Applications, like Word, Excel,
Outlook, Visio, PowerPoint, InfoPath, Publisher.
-
Ability to create customized add-ins for use in business
applications.
-
Capability to link access tables to web applications.
|