Absolute New User

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

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

On Mar 23, 1:32*am, albertmb
wrote:
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

Checkout
http://www.cardaconsultants.com/en/m...&id=0000000008 there
you will find a listing of several very good websites, books, etc.
--
Hope this helps,

Daniel Pineault
For Access Tips and Examples: http://www.cardaconsultants.com/en/msaccess.php
If this post was helpful, please rate it by using the vote buttons.



"albertmb" wrote:

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

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
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"albertmb" wrote in message
...
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

On Sat, 22 Mar 2008 22:32:00 -0700, albertmb
wrote:

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/acc...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!)
--

John W. Vinson [MVP]

Hi Everyone,

I, too am new Access user. I started last year and did some basics but then
dropped it because I got too busy but now would like to add it to my resume
as a skill (intermediate hopefully). I found a website called Access 2003 in
Pictures which has been helpful because it is so visual. Starts with the
very basics. Starting with a book that only has text last year was a lot
harder (though doable). I have the MS Office Specialist book and it
complements all the other visual tutorials I can find. Whoever said it is
nothing like Excel was right. Definitely apples and oranges. Below are a
couple of websites to copy/paste.

http://inpics.net/tutorials/access2003/basics57.html

http://www.teacherclick.com/ (grammar is not up to snuff but the lessons
are quite good)

I will be looking at the websites provided here. Good luck Albert.

I'm sure I'll find help here too.
albertmb wrote:
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

Thank you all for your suggestions. I realy appreciate it.

Regards
Albert

"grammatim" wrote:

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

On Mar 23, 1:32 am, albertmb
wrote:
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

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.

On Mar 23, 2:04*am, grammatim wrote:
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

On Mar 23, 1:32*am, albertmb
wrote:

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.

More info here. Looks very neat.

http://ittraining.lse.ac.uk/Document...htm#Pivot_Tabl
es

Evi
"grammatim" wrote in message
...
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.

On Mar 23, 2:04 am, grammatim wrote:
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

On Mar 23, 1:32 am, albertmb
wrote:

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.