This article needs additional citations for verification. Please help improve this article by adding reliable references. Unsourced material may be challenged and removed. (August 2006)

Microsoft Office Access
Office Access 2007 running on Microsoft Windows Vista.
Developed by	Microsoft
Latest release	12.0.6211.1000 (2007 SP1) / December 11, 2007
OS	Microsoft Windows
Genre	RDBMS
License	Proprietary EULA
Website	Microsoft Office Access Homepage

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. Image File history File links No higher resolution available. ... Image File history File links Download high-resolution version (992x759, 186 KB) A screenshot of Office Access 2007. ... For other uses, see Software developer (disambiguation). ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... Code complete redirects here. ... An operating system (OS) is a software that manages computer resources and provides programmers with an interface used to access those resources. ... Windows redirects here. ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ... A software license is a legal agreement which may take the form of a proprietary or gratuitous license as well as a memorandum of contract between a producer and a user of computer software. ... Proprietary software is software with restrictions on copying and modifying as enforced by the proprietor. ... A software license is a type of proprietary or gratiuitious license as well as a memorandum of contract between a producer and a user of computer software — sometimes called an End User License Agreement (EULA) — that specifies the perimeters of the permission granted by the owner to the user. ... A website (alternatively, web site or Web site) is a collection of Web pages, images, videos or other digital assets that is hosted on one or more web servers, usually accessible via the Internet. ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ... Microsoft Corporation, (NASDAQ: MSFT, HKSE: 4338) is a multinational computer technology corporation with global annual revenue of US$44. ... Jet is the database engine behind Microsofts Access. ... GUI redirects here. ... Microsoft Office is an office suite from Microsoft for Microsoft Windows and Apple Mac OS X operating systems. ...

Access can use data stored in Access/Jet, Microsoft SQL Server, Oracle, or any ODBC-compliant data container (including MySQL and PostgreSQL). Skilled software developers and data architects use it to develop application software. Relatively unskilled programmers and non-programmer "power users" can use it to build simple applications. It supports some object-oriented techniques but falls short of being a fully object-oriented development tool. For other uses, see Data (disambiguation). ... Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. ... The term Oracle database may refer either to the database management system (DBMS) software released by Oracle Corporation as Oracle RDBMS, or to any of the individual databases managed by such software. ... Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). ... MySQL (pronounced (IPA) , my S-Q-L[1]) is a multithreaded, multi-user SQL database management system (DBMS)[2] which has, according to MySQL AB, more than 10 million installations. ... PostgreSQL is a free software object-relational database management system (ORDBMS), released under a BSD-style license. ... For other uses, see Software developer (disambiguation). ... A Data Architect is a job title associated with a person within an organization responsible for making sure the organizations strategic goals are optimized through the use of enterprise data standards. ... Application software is a subclass of computer software that employs the capabilities of a computer directly and thoroughly to a task that the user wishes to perform. ... A programmer or software developer is someone who programs computers, that is, one who writes computer software. ... Object-oriented programming (OOP) is a computer programming paradigm in which a software system is modeled as a set of objects that interact with each other. ...

Access was also the name of a communications program from Microsoft, meant to compete with ProComm and other programs. This proved a failure and was dropped.^[1] Years later Microsoft reused the name for its database software. Datastorm was a computer software company that existed from 1986 until 1996. ...

History

Access 1.1 manual cover

Access version 1.0 was released in November 1992, followed in May of 1993 by an Access 1.1 release to improve compatibility with other Microsoft products. Image File history File links Download high-resolution version (600x726, 202 KB) Book (ser manual) cover used in an article to describe the product is believed to constitute fair use. ... Image File history File links Download high-resolution version (600x726, 202 KB) Book (ser manual) cover used in an article to describe the product is believed to constitute fair use. ...

Microsoft specified the minimum operating system for Version 2.0 as Microsoft Windows v3.0 with 4 MB of RAM. 6 MB RAM was recommended along with a minimum of 8 MB of available hard disk space (14 MB hard disk space recommended). The product was shipped on seven 1.44 MB diskettes. The manual shows a 1993 copyright date.

