New Access User Help
in [Getting Started]
|
Prev: Access DB - list of worldwide contacts - can I show them on a map?.
Next: How do i see the object properties in the navigation pane?
From: John on 14 Dec 2009 09:23 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.
From: Daniel Pineault on 14 Dec 2009 10:27 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.
From: John Spencer on 14 Dec 2009 11:26 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 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 here: 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/expert_contributors.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.
From: Sheila on 14 Dec 2009 21:35 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" <John(a)discussions.microsoft.com> wrote in message news:C85D119A-D718-48B8-AE89-16A665EF5393(a)microsoft.com... > 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. >
From: Philip Herlihy on 15 Dec 2009 07:30
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 " <sheilasawr(a)hotmail.com> wrote in message news:B20C584D-A68E-4DDB-A14C-3017C87A755E(a)microsoft.com... > 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" <John(a)discussions.microsoft.com> wrote in message > news:C85D119A-D718-48B8-AE89-16A665EF5393(a)microsoft.com... >> 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. >> |