I am writing a paper on the use of Microsoft Access, and consequently,
I am trying to find good data on who uses the product, what they use
it for, and what industries it is used in. Do people create their own
databases, or do they tend to use experts? What are the primary goals
of an access database as opposed to the various other products in
office such as InfoPath and Excel.

Does anyone know where I could find such data? Are there any studies
on this matter? If you are a consultant and expert in the field, do
you have any personal opinions to share on this matter?

It is a pain to find this sort of data on the web because "access" and
"microsoft" are such generic terms, so any intelligent input would be
a great help. (I am sure it would also be useful to the broader access
community too.)

Thanks in advance.

On Apr 5, 7:21*am, FraserOrr <fraser... (AT) gmail (DOT) com> wrote:
This may be a start: http://en.wikipedia.org/wiki/Microsoft_Access

"FraserOrr" <fraserorr (AT) gmail (DOT) com> wrote

Start here on the access team blog:

They just asked your question last week, and the responses are great:

You find that blog post here:
http://blogs.msdn.com/access/archive...e-project.aspx

The above has 31 responses, and a ton of great examples

And, here is another one:

The Access Show:
How the Microsoft Legal Department uses Access 2010 web databases

http://blogs.msdn.com/access/archive...databases.aspx

Now that the new version of access allows one to build web based
applications, then even large companies like Microsoft can deploy and use
ms-access without regards to what version they have on their desktop. And,
things like security and scalability are also solved with this web choice we
now have.

I can't remember any time in MANY years that Access is actually being used
internal at Microsoft and even more so that they were willing to talk about
it in public! So, I must say things are really looking up for access here.

And, here is a web based application demo video I built in access:
http://www.youtube.com/watch?v=AU4mH0jPntI


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com

FraserOrr <fraserorr (AT) gmail (DOT) com> wrote:

http://accesstips.datamanagementsolutions.biz/apps.htm
Granite Fleet Manage - http://granitefleet.com/

With respect to the Auto FE Updater, a utility used with Access,
"I've received emails from folks at Boeing, BMW, Daimler Chrysler, Starbucks, Bank of
Canada, Royal Bank of Canada, a number of hospitals, all branches of the US Military,
the Canadian Armed Forces, the US FDA, the Australian Dept of Health, the Inspector
General's Office of California, Boston Architectural Collage, NASA, Lawrence
Livermore National Laboratory, Staples, University of Washington, IBM, Winnebago,
Avon, the IRS, Bombardier and many more."
http://www.autofeupdater.com/

Both.

Access organizes data better than Excel and allows for multi user access to that
data. Although much more than that.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
Granite Fleet Manager http://www.granitefleet.com/

Steve Schapel ran a blog series describing some real-world uses of Access:
http://accesstips.datamanagementsolutions.biz/apps.htm

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"FraserOrr" <fraserorr (AT) gmail (DOT) com> wrote

On Apr 4, 5:21*pm, FraserOrr <fraser... (AT) gmail (DOT) com> wrote:
There is a six year thread, What Do You Use Microsoft Access For?
that can be found at:

http://www.utteraccess.com/forum/Mic...r-t378324.html

Hi,

I'm the owner of a small company that markets a desktop solution for
managing artist businesses called WorkingArtist. The current system
makes use of the Access97 runtime, and I'm in the process of upgrading
the system to Access2007.

I think you're going to find that most Access developers are either
doing internal development for their company, or are consultants who
create a large variety of applications for their clients. Not many
people working as ISVs (Independent Software Vendors) using Access as
their development platform from what I can tell based on discussions
within this group and a few others that I follow. It could be I'm
just looking in the wrong place.

Ron

On Apr 5, 5:21*am, FraserOrr <fraser... (AT) gmail (DOT) com> wrote:
In the past 10 years, I have been working as a consultant, developing
software for various categories of clients.
These include:
* Military organizations
* Law Enforcement Agencies
* Credit Card companies
* Banks and other financial institutions
* Mining companies
* Membership Clubs
* Manufacturing companies
* Tax Consultants
* Online Stores
* Bar-code applications

Most of these are using Access as front-end, with either SQL Server or
Access as backend.
There's also online applications that use Access in the back-end and
ASP (server side scripts).
And of course there's lots of TSQL/SQL and VBA programming involved.

Some of these organizations use Access exclusively for complete
applications - typically these
are smaller companies. Larger organizations use SQL Server / Oracle /
Sybase on the back-end,
but does quite a fair bit of inter- or intra-department applications
with Access as the UI.