A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

first time



 
 
Thread Tools Display Modes
  #1  
Old September 17th, 2009, 10:08 AM posted to microsoft.public.access.gettingstarted
Nathan
external usenet poster
 
Posts: 177
Default first time

I want to create on project using access for time sheet management in
construction side but i dont have any idea in access can before this is first
time can you help for me?
  #2  
Old September 17th, 2009, 01:33 PM posted to microsoft.public.access.gettingstarted
Philip Herlihy[_2_]
external usenet poster
 
Posts: 64
Default first time

Nathan wrote:
I want to create on project using access for time sheet management in
construction side but i dont have any idea in access can before this is first
time can you help for me?


The best advice I can offer is to give you a sense of what's involved.
Access is powerful and rewarding to use, but it takes quite a bit of
study to master. Noone should expect simply to pick it up and use it -
you do need some introductory training. Microsoft have a good
introduction at:
http://office.microsoft.com/en-us/tr...582831033.aspx
... and there are good introductory videos (monthly fee) at lynda.com.

The most important thing by far to get your head around is table design
and "normalisation" - get that right and everything falls into place
more easily. Access is a "relational database", with forms, reports and
VBA modules bolted on. It's important to understand what a "key" is,
and to know how to represent a one-to-one, a one-to-many and a
many-to-many relationship between tables representing "entities".

There are also templates you can explore, adapt and use:
http://office.microsoft.com/en-us/te...33.aspx?av=ZAC

... and many resources on the web. If you add "MPV" to a web query
you'll pick up sites run by "Most Valuable Professionals" a number of
whom provide free advice here.

How's that for starters?

Phil, London
  #3  
Old September 17th, 2009, 07:00 PM posted to microsoft.public.access.gettingstarted
John W. Vinson
external usenet poster
 
Posts: 18,261
Default first time

On Thu, 17 Sep 2009 02:08:02 -0700, Nathan
wrote:

I want to create on project using access for time sheet management in
construction side but i dont have any idea in access can before this is first
time can you help for me?


Access is quite capable of doing this... but don't expect it to be quick or
easy, it's a powerful program but is correspondingly complex. Here's some good
resources to get started:

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

Roger Carlson's tutorials, samples and tips:
http://www.rogersaccesslibrary.com/

A free tutorial written by Crystal:
http://allenbrowne.com/casu-22.html

A video how-to series by Crystal:
http://www.YouTube.com/user/LearnAccessByCrystal

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

--

John W. Vinson [MVP]
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:17 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.