RE: Access user-friendliness needs to improve

Actually, Microsoft has spent a lot of effort to make Access available to the
masses. We professional developers some times think perhaps too much.

Anybody can paint a wall, but only Michaelangelo could do the Cistene
Chapel. For keeping track of some simplistic data, it doesn't take much to
make Access useful. And it does not take knowledge of VBA to do so. There
are some fairly complex databases around that have no VBA at all, but it is
useful for manipulating more complex data and for creating user interfaces
that prevent incorrect data from being entered. I have seen some good apps
using only Macros.

As has already been stated, Access is not as much an application as a
development tool, but it can be used effectively without a lot of training.
You do need to understand some basic Database Normalization methods and
rules, but you also have to know some basic arithmetic to use Excel and be to
some degree literate to use Word.

Now, in parting, and with good will, if you are one of those agencies who
wants to collect some of my money or impose more regulations on my life, I
hope you never get it right; otherwise, I encourage you to keep at it. These
newsgroups are about the best place to learn.
--
Dave Hargis, Microsoft Access MVP


"Sunrise" wrote:

Access is part of the suite of products supplied to all workers in my federal
government offices - many thousands of workers. Conceptually it is a great
product but rarely used due to its complex nature. IT support rarely has
specialized knowledge of software packages and focuses mainly on the larger
technical issues like connectivity problems and networking etc. As such,
administrative staff are left to solve their own problems with
software...which competes with heavy workloads. The result is that MS-Access
is not used very often because you have to have a lot of experience and
training for it to be useful and maintainable. Many offices have a high
turnover of staff. A database is only useful if it is maintainable. Barely
anyone knows how to use it.

As an office manager I am creating databases for my office but am keeping
them as simple as possible because I know that, if I don't, when I move on
there will be no one in the office who can maintain them and they will be
dropped. If I add complexities to the databases I am in essence 'wasting my
time'.

This tool of efficiency has so much potential but is not being used because
no one has the knowledge or training to use it.

MS should continue developing this wonderful administrative tool with an eye
to making it easier for the beginner to produce reports more easily.
Administrative staff become familiar with Word because they have no choice.
It is not the same story with Access...because it is optional. It would be
nice to see a twinning of the features in Word with those in Access so the
transition would be seamless, quick, and easy for those who are comfortable
with Word.

An example is the line between columns. Through this community I received a
response to my question on this topic. I am greatful but surprised that a
simple line could require such in depth knowledge and VBA programming.. This
is ridiculous. In Word you are asked if you want a line between columns and
then click YES.

People don't make the transition because the transition is too hard to make
and they have too much work to do.
--
Sunrise
.

Relevant Pages

  • Re: Chris Pirillo: Vista vs Mac OS X Leopard.
    ... made the jump and are putting pressure on developers. ... The transition *was* rather abrupt for developers, ... way Apple and Microsoft run their platforms. ... even when it requires holding the platform back. ...
    (comp.sys.mac.advocacy)
  • Re: Support for optional parameters
    ... programming language, but THE central programming language of the .Net ... Office being THE cash cow at Microsoft, well, forgive me for restraining my ... The success of the VSTO initiative and the success of Office are two ... >> sure it comes in handy for a few developers out there from time to time. ...
    (microsoft.public.dotnet.framework)
  • Re: WHY
    ... it's a question of who's generating the reports. ... databases do most of their data entry into character mode applications ... Beleive me, if it could be, Microsoft would be pushing it like you wouldn't ... Microsoft has *NEVER* been shy about marketing anything it thinks will ...
    (microsoft.public.excel)
  • Re: Penetration of ASP.NET - Developers continue to use VB6 & ASP
    ... and how Microsoft has lost control of the ... >: preferred API. ... a Windows server but don't require Windows clients, ... people and it's certainly good enough for developers, ...
    (microsoft.public.inetserver.asp.general)
  • Re: Penetration of ASP.NET - Developers continue to use VB6 & ASP
    ... and how Microsoft has lost control of the ... : preferred API. ... a Windows server but don't require Windows clients, ... people and it's certainly good enough for developers, ...
    (microsoft.public.dotnet.framework.aspnet)
Loading