 |
MS Access KB Articles |
|
Please note that this site and its author have no affiliation whatsoever with Microsoft Corporation or their affiliates. Microsoft and Microsoft Office are registered trademarks of the Microsoft Corporation. |
As one would expect, the Microsoft web site is a very good place to look for pages that are about Access, or other related programs. The main problem with the site, however, is the sheer size of it - if you don't know what you are looking for, it is very difficult to find it!! The most useful part of the site is their Knowledge Base. Below is a list of some of the more useful articles on the site (i.e. they seem to answer many questions that are asked by people on the various Access newsgroups). You can also download a help file which has many articles in it (mainly for Access 97) - however, this has not been updated for some time (since 15 October 1999). I'm sure that there are many more that I have not looked at yet and when I do review them, if I think they are of value then I will add them to this page.
| MS Knowledgebase articles pertaining to... | |||
| General | Queries | Forms | Reports |
| Modules | Automation | Bugs and Errors | Sample Databases |
|
General And Database articles | |
|---|---|
|
Page Title |
Page Description |
|
Understanding Relational Database Design | |
|
Database Normalization Basics | |
|
MS Access Shows 100% CPU Utilization During Idle Time | |
|
How to Install Access 97 and Access 2000 on the Same Computer | |
|
Query articles | |
|---|---|
|
Page Title |
Page Description |
|
How to Delete Duplicate Records from a Table | |
|
Parsing Titles Beginning with "A," "An," or "The" | |
|
Form articles | |
|---|---|
|
Page Title |
Page Description |
|
How to Display Image in Form Without Storing It in Table | |
|
Report articles | |
|---|---|
|
Page Title |
Page Description |
|
How to Skip Used Mailing Labels and Print Duplicates | |
|
Every Other Page Blank in Printed Reports (95/97) | |
|
Module articles | |
|---|---|
|
Page Title |
Page Description |
|
How to Convert Currency or Numbers into English Words | |
|
How to Get the Fiscal Year/Month of a Particular Date | |
|
Office/Automation articles | |
|---|---|
|
Page Title |
Page Description |
|
How to Import a Microsoft Windows Cardfile Data File | |
|
Imported MS Excel Carriage Returns Become Vertical Bars | |
|
Sending the Current Record to Word 97 with Automation | |
|
Printing a Microsoft Word Document Using Automation | |
|
How to Import a Works Database into Microsoft Access | |
|
Bugs and Errors | |
|---|---|
|
Page Title |
Page Description |
|
"There is no license" Error Message Starting Microsoft Access | |
|
Certain ISAM Drivers Not Appearing in Files Of Type Box | |
|
Databases | |
|---|---|
|
Here are some sample databases that you can download from Microsoft | |
|
Database Name |
Database Description |
|
A database that contains various useful reports, such as creating a Table of Contents for a report, various label reports, shading every other line. | |
|
A database that contains various useful forms, such as synchronizing two forms, dragging data between two list boxes. | |
|
A database that contains various useful pieces of code, including Date/Time (e.g. days in month), Trigonometrical (e.g. Hyperbolic Cosine), Sorting (various ways of sorting Arrays). | |
|
A database that contains various useful queries. | |
|
A database that contains information about using MS Graph 8 in Access. | |
|
A database that contains samples of how to use the various ActiveX controls supplied with the Office Developer Edition | |
