Microsoft Access provides users with one of the simplest and most
flexible RDBMS solutions on the market today. Regular users of
Microsoft products will enjoy the familiar Windows 'look and feel' as
well as the tight integration with other Microsoft Office family
products. If Microsoft Office is your preferred office software suite then it makes sense to
seriously consider Microsoft Access as your database of choice.
|
Cost |
Access Database comes
packaged with Microsoft Office Professional and so it
may already be part of your SOE. |
|
Ease of use |
As with all Microsoft product, Access Database has that
familiar Windows 'look and feel' |
|
Support |
Microsoft Access is one of
the best-selling desktop databases of all time. As such
you can
be sure of future support, and with Microsoft's backing
it should be around for some time to come. |
|
Future proof |
Because Microsoft is
constantly improving their database you can be sure that
your investment is future-proof. Microsoft Access is not
a dead end product. |
|
Multi-User |
Since the beginning, Access
was designed to operate on a network. Microsoft
say that the latest version will support 255 concurrent
users, however in practice we would recommend a more
comfortable limit of 15 to 20 simultaneous users. |
|
Cost of development |
The popularity of Access
with database developers provides you with greater
choice of developers and lower development rates
consistent with a competitive market place. |
|
Rapid Application
Development |
You can use Microsoft Access for Rapid
Application Development thus keeping your costs down.
Its object oriented model means you can build
attractive, functional and easy to use applications in
double-quick time. |
|
Scalable |
Access has an upgrade path.
So, if performance starts to suffer from an ever
increasing number of users or records, you can upsize to
SQL Server. |
|
Integration
|
Access has been designed to
works well with other products in the Microsoft Office suite. It has been
designed with integration in mind. |
|
Legacy data |
Access can import many data
formats so your existing data is not lost.
When properly exploited, and electronic data is
available, this feature alone can save 100s of data
input hours |
|
Web integration
|
Access (2000 and later
version) has close web links so online data access is
made easier. With a shift towards e-commerce, Access's
web integration could prove very useful, if not now,
then sometime in the near future. |
