What is MS Access?

[john009]

Hi friends,
I just want to know that what is MS Access? How to use it effectively?
Thanks in advance for any sharing.

[mariawarn]

MS Access is a tool of Microsoft Office. It is a relational database management system with the combination of Microsoft jet database engine and GUI(Graphical User Interface). There are many versions of MS access like MS Access 2003, 2007 and latest one is MS access 2010. I prefer most MS access 2007.

[trisswines]

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis. Microsoft Access can help you overcome the limitations found when trying to manage large amounts of information in Microsoft Excel or other spreadsheet applications.

[hiseredman]

Ms Access (Microsoft Access) is a database software. Ms Access is very efficient database. You attached very easily with SQL queries, VB (visual basic) forums and much more benefits thats provide you any database software. Ms Access provide us graphical creating solution.

[Johnkarner]

MS Access is a tool for Microsoft Office. It is a combination of relational database management system in the Microsoft Jet database engine and the GUI (Graphical User Interface). There are many versions of MS Access including MS Access 2003, 2007 and the last is MS Access 2010. I prefer the majority of MS Access 2007.

[ptrjnshrksn1]

Ms Excel is database.Easily we can maintain the all the data in data management system and put the condition if you require and it is a part of Ms office.it also provide the some other facilities like sum,multi,division etc.

[nobita_deptrai]

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 Microsoft Office suite of applications, included in the Professional and higher editions or sold separately. In mid-May 2010, the current version of Microsoft Access 2010 was released by Microsoft in Office 2010; Microsoft Office Access 2007 was the prior version.
Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.

[curious788]

Ms Access is a useful tool for database management. It allows you to store your records and manage them with ease by guiding you with its user friendly wizards. You can save your data in tables use it in forms, queries, reports etc. It has taken database management to a different level.

[manimoor]

Hi..i provides MS Access definitions,

MS Access is a Database Management System. It handles data management tasks the same way as MS Word handles document management and MS Excel handles statistics ...

A database is a collection of objects that allow you to store data, organize it and retrieve it in any way you want.

What this means is that, with Microsoft Access you create structures called tables that allow you to organize the data so that it's easy to find later, you create forms that let you input the data into the tables and then you create reports that print selected information from the tables.

For example, if you run a store, you would create a Customers table, a Products table and an Invoices table. Then, when you open an account for a new customer you would have a Customer form to input a customer's data into the Customers table and an Order form to input the purchase information. Later, you could print any number of Sales reports, grouping and arranging the information from the Invoices, Customers and Products tables to analyze daily or weekly or monthly sales in all kinds of combinations.

[suba]

What is MS Access?

Microsoft Access is an information management tool that helps you store information for reference, reporting, and analysis.
Microsoft Access can help you overcome the limitations found when trying to manage large amounts of information in Microsoft Excel or other spreadsheet applications.
Microsoft Access provides users with one of the simplest and most flexible DBMS solutions on the market today.
Regular users of Microsoft products will enjoy the familiar Windows "look and feel" as well as the tight integration with other Microsoft Office family products.
An abundance of wizards lessen the complexity of administrative tasks and the ever-present Microsoft Office Helper (you know… the paper clip!) is available for those who care to use it.