New Access User Help

I have been using Excel to create reports for over a year now, and my
information and reporting is getting too big. I am going to start to need to
use Access. I have never used it before. So I am litterarly starting from
scratch. Does anyone have any websites that has some good training for
someone who does not know much about Access and can walk someone through how
it works and creating reports. I am also hoping that I can import some of my
excel work over to access. Any help or suggestions would be very much
appreciated.

There are lots of great online ressources! Take a look at my ressource
listing at:

http://www.devhut.net/index.php?lang=en&pid=0000000008

You should have not issue migrating your data, as for reporting??? You may
or may not be able to reuse some of your code, but it all depends on the
nature of the reporting. It will probably be easier to start from scratch
than fighting to modify and bridge from Excel.

In the short term, you may also use Access to house your data and link it
back to Excel to keep using what you have done there, and continue to build
new features in Access. As time permit, slowly migrate the reporting from
Excel to Access.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.



"John" wrote:

I have been using Excel to create reports for over a year now, and my
information and reporting is getting too big. I am going to start to need to
use Access. I have never used it before. So I am litterarly starting from
scratch. Does anyone have any websites that has some good training for
someone who does not know much about Access and can walk someone through how
it works and creating reports. I am also hoping that I can import some of my
excel work over to access. Any help or suggestions would be very much
appreciated.

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

Here's a primer with 23 well defined, well written, clearly named chapters:
http://www.functionx.com/vbaccess/index.htm

--

FROM Tom Wickerath

I have a Word document I call Access Links.doc, that I think you will find
quite helpful. You can download a zipped copy from he

http://www.accessmvp.com/TWickerath/

For the present time, concentrate on just the first couple of pages. This
includes information on special characters to avoid, reserved words, database
design, best practices (make sure that you have the latest updates), Name
Autocorrect, Relationships, along with a lot of useful links to other web
sites.

Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Daniel Pineault wrote:
There are lots of great online ressources! Take a look at my ressource
listing at:

http://www.devhut.net/index.php?lang=en&pid=0000000008

You should have not issue migrating your data, as for reporting??? You may
or may not be able to reuse some of your code, but it all depends on the
nature of the reporting. It will probably be easier to start from scratch
than fighting to modify and bridge from Excel.

In the short term, you may also use Access to house your data and link it
back to Excel to keep using what you have done there, and continue to build
new features in Access. As time permit, slowly migrate the reporting from
Excel to Access.

I am not sure if you are looking for a "free" service but "video professor"
has CD's for all things computers that explain "step by step" how programs
work. They are not free but are very reasonable. Hope this helps; thanks
for your time.

"John" wrote in message
...
I have been using Excel to create reports for over a year now, and my
information and reporting is getting too big. I am going to start to need
to
use Access. I have never used it before. So I am litterarly starting
from
scratch. Does anyone have any websites that has some good training for
someone who does not know much about Access and can walk someone through
how
it works and creating reports. I am also hoping that I can import some of
my
excel work over to access. Any help or suggestions would be very much
appreciated.

Crystal (a respected contributor here) has a collection of tutorial videos
available free:
http://www.YouTube.com/user/LearnAccessByCrystal

Lynda.com also has introductory video training. It's billed monthly (as
many or few months as you choose) and is quite reasonably priced. Try some
free samples on the site, including these ones:
http://www.lynda.com/home/Player.aspx?lpk4=31001 (A2007)
http://www.lynda.com/home/Player.aspx?lpk4=13150 (A2003)

Phil, London

"Sheila " wrote in message
...
I am not sure if you are looking for a "free" service but "video
professor" has CD's for all things computers that explain "step by step"
how programs work. They are not free but are very reasonable. Hope this
helps; thanks for your time.

"John" wrote in message
...
I have been using Excel to create reports for over a year now, and my
information and reporting is getting too big. I am going to start to
need to
use Access. I have never used it before. So I am litterarly starting
from
scratch. Does anyone have any websites that has some good training for
someone who does not know much about Access and can walk someone through
how
it works and creating reports. I am also hoping that I can import some
of my
excel work over to access. Any help or suggestions would be very much
appreciated.