for visiting our section devoted to Microsoft Access. We
will be profiling books and referencing some web-sites.
broken the books area into two sections. General usage includes both
basic books and comprehensive ones. The advanced section covers niche
and specialized books such as development, programming, enterprise,
SQL server, and related topics.
Software programs like
Microsoft Excel, Microsoft Word, and related programs are more
generic in nature than Microsoft Access. That is, you can be
productive with what you know in those program right away.
Then, you can slowly add to your knowledge base. However, with
Microsoft Access, your initial starting point requires a bit more
learning than with
I would say that it is a fair
statement that to build Microsoft Access databases in any useful way
that it takes a college course commitment. This could be
accomplished through self-study by going through a book. Other may
prefer to take a course at a college.
Microsoft Access has four main basic functions to start; tables,
queries, forms, and reports. It is necessary to be familiar with
them all. Your table(s) store the information. Queries extract the
relevant pieces from your data table. Forms offer presentable and
organized data entry templates, or they can be used for viewing
information. Then your reports are for presenting information.
Reports are generally based upon a query extract. Once you master
the basic functions of Microsoft Access you'll discover that its
capabilities are enormous. We offer several book
recommendations to help you get up and running.
Many Community Colleges and Universities offer courses on Access.
You can usually find the following types.
Introduction - Basic concepts and the ability to build simple
to intermediate Access databases.
Intermediate - Building upon introductory concepts, you'll
tap into more advanced techniques and you start to be able to
unleash some of the power that Access offers.
Programming - Using Access programming capabilities. Moving
beyond macros, you'll learn to program using Visual Basic for
Access. If you have already studied Visual Basic programming, the
ideas are directly transferable to Access, and your learning curve
will be greatly reduced. The emphasis in these classes is
programming, and Access is the vehicle to house the code to carry
out the instructions.
Query - Many colleges offer courses on queries, sometimes the
classes are called SQL, structured query language. They may use
Access for purposes of the teaching the class, or perhaps other software such
as Oracle. The query concepts are universal and quite important,
and each database software has slightly different syntax to
use. When you use Microsoft's
query template it makes it easy, and Access writes the SQL for you, often in
a sloppy manner. Taking a class like this you will learn proper
universal concepts. A very useful course indeed.