Analysis Memorandum

1532 Words7 Pages
Running head: Analysis Memorandum

Analysis Memorandum
Steven Aran
University of Phoenix
EDTC 550
Information Technology
Janet Luch (FAC)

Introduction This is an analysis memorandum proposing the use of Microsoft Access databases within our Security Division’s infrastructure. Many security managers are relying heavily on the use of Microsoft Excel spreadsheets in order to keep track of their personnel, security violations, inspection programs and training. While spreadsheets are effective means for complex calculations they are also limited in that they basically fall short in showing the relational qualities of security data in relationship to particular fields and queries. Not only do they fall short in
…show more content…
With Microsoft Access you can create a query which links tables and their relationships. This allows for better analysis of your data, thus making Microsoft Access a powerful tool in which to analyze critical security data. Not only can you analyze critical security data you can perform simple calculations in queries. For example, you can calculate when an individual’s next personnel security reinvestigation is due. When you type a date into a generated form or table, you can add a column to a query which will automatically calculate the next periodic reinvestigation date. You can later create a form which includes the query’s calculated column. After you type in a date, the adjusted date appears automatically. With forms, you can ease the input of data into your tables. You can set the values of each field or column, such as text, number, date, yes or no, hyperlink, as well as other options. You can also create pull-down menus in which the user can choose an input rather than type one. This assists the database operator by giving quick choices to fields like States and Countries. Forms also comes with input masks, which allow for the easy input of fields like dates, phone number, social security numbers, zip codes and the like. The form will not accept any errors input. You can also create icon driven forms. In other words, you can click icons on your form to

More about Analysis Memorandum

Get Access