Access in This Memo, the Author Will

Access In this memo, the author will provide a project proposal that will demonstrate the need to convert the company over to Microsoft Access from the current configuration with Microsoft Excel in the company's databases. In this short presentation, we will focus on the advantages of Microsoft Access, in particular the ability of the application to be customized to a specific project or situation with a minimum of programming ability. It is fully compatible with almost all of the MS peripherals such as Word, Outlook, etc.

It also has a number of sales applications, as we shall see. Analysis-Advantages of Access over Excel If a person works on a large number of sets of data which have to be sorted, filtered, grouped, and created and put into subgroups upon which to calculate or to extract such values as averages, medians and/or maximums. The clerical process of the creation of groups within other groups and then the performance of calculations on these types of number groups is much more cumbersome in the Excel application.

In essence, Access is better for many business uses because databases are good for the purpose of finding relationships in the data ("Advantages of microsoft," 2012). The chief advantage to this is easy customization. Additionally, flexibility is and advantage with Access. Microsoft realizes that not every person is skilled at making databases. For this reason, the company made basic templates just about any user can go forward with and use right away.

With Microsoft Access, any database can be immediately built from scratch or the simple templates can be tweaked as is needed to fit the company's needs. Rather than having workers to input each and every record every time that a project is started, the application holds many thousands of to revisit whenever needed, saving time. Unfortunately, in Microsoft Excel, one has to start from scratch each time (ibid.). The advantages are obvious.

The application is great because the data is not just there in complete form, but it can be further used alongside other the compatible Microsoft programs such as Word. A worker can simply create a mail merge with the thousands of letters in the database and then join it together with the information in the Access database. Then, all of the contacts will be pulled from Microsoft Access and then dumped into each of the letters separately. Interaction with the email capabilities in Microsoft Outlook is also possible.

Then the clerical staff can simply import their contacts from Microsoft Outlook contact book into Microsoft Access or to export the contact information into the Access application and then save it as a contact in MS Outlook (ibid.). Other Uses to Consider The primary possible use in a time saving fashion would be in the formation and the sorting of invoices and also in sales campaigns with promotional literature, catalogs and product lists.

This is due to the multi-purpose nature of Microsoft Access and its compatibility with almost all Microsoft peripherals. Conclusion As mentioned earlier in the.