|
|
The Microsoft Knowledge Base site
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 the Knowledge Base. Below, I list 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 as well, which has many articles in it - however, this has not been upated for some time (since 15 October 1999).
General Access Database articles
| Page Title | Page Description |
|---|
| Top 10 Knowledge Base articles | A list of the most popular viewed Knowledge Base articles for all versions of Access |
| Q164172 | Understanding Relational Database Design |
| Q100139 | Database Normalization Basics |
| Q160819 | MS Access Shows 100% CPU Utilization During Idle Time |
| Q241141 | How to Install Access 97 and Access 2000 on the Same Computer |
Query articles
| Page Title | Page Description |
|---|
| Q109329 | How to Delete Duplicate Records from a Table |
| Q148463 | Parsing Titles Beginning with "A," "An," or "The" |
Form articles
| Page Title | Page Description |
|---|
| Q148463 | How to Display Image in Form Without Storing It in Table |
Report articles
| Page Title | Page Description |
|---|
| Q95806 | How to Skip Used Mailing Labels and Print Duplicates |
| Q136459 | Every Other Page Blank in Printed Reports (95/97) |
Module articles
| Page Title | Page Description |
|---|
| Q95640 | How to Convert Currency or Numbers into English Words |
| Q132101 | How to Get the Fiscal Year/Month of a Particular Date |
Office/Automation articles
| Page Title | Page Description |
|---|
| Q98797 | How to Import a Microsoft Windows Cardfile Data File |
| Q115576 | Imported MS Excel Carriage Returns Become Vertical Bars |
| Q131583 | Sending the Current Record to Word 97 with Automation |
| Q154569 | Printing a Microsoft Word Document Using Automation |
| Q176201 | How to Import a Works Database into Microsoft Access |
Bugs and Errors
| Page Title | Page Description |
|---|
| Q141373 | "There is no license" Error Message Starting Microsoft Access |
| Q171955 | Certain ISAM Drivers Not Appearing in Files Of Type Box |
Databases
There are also some sample databases that you can download from the Microsoft site:
| Database Name | Database Description |
|---|
| Report Samples | A database that contains various useful reports, such as creating a Table of Contents for a report, various label reports, shading every other line. |
| Form Samples | A database that contains various useful forms, such as synchronizing two forms, dragging data between two list boxes. |
| Code Samples | 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). |
| Query Samples | A database that contains various useful queries. |
| Graph Samples | A database that contains information about using MS Graph 8 in Access. |
| ActiveX Samples | A database that contains samples of how to use the various ActiveX controls supplied with the Office Developer Edition |
Top
HOME |
NEW |
TABLES |
QUERIES |
FORMS |
REPORTS |
GENERAL |
API |
DOWNLOADS |
TUTORIAL |
RESOURCES
E-MAIL
Copyright & Disclaimer
|
| |
