Go to navigation
It is currently Sat Dec 10, 2016 8:57 am

All times are UTC




Post new topic Reply to topic  [ 10 posts ] 
Author Message
 Post subject: Microsoft Access
PostPosted: Thu May 15, 2014 8:29 am 
Offline

Joined: Mon May 16, 2011 1:05 pm
Posts: 4024
Location: Reading
Need to learn how to use access. Anyone know any good online tutorials ansd/or good books.
Thanks


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Thu May 15, 2014 9:25 am 
Offline

Joined: Wed Nov 21, 2007 4:20 pm
Posts: 4660
Books 'For Dummies' are usually good for this sort of thing.

_________________
Image


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Thu May 15, 2014 9:45 am 
Offline

Joined: Mon Sep 10, 2012 10:51 am
Posts: 865
http://www.freeofficetutorials.com/ 8)


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Thu May 15, 2014 10:20 am 
Offline

Joined: Fri Aug 30, 2013 7:30 am
Posts: 2248
Searc on youtube, good for anything from cutting hair, changing a bulb, to all things Microsoft.


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Thu May 15, 2014 1:13 pm 
Offline

Joined: Wed Nov 23, 2011 12:52 pm
Posts: 603
Location: Shamballa
I am self taught. I recommend "Access for Dummies".

_________________
"To err is human;to forgive ,divine"


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Thu May 15, 2014 2:43 pm 
Offline

Joined: Mon May 16, 2011 1:05 pm
Posts: 4024
Location: Reading
Thanks all. I've had mixed experience with Dummies books, so good to hear someone found this one useful.


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Thu May 15, 2014 4:11 pm 
Offline

Joined: Wed Nov 23, 2011 12:52 pm
Posts: 603
Location: Shamballa
If you know the basics-set up some tables,do some make_table queries,join queries,delete and append and filter queries.
Set up a macro and run the above queries.
Try building a form and go from there.

_________________
"To err is human;to forgive ,divine"


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Thu May 15, 2014 4:22 pm 
Offline

Joined: Mon May 16, 2011 1:05 pm
Posts: 4024
Location: Reading
I have never used Access before, ever.

However many moons ago I did use Lotus Approach and managed to link it to drawings on Auotcad so I could get info on objects on the drawing from the DB. However Approach seemed to be considerably more user friendly than Access when I've ventured anywhere near it.

The end product will be used by non access users in a meeting to record information, then after the meeting the info needs to be manhandled to give info to various people in different formats. At the moment we use excel, and trying to wrestle the info out of that in the format wanted is like herding cats.


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Fri May 16, 2014 8:57 am 
Offline

Joined: Wed Nov 23, 2011 12:52 pm
Posts: 603
Location: Shamballa
Hi- Access is mainly used for large volumes of structured data.Sounds like you should not be using Access in this case-without knowing what the data is like.

Also you may be better off using excel and writing visual basic to get the data in the formats required ?

_________________
"To err is human;to forgive ,divine"


Top
 Profile  
 
 Post subject: Re: Microsoft Access
PostPosted: Fri May 16, 2014 1:25 pm 
Offline

Joined: Mon May 16, 2011 1:05 pm
Posts: 4024
Location: Reading
Seems our ICT dept don't support Access, so it's not the way to go anyway. Seems I'll have to do something interesting with Excel instead.

I would know what the data is and what we need out of it, it's the same sort of data every time. Excel is just a bit clunky for the job.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 10 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
CALL 020 8204 5060
   
Privacy Policy | Refund Policy | Disclaimer | Copyright © 2004 – 2016