What is the purpose of Microsoft Office Access?

It is a data base managing software.

You may use it to create a data base, enter data into your data base, search your data base, and setup various reports using data from your data base ...

If you have a list of information it is called a database. If it's a simple list, like a list of all your friends and family, with their addresses and telephone numbers, you can maintain it in a spreadsheet or even a word processor.

However, when the list becomes more complex, for example a database of stock, suppliers, customers, purchases and sales it is too complex for a spreadsheet and needs a dedicated database program, which is what Access is.

The information is held in a number of different tables that are linked to each other in a set of relationships. Hence Access and similar programs are called relational databases.

Microsoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software development tools. It is a member of the 2007 Microsoft Office system.

-WIK yo...

The purpose of Access 2007 is pain, misery, and the torment of souls.

The purpose of Microsoft Access is to store and retrieve data. This is true of any Database Management System. Access gives you the power and tools of a RDMS (Relational Database Management System) on your desktop for a relatively low price.

A database management program to store data in a more or less organized way with the possiblity to make relations between several elements of your information.

For example: You make a database of your media and divide it in books, audio CD's, CD-ROM's and DVD's.
Books you can relate on writer, DVD's on director etc.
On top of it you can search on (part[s] of) titles via so called SELECT statements.

It's a database application.