The software worked well with very large records sets but testing showed some circumstances caused data corruption. For example, file sizes over 700 MB were problematic (note that most hard disks were smaller than 700 MB at the time this was in wide use). The Getting Started manual warns about a number of circumstances where obsolete device drivers or incorrect configurations can cause data loss.

Access's initial codename was Cirrus; the forms engine was called Ruby. This was before Visual Basic - Bill Gates saw the prototypes and decided that the BASIC language component should be co-developed as a separate expandable application, a project called Thunder. The two projects were developed separately as the underlying forms engines were incompatible with each other; however, these were merged together again after VBA. This article is about the Visual Basic language shipping with Microsoft Visual Studio 6. ... For other persons named Bill Gates, see Bill Gates (disambiguation). ... This article is about the programming language. ... Visual Basic for Applications (VBA) is an implementation of Microsofts Visual Basic, an event driven programming language and associated integrated development environment (IDE) which is built into most Microsoft Office applications. ...

Uses

Access is used by small businesses, within departments of large corporations, and by hobby programmers to create ad hoc customized desktop systems for handling the creation and manipulation of data. Access can be used as a database for basic web based applications hosted on Microsoft's Internet Information Services and utilizing Microsoft Active Server Pages ASP. Ad hoc is a Latin phrase which means for this [purpose]. It generally signifies a solution that has been tailored to a specific purpose, such as a tailor-made suit, a handcrafted network protocol, and specific-purpose equation and things like that. ... IIS (Microsoft Internet Information Services or Server) is a set of Internet based services for Windows machines. ... Active Server Pages (ASP) is Microsofts first server-side script engine for dynamically-generated web pages. ...

Some professional application developers use Access for rapid application development, especially for the creation of prototypes and standalone applications that serve as tools for on-the-road salesmen. Access does not scale well if data access is via a network, so applications that are used by more than a handful of people tend to rely on Client-Server based solutions.^{[citation needed]} However, an Access "front end" (the forms, reports, queries and VB code) can be used against a host of database backends, including JET (file-based database engine, used in Access by default), Microsoft SQL Server, Oracle, and any other ODBC-compliant product. Rapid application development (RAD), is a software development process developed initially by James Martin in the 1980s. ... Scale in the computing field is used as a verb. ... See DBMS for a shorter list of “typical”, representative database management systems. ... This article is about the Visual Basic language shipping with Microsoft Visual Studio 6. ... Open Database Connectivity (ODBC) is a standard software API for connecting to database management systems (DBMS). ...

Features

One of the benefits of Access from a programmer's perspective is its relative compatibility with SQL (structured query language) —queries may be viewed and edited as SQL statements, and SQL statements can be used directly in Macros and VBA Modules to manipulate Access tables. Users may mix and use both VBA and "Macros" for programming forms and logic and offers object-oriented possibilities. SQL (IPA: or ) is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ... Visual Basic for Applications (VBA) is an implementation of Microsofts Visual Basic, an event driven programming language and associated integrated development environment (IDE) which is built into most Microsoft Office applications. ...

MSDE (Microsoft SQL Server Desktop Engine) 2000, a mini-version of Microsoft SQL Server 2000, is included with the developer edition of Office XP and may be used with Access as an alternative to the Jet Database Engine. MSDE stands for Microsoft Data Engine, Microsoft Desktop Engine or Microsoft SQL Server Desktop Engine. ... Jet is the database engine behind Microsofts Access. ...

Unlike a modern RDBMS, the Jet Engine implements database triggers and stored procedures in a non-standard way. Stored Procedures are implemented in VBA, and Triggers are only available from embedded Forms. Both Triggers and Stored procedures are only available to applications built completely within the Access database management system. Client applications built with VB or C++ are not able to access these features. Starting in Access 2000 (Jet 4.0), there is a new syntax for creating queries with parameters, in a way that looks like creating stored procedures, but these procedures are still limited to one statement per procedure.[1] Microsoft Access does allow forms to contain code that is triggered as changes are made to the underlying table (as long as the modifications are done only with that form), and it is common to use pass-through queries and other techniques in Access to run stored procedures in RDBMSs that support these.[[2]] A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ... Jet is the database engine behind Microsofts Access. ... A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. ... A stored procedure is a subroutine available to applications accessing a relational database system. ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ...

