Microsoft Access
Home Up Microsoft Excel Microsoft Access Web Design

 

General Usage
Advanced

 

Book reviews of Microsoft Access

 

Microsoft Access BooksMicrosoft Access Books

Microsoft Access

Microsoft Access BooksMicrosoft Access Books

 
Book reviews of Microsoft Access

Microsoft Access

Thanks for visiting our section devoted to Microsoft Access. We will be profiling books and referencing some web-sites.  

We have 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.

Microsoft Access Books
General Usage Advanced

Introductory Comment
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 those programs.

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.  

Access Basics
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.

School
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. 
Microsoft Access Books
General Usage ] Advanced ]

Book reviews of Microsoft Access

Microsoft Access web-sites

Book reviews of Microsoft Access
Official Microsoft Site Microsoft's  Access  resource page.
Resources This website has lots of Microsoft Access resources and links to many websites.
Java and Access This website provides information on integrating Microsoft Access with Java
Book reviews of Microsoft Access
Book reviews of Microsoft Access