News :

Categories

Create well-organised documents
Manage personal finances
Upload and share documents online

Manage your business
Connect with customers
Organise your life

Bestsellers

	Microsoft Access 2010 $290.00 $69.49 Save 76% Off
	Microsoft Access 2007 $229.95 $69.00 Save 70% Off
	Microsoft Office Professional 2010 $349.99 $109.49 Save 69% Off
	Microsoft Outlook 2010 $139.99 $69.49 Save 50% Off
	Microsoft Publisher 2010 $139.99 $69.49 Save 50% Off
	Microsoft Office Professional Plus... $399.00 $119.49 Save 70% Off

Reviews [more]

Microsoft Office is the best office products! Microsoft...

Home :: News

Features of Microsoft Access

by Administrator | post a comment

Microsoft Access, also called Microsoft Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. On May 12 2010, the current version of Microsoft Access 2010 was released by Microsoft Office 2010; Microsoft Access 2007 was the prior version.

The main idea of Access originally was to help customers so that they can "access" info from any resource. Additional features including: the import and export of data to many formats including Excel, Outlook, ASCII, dBase, Paradox, FoxPro, SQL Server, Oracle, ODBC, etc. Additionally, it has the ability to link info around its current location and employ it with observing, querying, modifying, along with credit reporting. This enables the present information to improve while making sure Access uses the most recent data. It can perform heterogeneous joins between data sets stored across different platforms. Access is often used by people downloading data from enterprise level databases for manipulation, analysis, and reporting locally.

An obivious advantage for Access is its compatibility with SQL (structured query language) ? queries can be viewed graphically or edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modules to manipulate Access tables. Users can mix and use both VBA and "Macros" for programming forms and logic and offers object-oriented possibilities. VBA can also be included in queries.Microsoft Access offers parameterized queries.These queries and Access tables can be referenced from other programs like VB6 and .NET through DAO or ADO. From Microsoft Access, VBA can reference parameterized stored procedures via ADO.

Unlike client?server relational database management systems (RDBMS), Microsoft Access does not implement database triggers, stored procedures, or transaction logging. Access 2010 includes table-level triggers and stored procedures built into the ACE data engine. Hense a Client-server database system is not a requirement for using stored procedures or table triggers with Access 2010. Tables, queries, Forms, reports and Macros can now be developed specifically for web base application in Access 2010.

Being familiar with the functions of Microsoft Office Access,we can better use Access for data arrangement.

News for Tuesday 20 March, 2012

When do you need Access

View all news for Tuesday 20 March, 2012 on one page