In ADP files (supported in Access 2000 and later), the database-related features are entirely different, because this type of file connects to a MSDE or Microsoft SQL Server, instead of using the Jet Engine. Thus, it supports the creation of nearly all objects in the underlying server (tables with constraints and triggers, views, stored procedures and UDF-s). However, only forms, reports, macros and modules are stored in the ADP file (the other objects are stored in the back-end database).

Development

Access allows relatively quick development because all database tables, queries, forms, and reports are stored in the database. For query development, Access utilizes the Query Design Grid, a graphical user interface that allows users to create queries without knowledge of the SQL programming language. In the Query Design Grid, users can "show" the source tables of the query and select the fields they want returned by clicking and dragging them into the grid. Joins can be created by clicking and dragging fields in tables to fields in other tables. Access allows users to view and manipulate the SQL code if desired.

The programming language available in Access is, as in other products of the Microsoft Office suite, Microsoft Visual Basic for Applications. Two database access libraries of COM components are provided: the legacy Data Access Objects (DAO), which was superseded for a time (but still accessible) by ActiveX Data Objects (ADO); however (DAO) has been reintroduced in the latest version, Microsoft Access 2007. Microsoft Office is an office suite from Microsoft for Microsoft Windows and Apple Mac OS X operating systems. ... Visual Basic for Applications (VBA) is an implementation of Microsofts Visual Basic, an event driven programming language and associated integrated development environment (IDE) which is built into most Microsoft Office applications. ... Component Object Model (COM) is a platform for software componentry introduced by Microsoft in 1993. ... Data Access Objects (DAO) were an object oriented interface created by Microsoft which allowed early versions of Microsoft Access and Visual Basic the Jet database engine. ... // Microsoft ActiveX Data Objects (ADO) is a set of Component Object Model objects for accessing data sources. ...

Many developers who use Access use the Leszynski naming convention, though this is not universal; it is a programming convention, not a DBMS-enforced rule.^[2] Except in VBA, it is also made redundant by the fact that Access categorises each object automatically and always shows the object type, by prefixing Table: or Query: before the object name when referencing a list of different database objects. The Leszynski Naming Convention (or LNC) is a way of naming objects in programming and database development fields. ...

Microsoft Access can be applied to small projects but scales poorly to larger projects involving multiple concurrent users because it is a desktop application, not a true client-server database. When a Microsoft Access database is shared by multiple concurrent users, processing speed suffers. The effect is dramatic when there are more than a few users or if the processing demands of any of the users are high. Access includes an Upsizing Wizard that allows users to upsize their database to Microsoft SQL Server if they want to move to a true client-server database. It is recommended to use Access Data Projects for most situations. Scale in the computing field is used as a verb. ... Upsizing is the term coined by Microsoft to describe the process of upgrading Microsoft Access Database to a Microsoft SQL Server. ... Microsoft SQL Server is a relational database management system (RDBMS) produced by Microsoft. ...

Since all database queries, forms, and reports are stored in the database, and in keeping with the ideals of the relational model, there is no possibility of making a physically structured hierarchy with them.

One recommended technique is to migrate to SQL Server and utilize Access Data Projects. This allows stored procedures, views, and constraints - which are greatly superior to anything found in Jet. Additionally this full client-server design significantly reduces corruption, maintenance and many performance problems.

Access 2003 icon

