Microsoft Access is part of the Office suite of productivity products by Microsoft. Access is a DBMS package from Microsoft. It is one of the products in Microsoft Office suite that is most widely used around the world. The reason behind is that Access is used for building database applications. Microsoft Access provides superfluity of new features that are designed to help you use the internet and develop (WWW) World Wide Web applications.
Over the years, Microsoft has put a lot of effort into making Access not only one of the most powerful consumer database programs available, but also one of the easiest to learn and use. Because Access is part of Microsoft Office Suite, you can use many of the techniques you know from using other Office programs, such as Microsoft Word and Excel, when using Access. For example, you can use familiar commands, buttons, and keyboard shortcuts to open and edit the information in Access tables. And because Access is integrated with other members of the suite, you can easily share information between Access and Word, Excel, or other programs.
As of Feb. 2007, the latest version is Microsoft Access 2007.
Microsoft Access 2007
Some of the new features introduced in Microsoft Access 2007:
- New professional templates -- Microsoft Access 2007 includes a number of fully featured templates designed to fit your needs professionally. Using these professionally designed templates you can modify the data in your way, making it much easier and faster.
- New look and User interface -- Microsoft Access 2007 includes a complete new look along with a new user interface whereby a user can change the view of the page according to his/her needs. The main options for changing the view are Form view, Datasheet view, Layout view and Design view. Each view serves its own purpose making it easier for you to work much better and faster.
- Easily make design changes -- Whether you are making a new database or you are making a database from a template, you will have to add forms, tables and more to make you database meaningful. With Microsoft Access 2007, you can easily add forms, tables, etc. to database with single click of a mouse. The process of adding objects to database is very simple in Microsoft Access 2007.
- Flexibility of modifying or viewing data expanded -- Microsoft Access 2007 has changed the way you view, make changes or expand your data by adding new features like selecting your data with a calendar button, using Multivalue fields, adding attachments, etc.
Hardware Requirements for Microsoft Access 2007
Before you think of installing Microsoft Access 2007, you need to make sure that your computer meets the following requirements as suggested by Microsoft:
|Processor||500 MHz||more than 500 MHz|
|Memory||256 MB||512 MB or higher|
|Hard Disk||1.5 GB of available space||1.5 GB of available space|
|Video||Resolution of 1024 X 768 or higher||Resolution of 1024 X 768 or higher|
Although Microsoft has released a version of most of it's Office Suite for Macintosh, they have never implemented a version of Microsoft Access for Mac. Mac users instead use a number of different DMBS applications, most notably FilemakerPro.
The Microsoft Office Suite
Microsoft Office contains many tools for business and personal productivity. These include a word processor (Word), spreadsheet (Excel), database management software (Access), and software for making dynamic presentations (PowerPoint).