Home Documents & Data Database Design IT Support Web Design Graphics & Maps About Contact

AMD Web

 

Documents & Data: Integration

Most offices use Microsoft Office software with Word, Excel,Powerpoint, Outlook and Access available. Using the Microsoft Access database as the central core of these business tools (see later) it is possible to make the most out of a company's stored data.

Microsoft Access is commonly classified as a database, when in fact it actually performs two key roles. First it is a database where data is stored in tables and transferred to forms & reports by using queries. Second it is also a graphical user interface and programming environment where, with the use of the VBA software we can make comprehensive 'intelligent' applications to make the most of storing and using the data.

For instance, using Microsoft Access's software it is possible to open a Word document , edit it and save it - all from the push of a button. Given a customer list and a number of standard document templates the range of possible applications is evident. Similarly, mail merge functions can be used for mass mailing - again all from a click of a button.

Access used in office based applications