Access allows no relative paths when linking, so the development environment should have the same path as the production environment (though it is possible to write a "dynamic-linker" routine in VBA that can search out a certain back-end file by searching through the directory tree, if it can't find it in the current path). This technique also allows the developer to divide the application among different files, so some structure is possible. Image File history File links MSAccess_2003. ... Image File history File links MSAccess_2003. ... Visual Basic for Applications (VBA) is an implementation of Microsofts Visual Basic, an event driven programming language and associated integrated development environment (IDE) which is built into most Microsoft Office applications. ...

Protection

If the database design needs to be secured to prevent from changes, Access databases can be locked/protected (and the source code compiled) by converting the database to an .MDE file. All changes to the database structure (tables, forms, macros, etc.) need to be made to the original MDB and then reconverted to MDE. A compiler is a computer program that translates a computer program written in one computer language (called the source language) into an equivalent program written in another computer language (called the output or the target language). ...

Some tools are available for unlocking and 'decompiling', although certain elements including original VBA comments and formatting are normally irretrievable. A decompiler is the name given to a computer program that performs the reverse operation to that of a compiler. ...

File extensions

Microsoft Access saves information under the following file formats: A file format is a particular way to encode information for storage in a computer file. ...

Versions

There are no Access 3.0 to 6.0 because the Windows 95 version was launched with Word 7. All of the Office 95 products have OLE 2 capabilities, and Access 7 shows that it was compatible with Word 7. An operating system (OS) is a software that manages computer resources and provides programmers with an interface used to access those resources. ... This article does not cite any references or sources. ... This article does not cite any references or sources. ... Microsoft Office is an office suite from Microsoft for Microsoft Windows and Apple Mac OS X operating systems. ... Windows 95 is a consumer-oriented graphical user interface-based operating system. ... Microsoft Office 2007 (officially called 2007 Microsoft Office system) is the most recent version of Microsofts productivity suite. ... Windows 95 is a consumer-oriented graphical user interface-based operating system. ... Object Linking and Embedding (OLE) is a technology that allows embedding and linking to documents and other objects, developed by Microsoft. ...

Competing software

• Amiga Datastore
• Alpha Five
• Borland Paradox
• Datawasp
• dBase
• FileMaker Pro (formerly Claris Filemaker)
• Kexi
• Lotus Approach
• NeoOffice
• OpenOffice.org Base
• Oracle XE
• Sun StarBase
• SQLite
• Sybase PowerBuilder
• MySQL
• PostgreSQL
• Omnis Studio

Alpha Five is a database application produced by Alpha Software, similar to Microsoft Access and Filemaker Pro. ... Paradox is a relational database management software originally released from Ansa-Software. ... dBASE III The correct title of this article is dBASE. The initial letter is capitalized because of technical restrictions. ... FileMaker Pro is a cross platform database application from FileMaker Inc, known for its combination of power and ease of use. ... Claris was a computer software company formed as a spin-off from Apple Computer in 1987. ... In computing, Kexi is an integrated data management application. ... Wikipedia does not have an article with this exact name. ... ‹ The template below (Citations missing) is being considered for deletion. ... OpenOffice. ... Oracle Corporation (NASDAQ: ORCL) is one of the major companies developing database management systems (DBMS), tools for database development, middle-tier software, enterprise resource planning software (ERP), customer relationship management software (CRM) and supply chain management (SCM) software. ... StarOffice is Sun Microsystems proprietary office suite software package. ... SQLite is a mostly ACID-compliant relational database management system contained in a relatively small (~500kb) C programming library. ... MySQL (pronounced (IPA) , my S-Q-L[1]) is a multithreaded, multi-user SQL database management system (DBMS)[2] which has, according to MySQL AB, more than 10 million installations. ... PostgreSQL is a free software object-relational database management system (ORDBMS), released under a BSD-style license. ... Omnis Studio is a Rapid Application Development (RAD) tool that allows programmers and application developers to create Enterprise level and Web-based applications for Windows, Linux, Solaris, and Mac OS X personal computers across all business sectors. ...

Database protection

• How to make design changes to an .MDE file

This article was originally based on material from the Free On-line Dictionary of Computing, which is licensed under the GFDL. Microsoft Office is an office suite from Microsoft for Microsoft Windows and Apple Mac OS X operating systems. ... Microsoft Office Accounting (formerly Small Business Accounting) is Microsofts accounting software targeted towards small business customers. ... Microsoft Office Communicator is an integrated enterprise communications client, enabling information workers to communicate in real time through the use of instant messaging (IM), voice over Internet protocol (VoIP) and videoconferencing and could be applied to when speaking with company directors and other persons of influence in a corporation. ... Microsoft Entourage is an e-mail client and personal information manager developed by Microsoft for Mac OS 8. ... Equation Editor is a legacy formula editor developed by Design Science that allows users to construct math and science equations in a WYSIWYG environment. ... Microsoft Excel (full name Microsoft Office Excel) is a spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS. It features calculation and graphing tools which, along with aggressive marketing, have made Excel one of the most popular microcomputer applications to date. ... Microsoft Groove - Wikipedia, the free encyclopedia /**/ @import /skins-1. ... Microsoft InfoPath (full name Microsoft Office InfoPath) is an application used to develop XML-based data entry forms, first released as part of the Microsoft Office 2003 suite of programs in late 2003 and later released as part of Microsoft Office 2007. ... Microsoft InterConnect, or Microsoft Office InterConnect, is a personal information manager application sold by Microsoft Japan, a division of Microsoft. ... Three maps generated by MapPoint North America 2001 (outside the detailed dataset), Encarta 2005 (not very detailed) and Microsoft AutoRoute 2004 (highly detailed). ... Microsoft Office OneNote, usually referred to as Microsoft OneNote, is a tool for notetaking, information gathering, and multi-user collaboration by Microsoft. ... For the e-mail and news client bundled with certain versions of Microsoft Windows, see Outlook Express. ... Power point redirects here. ... Microsoft Project (or MSP) is a project management software program developed and sold by Microsoft which is designed to assist project managers in developing plans, assigning resources to tasks, tracking progress, managing budgets and analyzing workloads. ... Office Publisher 2003 Microsoft Office Publisher 2007 Editing Interface Microsoft Office Publisher (previously and commonly known as Microsoft Publisher) is a desktop publishing application from Microsoft. ... Microsoft SharePoint Designer (full name Microsoft Office SharePoint Designer) is a WYSIWYG HTML editor and general web design program from Microsoft, replacing Microsoft Office FrontPage. ... This article is about a software application. ... Microsoft Word is Microsofts flagship word processing software. ... Microsoft Office Communications Server 2007 , OCS 2007, is an enterprise real-time communications server, providing instant messaging, presence, audio-video conferencing and web conferencing functionality. ... Microsoft Office Forms Server 2007 allows InfoPath forms to be accessed and filled out using any browser, including mobile phone browsers. ... The 2007 Microsoft Office System, also known as Microsoft Office 2007, is the most recent version of Microsofts productivity suite. ... REDIRECT [1] Categories: | ... Microsoft Office Project Server is a project management server solution made by Microsoft. ... REDIRECT [1] Categories: | ... Microsoft Office SharePoint Server (MOSS), is part of SharePoint, and runs on top of Windows SharePoint Services (WSS). ... Excel Services - Wikipedia, the free encyclopedia /**/ @import /skins-1. ... Infopath Forms Services (or Office Forms Services) is a component of Microsoft Office SharePoint Server 2007 which allows Microsoft Office InfoPath forms to be hosted in a SharePoint web site and serve them using a browser based interface. ... Screenshot from Binder Microsoft Binder was an application included with Microsoft Office designed to allow users to include several different types of files (e. ... Microsoft Data Analyzer was a data analysis software for Microsoft Office XP. Even though it was a stand alone application and was not available in any Office XP bundle, it was a part of the Office XP suite. ... Microsoft FrontPage (later full name Microsoft Office FrontPage) is a WYSIWYG HTML editor and web site administration tool from Microsoft for the Microsoft Windows line of operating systems. ... Microsoft Mail for PC Networks is a file-based E-mail system intended for corporate usage. ... Clippit asking if you need help The Office Assistant was a feature included in Microsoft Office 97 and subsequent versions until Office 2007, in which the assistants have been removed due to widespread dissatisfaction on the part of Office users. ... Microsoft PhotoDraw version 2 box Microsoft PhotoDraw 2000 is a vector graphics and raster imaging software package developed by Microsoft. ... Microsoft Photo Editor was an image-editing application found in some versions of the Microsoft Office suite. ... Microsoft Schedule Plus (or Microsoft Schedule+) was a time management software product by Microsoft, but was discontinued as part of Office when its functionality was incorporated into Outlook 97. ... Microsoft Vizact 2000 box Microsoft Vizact 2000 is a program that activated documents using HTML, adding effects such as animation. ... Office Web Components (OWC) is a collection of web components included in Microsoft Office 2000, XP and 2003. ... Microsoft Clip Organizer is Microsofts clip art organizing software. ... Microsoft Office Document Imaging (MODI) is a Microsoft Office application that supports editing documents scanned by Microsoft Office Document Scanning. ... This article is considered orphaned, since there are very few or no other articles that link to this one. ... Microsoft Office Picture Manager is a software program included with Microsoft Office suite for Windows 2003 and later. ... Smart Tags (Microsoft) This article refers to a feature of MS Office and Internet Explorer. ... Information Bridge Framework is an Office programmability framework from Microsoft Corp targeting Microsoft Office 2003 and later versions. ... Information Rights Management (IRM) is a DRM system available to users of Microsoft Office (versions 2003 and above). ... Not to be confused with OpenOffice. ... Outlook Connector running in Microsoft Outlook 2007 in Windows Vista Microsoft Office Outlook Connector is a free add-on for Microsoft Outlook. ... Visual Basic for Applications (VBA) is an implementation of Microsofts Visual Basic, an event driven programming language and associated integrated development environment (IDE) which is built into most Microsoft Office applications. ... An example of WordArt in Microsoft Office Word. ... Windows redirects here. ... Microsoft Office 2007 (officially called 2007 Microsoft Office system) is the most recent version of Microsofts productivity suite. ... Microsoft Office 14 (Office 14 for short) is the working title for the next version of the Microsoft Office System productivity suite for Microsoft Windows. ... This article relates to both the original Classic Mac OS as well as Mac OS X, Apples more recent operating system. ... Office 2004 for Mac is the current version of Microsoft Office developed for Apples Mac OS X operating system. ... A Mac OS X version of Office 2007 is also being developed, by Microsofts Macintosh Business Unit called Office 2008 and slated for release in the second half of 2007. ... This article does not cite any references or sources. ... “GFDL” redirects here. ...

A database management system (DBMS) is computer software designed for the purpose of managing databases based on a variety of data models. ... A data model is not just a way of structuring data: it also defines a set of operations that can be performed on the data. ... Database normalization, sometimes referred to as canonical synthesis, is a technique for designing relational database tables to minimize duplication of information and, in so doing, to safeguard the database against certain types of logical or structural problems, namely data anomalies. ... Database tables/indexes are typically stored in memory or on hard disk in one of many forms, ordered/unordered Flat files, ISAM, Heaps, Hash buckets or B+ Trees. ... According to Elmasri and Navathe (2004, p. ... An example of a database that has not enforced referential integrity. ... Relational algebra, an offshoot of first-order logic, is a set of relations closed under operators. ... The relational calculus refers to the two calculi, the tuple calculus and the domain calculus, that are part of the relational model for databases and that provide a declarative way to specify database queries. ... A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how those data are arranged). ... A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ... The relational model for database management is a database model based on predicate logic and set theory. ... An object-relational database (ORD) or object-relational database management system (ORDBMS) provides a relational database management system that allows developers to integrate a database with their own custom data-types and methods. ... In computer science, transaction processing is information processing that is divided into individual, indivisible operations, called Each transaction must succeed or fail as a complete unit; it cannot remain in an intermediate state. ... This article is about computing. ... For other uses, see acid (disambiguation). ... The Greek lowercase omega (ω) character is historically used by academics to represent Null in relational databases. ... In the relational model a candidate key of a relation variable (relvar) is a set of attributes of that relvar such that (1) at all times it holds in the relation assigned to that variable that there are no two distinct tuples with the same values for these attributes and... In the context of relational databases, a foreign key is a referential constraint between two tables[1]. The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. ... In database design, a primary key is a value that can be used to identify a unique row in a table. ... A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. ... A surrogate key is a unique primary key generated by the relational database management system that is not derived from any data in the database and whose only significance is to act as the primary key. ... A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. ... In database theory, a view is a virtual or logical table composed of the result set of a query. ... In relational databases, SQL databases, and flat file databases, a table is a set of data elements (values) that is organized using a model of horizontal rows and vertical columns. ... In database packages, the term cursor refers to a control structure for the successive traversal (and potential processing) of records in a result set as returned by a query. ... In in the field of databases in computer science, a transaction log (also database log or binary log) is a history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures. ... A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions. ... A database index is a data structure that improves the speed of operations in a table. ... A stored procedure is a subroutine available to applications accessing a relational database system. ... A partition is a division of a logical database or its constituting elements into distinct independent parts. ... SQL (IPA: or ) is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ... An SQL SELECT statement returns a result set of records from one or more tables. ... A SQL INSERT statement adds one or more records to a table in a relational database. ... An UPDATE statement in SQL changes data in one or more records in a relational database management system. ... Wikipedia does not have an article with this exact name. ... An SQL DELETE statement removes one or more records from a table. ... A JOIN clause in SQL combines records from two tables in a relational database and results in a new (temporary) table, also called a joined table. Structured Query Language (SQL:2003) specifies two types of joins: inner and outer. ... In SQL the UNION operator combines the results of two SQL queries into a single table of all matching rows. ... A CREATE statement in SQL creates an object inside of a relational database management system (RDBMS). ... A DROP statement in SQL removes an object from a relational database management system (RDBMS). ... It has been suggested that this article or section be merged into Database transaction. ... A COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users. ... In database technologies, a rollback is an operation which returns the database to some previous state. ... The Truncate statement removes all the data from a table. ... An ALTER statement in SQL changes the properties of an object inside of a relational database management system (RDBMS). ... A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how those data are arranged). ... A simple diagram depicting conversion of a CSV-format flat file database table into a relational database table. ... A deductive database system is a database system which can make deductions (ie: infer additional rules or facts) based on rules and facts stored in the (deductive) database. ... A dimensional database is one which, rather than representing data in multiple relations (as a relational database does), represents key data entities as different dimensions. ... In a hierarchical data model, data are organized into a tree-like structure. ... The network model is a database model conceived as a flexible way of representing objects and their relationships. ... In an object database (also object oriented database), information is represented in the form of objects as used in object-oriented programming. ... An object-relational database (ORD) or object-relational database management system (ORDBMS) provides a relational database management system that allows developers to integrate a database with their own custom data-types and methods. ... A temporal database is a database management system with built-in time aspects, e. ... An XML database is a data persistence software system that allows data to be imported, accessed and exported in the XML format. ... In computer science -- more specifically, in the field of databases -- concurrency control is a method used to ensure that database transactions are executed in a safe manner (i. ... A data dictionary is a set of metadata that contains definitions and representations of data elements. ... JDBC is an API for the Java programming language that defines how a client may access a database. ... In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). ... Query languages are computer languages used to make queries into databases and information systems. ... The query optimizer is a component of database management system that is used to analyzes queries submitted to database server for execution, and then determines the optimal way to execute the query. ... A query plan (or query execution plan) is an set of steps used to access information in a SQL relational database management system. ... The following is a list of object-oriented database management systems. ... This article or section is not written in the formal tone expected of an encyclopedia article. ... See DBMS for a shorter list of “typical”, representative database management systems. ... The following tables compare general and technical information for a number of relational database management systems. ...

External links

• Microsoft Access Home Page
• Microsoft Access Newsgroups
• A FAQ site about Microsoft Access
• Microsoft Access for Beginners

References