Noob... where to start

  • Thread starter Thread starter Trent Wilson
  • Start date Start date
T

Trent Wilson

Is there a good site out there for someone that is new to access, and has no
idea where to start?
 
Trent Wilson said:
Is there a good site out there for someone that is new to access, and has
no idea where to start?
Click to expand...

Hi Trent

Access is huge. There's so much to learn; it is not like Word where you open
a new document and start typing. It is not even like Excel where you key
some things in and a formula to add it up.

There's a whole mindset to gain about how to break data down into related
tables. The best way to do this is by looking at some examples to see how
they work. See if you can find the Northind sample database. Open the
Relationships diagram (Database Tools tab of the ribbon in A2007, or Tools
menu in previous versions), and look at how the tables are connected. You
can then move on to see how tables themselves are built, the queries get
values from the tables, the forms act as the interface, and the reports
generate the output.

Here's a basic introduction to what the objects are in Access:
What are these objects? (Tables, Queries, Forms, ...)
at:
http://allenbrowne.com/casu-01.html

Here's a free 8-part tutorial series by Crystal (Microsoft MVP):
http://allenbrowne.com/casu-22.html

And here's a bunch of other Access resouces:
http://allenbrowne.com/tips.html#Beginner

To learn all there is to know about Access will take you a couple of years
of part time work, so be patient with yourself and don't expect to be able
to do everything at once.

All the best
 
Trent, you have found one of the very best resources for Access and Allen
Browne is one of the best Access deveopers there is. You will find that for
the most part, you will get knowledgable help with questions on this site.
There are also many other sites that provide tips, techniques, and sample
databases you can use in construction of your own applications.

When you do ask a question here, you will get the best help if you specify
the version of Access you are using and the version of Windows you are
running it on. Also be specific about your question. If it involves an
error, include the error number in your question.

Questions like "I tried to run this query and it didn't work" don't get much
attention.

In addition to Allen Browne's web site, you will find this site very useful
for noobs:
http://www.accessmvp.com/Strive4Peace/Index.htm

Best of luck to you.
 
Back
Top