Essay - The MS Access Architecture Microsoft Access is a Relational Database...

The MS Access Architecture

Microsoft Access is a Rel*****tional Database Management System (Boodey & Moseley, 1997, pp. 829) that allows the user to store and maneuver large amounts of information. There are three parts that make up the Access architecture. Those ***** are objects, events, and controls.

Objects are anything that can be named such as tables, queries, forms, reports, macros, ***** modules. The tables in Access allow the user to ***** data. Forms are available to format data ***** a way that is e*****y to view or change. The data can be collected and viewed as a rep*****t.

Tables, forms, and ***** ***** be created manually or, for the novice user, Wizards are available.

Queries are available to the ***** to find or sort in*****ion. Report ***** forms can contain controls. A control is an object that contains data such as a *****ggle or option button.

Queries are available to ask questions of ***** ***** ***** is entered in multiple tables. Queries can be used to collect entries from different tables and *****corporate that information onto one datasheet. Also, queries ***** be *****ed to gather ***** about the data entered into the *****. For example, if the user wants to know how many people, who are in one or ***** tables, live in a certain zip code, the user can query to find the answer.

Other features that ***** up the Microsoft Access database are macros and modules. Macros ***** modules respond to events ***** any change in a state of an object. ***** and modules can respond to a command but*****n being pushed or a window opening and closing. Macros ***** modules can be activated if an error occurs as well. ***** make it e*****y for ***** ***** to automate database tasks, such as validating data in a record before it is saved or producing message boxes.

Modules contain programming ***** written in an Access ********** using the Visual Basic Edit*****. ***** user can create global modules or f*****m and report modules. Global ***** ***** be ***** in all parts ***** the application. The form and report module is only available when a particular form or rep*****t is open.

Creat*****g Tables and Relationships

As stated above, ***** user ***** able to create multiple ***** either manually or by using the Wizards available. To design a table using the Wizards, on ***** opening menu, simply click on "blank Access database," give it a file n*****me, and click "Create." This will provide another menu for the user to ***** ***** "Create table ***** using Wizard." ***** user can make selections and follow instructions based on the user's needs.

Ano*****r ***** open ***** the user is to ***** a ***** in d*****tasheet view. Tables ***** made up of records, and records are made ***** of fields (Boodey & Moseley, *****, pp. 851). The datasheet ***** requires fill*****g in data under numbered fields. In this option, the ***** types and properties are already defined. ***** user can simply fill in the data,