30 Facts About Microsoft Access

Microsoft Access is a database management system from Microsoft that combines the relational Access Database Engine with a graphical user interface and software-development tools .

Microsoft Access was the first mass-market database program for Windows.

Microsoft Access 2007 introduced File Attachment field, which stored data more efficiently than the OLE field.

Microsoft Access 2010 introduced a new version of the ACCDB format supported hosting Access Web services on a SharePoint 2010 server.

Microsoft Access 2013 offers traditional Access desktop applications plus a significantly updated SharePoint 2013 web service.

Related searches

Microsoft Access includes a query interface, forms to display and enter data, and reports for printing.

Microsoft Access is designed to scale to support more data and users by linking to multiple Access databases or using a back-end database like Microsoft SQL Server.

The Jet Database Engine, core to Microsoft Access, can be accessed through technologies such as ODBC or OLE DB.

Microsoft Access 2010 allows databases to be published to SharePoint 2010 web sites running Microsoft Access Services.

ADE versions of an Microsoft Access database are used when end-user modifications are not allowed or when the application's source code should be kept confidential.

Microsoft Access has report creation features that can work with any data source that Microsoft Access can access.

Original concept of Microsoft Access was for end users to be able to access data from any source.

Microsoft Access is often used by people downloading data from enterprise level databases for manipulation, analysis, and reporting locally.

Microsoft Access 2010 includes table-level triggers and stored procedures built into the ACE data engine.

NET web forms can query a Microsoft Access database, retrieve records and display them on the browser.

SharePoint Server 2010 via Microsoft Access Services allows for Microsoft Access 2010 databases to be published to SharePoint, thus enabling multiple users to interact with the database application from any standards-compliant Web browser.

Microsoft Access 2013 offers the ability to publish Microsoft Access web solutions on SharePoint 2013.

Rather than using SharePoint lists as its data source, Microsoft Access 2013 uses an actual SQL Server database hosted by SharePoint or SQL Azure.

Microsoft offers free runtime versions of Microsoft Access which allow users to run an Access desktop application without needing to purchase or install a retail version of Microsoft Access.

Query development, Microsoft Access offers a "Query Designer", a graphical user interface that allows users to build queries without knowledge of structured query language.

Microsoft Access allows users to view and manipulate the SQL code if desired.

Any Microsoft Access table, including linked tables from different data sources, can be used in a query.

In Microsoft Access 2007, enhanced macros included error-handling and support for temporary variables.

Microsoft Access 2007 introduced embedded macros that are essentially properties of an object's event.

Many Microsoft Access developers use the Leszynski naming convention, though this is not universal; it is a programming convention, not a DBMS-enforced rule.

Related searches

In July 2011, Microsoft acknowledged an intermittent query performance problem with all versions of Access and Windows 7 and Windows Server 2008 R2 due to the nature of resource management being vastly different in newer operating systems.

The "front-end" Microsoft Access application is distributed to each user's desktop and linked to the shared database.

Microsoft Access has two built-in utilities, Database Splitter and Linked Table Manager, to facilitate this architecture.

Finally, some Microsoft Access databases are completely replaced by another technology such as ASP.

Microsoft Access applications can be made secure by various methods, the most basic being password access control; this is a relatively weak form of protection.