The MS Access Architecture

Paper Summary:

This paper provides a basic understanding of Microsoft Access, a Relational Database Management System that allows the user to store and maneuver large amounts of information. It discusses the three parts that make up the Access architecture, objects, events, and controls and demonstrates creating tables, relationships, constraints and how to use forms, reports and macros. It shows how from the wizards and the step-by-step instructions for the novice user to the ability to be able to write code for the advanced users, Microsoft access is user friendly to novice and advanced users alike.

From the Paper:

"When a field name is designated as the primary key, the field is unique, and, therefore, that record, in the table, is unique. Two records cannot have the same value in the same primary key field. For example, if there are fields that hold names, addresses, and zip codes, in that table, and the name field is designated as the primary key, then the same name cannot show up in another record. That is what makes that particular record unique. More than one field can be the primary key. If the user is unsure of which field to make the primary key, Access can designate the primary key."

More papers on The MS Access Architecture:

• Research Paper # 44813 : "MS Access 2000"
• Essay # 137460 : "The Profession of Architecture & Tectonic Solutions."
• Essay # 35013 : "The National ITS Architecture"

APA Citation:

MLA Citation: