Articles: MS Access

Repairing a Damaged MS Access Database

In short, MS Access can store vast amounts of data. Often companies segment their data up into large numbers of database. Independently these databases can be used to store vast amounts of data. However, I've been involved in many centralized projects that consolidate MS access databases into a central Oracle database. Because Oracle allows data to be partitioned, no lost of performance is realized. Middle layer objects take advantage of the data partitioning returning data in remarkably fast speeds. more

Microsoft Access Object Naming Conventions

When you create an Access database you should have a standard naming convention in mind. Conventions will vary by product, vendor, and most importantly perhaps, your company or organization. What follows is one that is common in the Microsoft Access community. more

Converting an ERD to a Physical Database

The purpose of this article is to provide the student with an approach to converting an Entity Relationship Diagram (ERD) into a physical database. It is is a top down approach modeled after Teorey and Kroenke. It assumes the database implementor is going to be using the Microsoft Access GUI tool to generate the DDL "behind the scenes" and is familiar with this tool. If coded by hand many steps would be combined. In fact, the same is true with a GUI, but thinking of it as four steps can still be helpful. more

Microsoft Access Forms

Like many desktop database application development tools, Microsoft Access has very robust facilities for creating forms. For reporting applications you will use yourself you may not need many forms. But if you are setting up a database for someone else to use you will want to create a set of forms for data entry, report selection, etc.
more