The MS Access Architecture

A description of MS Access, Microsoft’s standard database package.

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