Access - On-line Tutorial/Learning

[Jason O]

Hi,

Can anyone recommend any good online introductions to Access? I'm on a mac
at home so don't have Access on my computer, but I'm wanting to learn as
much as I can before I return to work on Tuesday.

Primarily queries, as my work needs are mainly analysing & interrogating
large amounts of data and Excel is a little unwieldy in this regard (at
least in my hands

Any suggestions greatly appreciated.

Jason

 

[Guest]

Hi Jason,

How's this for starters?

HOW TO: Create a Select Query in Microsoft Access 2000
http://support.microsoft.com/?id=304361

HOW TO: Convert a Select Query to an Action Query in Access 2000
http://support.microsoft.com/?id=304355

Note: You can ignore the "Access 2000" in the titles of these articles. The
information is equally valid for other versions of Access.

Queries: Index of Articles
http://www.mvps.org/access/queries/index.html

Information about query performance in an Access database
http://support.microsoft.com/?id=209126

Query performance decreases when the criteria in a Microsoft JET
4.0 query contains a user-defined function
http://support.microsoft.com/?id=821936

Fascinating Query Tricks
http://www.databasejournal.com/features/msaccess/article.php/10895_3444891_2

And, since you mentioned analyzing large amounts of data, you might want to
experiment with Crosstab Queries, for summarizing. Crosstab Queries are read
only:

Crosstab Queries
http://www.access.qbuilt.com/html/crosstab_queries.html

A book that you should definately consider purchasing is "SQL Queries for
Mere Mortals", written by John Viescas and Michael Hernandez.
http://www.viescas.com/Info/books.htm#Database Design


Good Luck, and happy reading,

Tom Wickerath, Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Jason O]

Cheers Tom,

They should keep me out of trouble for a while.

Many thanks,

Jason
___