Absolute New User

A

albertmb

Hi Everyone,

I usually work with Excel, but I've been told that Access is more
appropriate for the type of work I do. I have no idea of how Access works,
can anyone help me by suggesting a book or maybe a website where I can learn
how to use Access.

Thank You
ALBERT
 
G

grammatim

I was in the same boat a week ago. You don't say where you are/what is
available to you, but the Access For Dummies begins with very basic
stuff very clearly written; and there's a DVD series called "Professor
Teaches" that does a pretty good job, and a box of 52 "courses" on all
the main Office components for 2000, XP, and 2003, as well as Windows
XP, Photoshop, and various other stuff is currently selling for $9.97
at J & R (in New York City); I assume it's also available at the
website JR.com (the Office2007 edition costs more). The box includes
all the programs on 1 DVD and on 10 CDs
 
A

Arvin Meyer [MVP]

If you are working in Access 2003 or 2007, I'd suggest:

Microsoft Office Access 2003 Inside Out by John Viescas

or:

Microsoft Office Access 2007 Inside Out by John Viescas and Jeff Conrad
 
J

John W. Vinson

Hi Everyone,

I usually work with Excel, but I've been told that Access is more
appropriate for the type of work I do. I have no idea of how Access works,
can anyone help me by suggesting a book or maybe a website where I can learn
how to use Access.

Thank You
ALBERT

In addition (and somewhat overlapping) the other suggestions in this thread:

Jeff Conrad's resources page:
http://www.accessmvp.com/JConrad/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

A free tutorial written by Crystal (MS Access MVP):
http://allenbrowne.com/casu-22.html

MVP Allen Browne's tutorials:
http://allenbrowne.com/links.html#Tutorials

Note that Excel and Access are VERY different, although a table datasheet
looks deceptively like a spreadsheet. It ISN'T a spreadsheet and it doesn't
work like one, and you'll need to do some pretty serious mental gearshifting
to get used to it - but you'll find that there are many things that you can do
much better in Access than in Excel (and that the reverse is also true!)
 
G

grammatim

I've done the first couple of units of "Professor Teaches Access
2003," and it introduces "Pivot View" quite early on. The topic is
barely mentioned in For Dummies and other sources -- I wonder if the
"oldbies" can say whether it's a useful feature? It appears to be a
device for generating a bar graph, but Access data don't seem
particularly amenable to bar graphing.
 
E

Evi

More info here. Looks very neat.

http://ittraining.lse.ac.uk/Documentation/whatsNew/access2003.htm#Pivot_Tabl
es

Evi
I've done the first couple of units of "Professor Teaches Access
2003," and it introduces "Pivot View" quite early on. The topic is
barely mentioned in For Dummies and other sources -- I wonder if the
"oldbies" can say whether it's a useful feature? It appears to be a
device for generating a bar graph, but Access data don't seem
particularly amenable to bar graphing.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top