RE: Access user-friendliness needs to improve

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


As an administrative professional and someone who has a keen eye for
improving efficiency in offices I am very excited to promote the use of
Access within my office and department. I realize now that it is more
intended for developers than for secretaries. But, we need it.

In my view, databases can play an enormous role in reducing workload and
improving our reporting function. The need to 'report' and 'measure' our
productivity and effectiveness has been growing like a disease in our
government (this is a documented fact). Everyone is complaining and
struggling to find a way to cope. With the economy in decline there is no
hope of creating jobs within our structure for Access developers.

I have started voluntary 'lunch and learn' sessions for my staff where we
share our software knowledge - tips and techniques etc. I also pair up
employees who 'know' with employees who 'want/need to learn'. This works out
great - we teach each other. So, through our software sharing we will
endeavour to keep the Access knowledge/skill alive within our office.

Thanks for listening. :)
--
Sunrise


"Klatuu" wrote:

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: Access user-friendliness needs to improve
    ... Good post, Sunrise. ... hope of creating jobs within our structure for Access developers. ... are some fairly complex databases around that have no VBA at all, ... Administrative staff become familiar with Word because they have no choice. ...
    (microsoft.public.access.reports)
  • RE: Access user-friendliness needs to improve
    ... We professional developers some times think perhaps too much. ... Dave Hargis, Microsoft Access MVP ... As an office manager I am creating databases for my office but am keeping ... People don't make the transition because the transition is too hard to make ...
    (microsoft.public.access.reports)
  • RE: Access user-friendliness needs to improve
    ... responses and generous support offered. ... will prove to be very useful to me and those on my staff who are interested. ... There is no question that developers have done some fantastic work on the ... are some fairly complex databases around that have no VBA at all, ...
    (microsoft.public.access.reports)
  • Re: The record source...specified on this form or report does not
    ... eaasier than the developers because I have fewer users, ... Our folks often create little databases in minutes instead of Word ... that in-table dropdowns are the only way to have dropdowns in ... queries, ...
    (microsoft.public.access.tablesdbdesign)